Get an edge on your Oracle Database 12c: Performance Management and Tuning journey with premium 1z1-064 practice tests from Actual4Labs. We offer 120 questions with comprehensive updates throughout 2026, giving you the exact preparation you need.

Oracle 1z1-064 Exam Overview:

Oracle 1z1-064 Exam Syllabus Topics:

Frequently Asked Questions About Oracle Database 12c: Performance Management and Tuning

Oracle Database 12c: Performance Management and Tuning Sample Questions:

Question 1

You are administrating a database that supports an OLTP workload. A few users complain about the poor performance of some SQL statements. You notice that these SQL statements belong to different applications and conclude that there is no correlation between them. You create a SQL Tuning Set (STS) containing these SQL statements.
What must you do to analyze and generate recommendations for the SQL statements in the STS?

A. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for indexes or SQL profiles or both.
B. Submit the STS as input to the SQL Performance Analyzer to generate recommendations for creating indexes and materialized views.
C. Submit the STS as input to the SQL Access Advisor to generate recommendations for SQL profiles.
D. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for SQL plan baselines.

Question 2

Which two statements are true about ADDM? (Choose two.)

A. It first identifies the performance symptoms, and then refines them to reach the root cause with the singular aim of reducing the DB CPU metric.
B. It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.
C. It documents only those components and wait classes that are significantly impacting the performance of the database.
D. It analyzes the performance of a database instance based on the time period covered by the most recent AWR snapshot, and generates recommendations based on hard-coded criteria.
E. ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.

Question 3

Examine the query and its output:

Which two statements are true? (Choose two.)

A. Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already locked rows, and there is no free ITL slot available in this block.
B. Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.
C. Session 3346 is in wait state because either it is waiting to update a row that is locked by another session or another session is trying to insert the same key value in a UNIQUE index.
D. Session 4208 is definitely idle and should be killed to free network resources.
E. Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.

Question 4

You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)

A. Check whether the table is frequently updated because it will have overhead for insert and update operations.
B. Check whether the table is frequently queried using full table scans as column store compression only minimizes I/O during full table scans.
C. Check whether the table blocks are sparsely populated as this will defragment the blocks.
D. Check whether direct path load operations are used to insert rows in the table.
E. Check whether the table has LOB columns as it will minimize I/O for the queries.

Question 5

Your database supports an OLTP system.
Examine the parameter values configured in your database:

The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS');
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform a series of INSERT, UPDATE, and DELETE operations on the table.
View the Exhibit to examine the query and its execution plan.

Which three options would improve the performance of the query? (Choose three.)

A. creating a KEEP cache
B. creating a bitmap index on the COUNTRY_ID column
C. creating a SQL profile
D. increasing the size of the PGA
E. regathering statistics on the CUSTOMERS table
F. creating a histogram on the COUNTRY_ID column

Solutions: