View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_speci

第1题：

第2题：

第3题：

第4题：

Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）

• A、It is ignored by the query optimizer.
• B、It is not used while the index is being rebuilt.
• C、The index cannot be rebuilt， and has to be re-created.
• D、The index is automatically rebuilt when used the next time

第5题：

Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）

• A、The optimizer used a dynamic plan for the query.
• B、The optimizer chose different plans because automatic dynamic sampling was enabled.
• C、The optimizer used re-optimization cardinality feedback for the query.
• D、The optimizer chose different plan because extended statistics were created for the columns used.

第6题：

As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP；  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED  

• A、 The DGROUP1 disk group was unmounted by another DBA.
• B、 A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• C、 One of the redundant disks （DGROUP1） has been lost in a disk group.
• D、 This query has no meaning in an ASM instance.
• E、 A disk associated with a disk group was discovered after the ASM instance initially opened.

第7题：

A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

• A、granting SELECT privilege to SMITH on V$SESSION
• B、granting SELECT privilege to SMITH on V_$SESSION
• C、asking the user SMITH to run the catalog.sql script
• D、granting SELECT privilege to SMITH on V$FIXED_TABLES
• E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
• F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

第8题：

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

• A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
• B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

第16题：

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）

• A、Bind Variable Peeking
• B、SQL Plan Baselines
• C、Adaptive Cursor Sharing
• D、Bind variable used in a SQL statement
• E、Literals in a SQL statement

第17题：

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）

• A、An Automatic Workload Repository snapshot has been taken recently.
• B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
• C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
• D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

第18题：

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）

• A、Because the progress is reported for each data file
• B、Because the progress is reported for each backup set
• C、Because other RMAN sessions have issued the same BACKUP command
• D、Because new data files have been added to the database while the RMAN backup is in progress

第19题：

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）

• A、 4
• B、 8
• C、 7
• D、 0

第20题：

第21题：

第22题：

第23题：