1Z0-060

单选题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 reportB AWR Compare Period reportC Active Session H

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

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：A, B, E

第2题：

A technician wants to compare a new server performance over a period of time. Which of the following should the technician do FIRST?（）

  • A、Monitor processor performance logs
  • B、Constantly check the task manager
  • C、Use performance server logs
  • D、Establish a baseline for the server

正确答案:D

第3题：

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;


参考答案：C

第4题：

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.

正确答案:B

第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

正确答案:B

第6题：

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


参考答案：B

第7题：

You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

  • A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
  • B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
  • C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
  • D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

正确答案:D

第8题：

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade


参考答案：A, C, E

第9题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

  • A、 use DBMS_IJOB package
  • B、 use Oracle Scheduler
  • C、 use DBMS_JOB package
  • D、 use Oracle Data Pump Export and Import

正确答案:B

第10题：

Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.  You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.  Choose two actions any of which can be referred to first to diagnose the problem. （）

  • A、Use the Active Session History report.
  • B、Use the AWR Compare Periods report.
  • C、Use an ADDM analysis between 7 PM and 9 PM of the previous day.
  • D、Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

正确答案:B,C

更多相关问题
相关内容