Oracle Database 12c: Performance Management and Tuning - 1z1-064 Exam Practice Test

Examine the Load Profile and partial Top 10 Foreground Events by Total Wait Time sections from an AWR report.

Which two areas should you examine next to identify possible bottlenecks?
Correct Answer: B,D
You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)
Correct Answer: A,E
Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)
Correct Answer: A,D
Your database supports multiple applications. The applications run on the middle tier and use connection for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this?
Correct Answer: D
You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.
Examine the parameters set for the instance:

Which three tasks would you perform to improve the performance of these queries? (Choose three.)
Correct Answer: B,C,E
Your database supports an OLTP workload.
An application frequently performs update operations on an indexed column of a table; some bulk delete and insert operations are also performed.
The table is created in a locally managed tablespace with manual segment space management.
A user complains about poor response time when querying the table.
The queries mostly perform index range scans.
You notice a high number of buffer busy waits and contention on segment headers.
Which three would you investigate further to diagnose the poor response time?
Correct Answer: B,C,D
Examine the parameters set for a database instance:

The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:

Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)
Correct Answer: B,D
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
Correct Answer: E
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
Correct Answer: D,E
Your database supports an OLTP workload where a large number of syntactically similar queries are executed. Examine the Instance Efficiency Percentages in the Automatic Workload Repository (AWR) report of the last hour:

Which two inferences can be drawn from the report?
Correct Answer: B,D