Oracle Database 12c: Performance Management and Tuning Free Practice Exam Questions

14 real Oracle Database 12c: Performance Management and Tuning exam questions with answers and AI explanations. Oracle certification prep — page 1 of 2.

  1. Question 1: You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issu…
  2. Question 2: 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…
  3. Question 3: In which three situations can dynamic statistics be used? (Choose three.)
  4. Question 4: You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them. Which t…
  5. Question 6: Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind vari…
  6. Question 8: Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
  7. Question 9: You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics…
  8. Question 12: You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views.…
  9. Question 14: In which three situations does DB time always increase? (Choose three.)
  10. Question 15: Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)