Oracle Database 12c Performance Management and Tuning

Here you have the best Oracle 1z0-064 practice exam questions

  • You have 84 total questions to study from
  • Each page has 5 questions, making a total of 17 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 22, 2025
  • This site is not affiliated with or endorsed by Oracle.
Question 1 of 84
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)
    Correct Answer: B, D, E

Question 2 of 84
Examine the partial TKPROF output for an SQL statement:
Exam 1z0-064: Question 2 - Image 1
Which two inferences can definitely be made from this output? (Choose two.)
    Correct Answer: B, D

Question 3 of 84
In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert.
What is the outcome? (Choose the best answer.)
    Correct Answer: A

Question 4 of 84
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)
    Correct Answer: D

Question 5 of 84
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
    Correct Answer: C, E