单选题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题：

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.

第2题：

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.

第3题：

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.

第4题：

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

• 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.
• 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

第5题：

Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）

• A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B、The optimizer can re optimize a query only once using cardinality feedback.
• C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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.

第15题：

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

第16题：

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.

第17题：

Which is an example of a dynamic SELECT statement? （）

• A、A query whose object names change during its execution. 
• B、A query whose object names are not known until run time. 
• C、A query whose bind variables values change during execution. 
• D、A query whose bind variable values are not known until run time.

第18题：

You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）

• A、A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
• B、All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
• C、A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
• D、A TOP-N query is created to limit the rows to 20 percent of the total rows

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：