单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）A During a query’s parse time only. B During a query’s execution time only. C During any kind of DML statement execution. D During the execution of an INSERT statement only.

第1题：

第2题：

You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

• A、It degrades the run time and compiler performance.
• B、It provides better run time and compiler performance.
• C、It provides better optimization of the statement during parse time.
• D、It forces the rule based optimizer to be used for statement optimization.
• E、It provides better run time performance but slightly degraded compiler performance. 
• F、It provides better run time performance but slightly degraded run time performance.

第3题：

第4题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

• A、 To recover a dropped table.
• B、 To recover a dropped schema.
• C、 To recover data from a truncated table.
• D、 To view changes made by all the transactions during a given period of time.
• E、 To view changes made by a single transaction during a given period of time.

第5题：

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）

• A、Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
• B、A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）
• C、When a resumable statement is suspended, the transaction that contains the statement is also suspended.
• D、A resumable statement can only be suspended and resumed once during the execution of the statement.
• E、You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

第6题：

第7题：

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

• A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
• B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
• C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
• D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.

第8题：

第9题：

You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

• A、 Every SQL statement in the STS is considered only once for execution.
• B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
• C、 The execution plan and execution statistics are computed for each SQL statement in the STS. 
• D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.

第10题：

You issued the following statement to monitor the usage of the index：        SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；   Which view will you query to ensure that the index is being monitored？（）  

• A、 INDEX_STATS
• B、 DBA_INDEXES
• C、 DBA_IND_COLUMNS
• D、 V$OBJECT_USAGE