单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）AThe SQL trace facility will generate the performance statistics for all the SQL statements for 

第1题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

• A、 The database will not start.
• B、 The database will start but will not retain the undo data in the undo segment.
• C、 The database will start， and the undo segment will contain the undo data for at least one hour.
• D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

第2题：

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

• A、Execute the query and view Active Session History (ASH) for information about the query.
• B、Enable SQL trace for the query.
• C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
• D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

第3题：

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

• A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
• B、 Capture the plans from the previous version using STS and then load them into the stored outline.
• C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
• D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

第4题：

You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）  

• A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
• B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
• C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
• D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

第5题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第6题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

• A、 SQL Tuning Advisor
• B、 Undo Advisor
• C、 ADDM
• D、 Memory Advisor

第14题：

You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）  

• A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
• B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
• C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
• D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

第15题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、The EVENT parameter was not set.
• B、The SQL_TRACE parameter is set to FALSE
• C、The Enterprise Manager Grid Control is not used.
• D、The STATISTICS_LEVEL parameter is set to BASIC
• E、The TIMED_STATISTICS parameter is set to FALSE

第16题：

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.

第17题：

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

• A、run Segment Advisor
• B、run SQL Tuning Advisor on top SQL statements
• C、run the Automatic Workload Repository （AWR） report
• D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：