多选题You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table

第1题：

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）

• A、Set metric threshold
• B、Implement Database Resource Manager
• C、Enable resumable timeout for user sessions
• D、Add directives to Automatic Database Diagnostic Monitor (ADDM)

第2题：

Oracle数据中，下列哪些等待事件将产生大量的IO？（）

• A、log file parallel write
• B、latch：cache buffers chains
• C、db file sequential read
• D、db file scattered read

第3题：

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

• A、 take data files from the read-only tablespace offline before performing a recovery
• B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
• C、 drop the read-only tablespace and re-create the tablespace after recovery
• D、 perform a recovery； status of the tablespace in control file will be changed automatically

第4题：

The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

• A、These are the data files that are corrupted.
• B、There is no SYSAUX tablespace in your database
• C、There is a read­only tablespace in your database.
• D、These are the data files that cannot be recovered.

第5题：

You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

• A、drop the read­only tablespace and re­create the tablespace after recovery
• B、take data files from the read­only tablespace offline before performing a recovery
• C、perform a recovery; status of the tablespace in control file will be changed automatically
• D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

第6题：

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）

• A、Decreasing PCTUSED
• B、Decreasing PCTFREE
• C、Increasing the number of DBWN process
• D、Using Automatic Segment Space Management (ASSM)
• E、Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

第7题：

The loss of the control file forced you to re-create the control file. After re-creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five-digit number starting with 0. What could be the possible reason？（）

• A、 These are the data files that are corrupted.
• B、 There is no SYSAUX tablespace in your database
• C、 There is a read-only tablespace in your database.
• D、 These are the data files that cannot be recovered.

第8题：

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）

• A、It detects any configuration change that caused a performance difference in both time periods.
• B、It identifies any workload change that caused a performance difference in both time periods.
• C、It detects the top wait events causing performance degradation.
• D、It shows the resource usage for CPU, memory, and I/O in both time periods.
• E、It shows the difference in the size of memory pools in both time periods.
• F、It gives information about statistics collection in both time periods.

第9题：

第10题：

第11题：

第12题：

第13题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第14题：

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

• A、Memory Advisor
• B、Segment Advisor
• C、SQL Tuning Advisor
• D、SQL Access Advisor
• E、Automatic Database Diagnostic Monitor （ADDM）

第15题：

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、 Memory Advisor
• B、 Segment Advisor
• C、 SQL Access Advisor
• D、 Automatic Workload Repository （AWR）
• E、 Automatic Database Diagnostic Monitor （ADDM）

第16题：

One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

• A、drop and re­create the read­only tablespaces
• B、rename the read­only data files to their correct file names
• C、change the tablespace status from read/write to read­only
• D、re­create the read­only tablespace because it is automatically removed

第17题：

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.（）

• A、Missing or stale histogram statistics
• B、Undersized shared pool
• C、High clustering factor for the indexes
• D、High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• E、Oversized buffer cache

第18题：

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

第19题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）

• A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.
• B、In a query execution plan， you should look for queries with missing or out-of-date statistics.
• C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.
• D、In a query execution plan， you should look for queries with a large number of table scans.

第20题：

第21题：

第22题：

第23题：