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.)

limiting the amount of time that a session is idle and blocking other sessions of the ERP application

limiting the amount of undo generated by operations performed by sessions created by the ERP application

creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload

allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application

limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

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.)

Array fetch operations were not performed for this query.

No hard parse was performed for this query.

The number of logical I/Os is almost equal to the number of physical I/Os.

Another transaction held a shared lock on the table, thereby causing a significant delay.

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.)

It generates an error because the warning threshold cannot exceed 100%.

It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.

It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.

It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.

It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.

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.)

Create AWR baselines.

Create SQL plan baselines.

Create repeating baseline templates.

Create database services and make sure that user connections use them to connect to the database instance.

Create a single baseline template.

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.)

setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors

coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required

setting the CURSOR_SHARING parameter to EXACT

avoiding the granting of privileges on objects associated with cursors during peak load

enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE

configuring shared server connections

Correct Answer: C, E