多选题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. Whi

第1题：

第2题：

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）

第3题：

第4题：

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）

第5题：

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

• A、Compare Period ADDM report
• B、AWR Compare Period report
• C、Active Session History (ASH) report
• D、Taking a new snapshot and comparing it with a preserved snapshot

第6题：

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

• A、create baseline metrics for today’s performance
• B、write the current database metrics to a database table and create a trigger to compare with future database statistics
• C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
• D、write the current database metrics to a database table and create a procedure to compare with future database statistics
• E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

第7题：

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

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

第8题：

第9题：

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

• A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

第10题：

You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）

• A、Enable Memory Access Mode, which reads performance data from SGA.
• B、Use emergency monitoring to fetch data directly from SGA analysis.
• C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E、Run ADDM in diagnostic mode.