Oracle 1z1-064 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-064
Exam Name/Title: Oracle Database 12c: Performance Management and Tuning
Certification Provider: Oracle
Corresponding Certification: Oracle Database

Exam Questions: 120
Updated On: Sep 23, 2026

Question #11

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 blocks are sparsely populated as this will defragment the blocks.

B. Check whether the table has LOB columns as it will minimize I/O for the queries.

C. Check whether direct path load operations are used to insert rows in the table.

D. Check whether the table is frequently updated because it will have overhead for insert and update operations.

E. Check whether the table is frequently queried using full table scans as column store compression only minimizes I/O during full table scans.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #12

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

A. the SQL statements based on elapsed time from the AWR report

B. the Time Model Statistics section of the AWR report

C. the Latch Activity section

D. the Segment Statistics section of the AWR report

E. the V$ACTIVE_SESSION_HISTORY view

Discussion 0

Correct Answer: B Vote an answer

Question #13

The CUSTOMERS table has 55,500 rows and 620 distinct values in the CUST_CITY_ID column. The number of popular values is 54 and less than 99% of the rows contain popular values.
Which type of histogram should you create to accurately determine the cardinality estimate on the CUST_CITY_ID column?

A. height-balanced histogram

B. frequency histogram

C. hybrid histogram

D. high-frequency histogram

Discussion 0

Correct Answer: A Vote an answer

Question #14

Examine the Time Model Statistics section of an AWR report:

Which two inferences can be definitely derived from this section? (Choose two.)

A. A large number of connected user sessions were idle.

B. The available CPU resources were not utilized to their maximum capacity.

C. All sequence numbers used during this AWR time interval were cached.

D. New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.

E. The DB CPU time was not spent exclusively for processing SQL statements.

Discussion 0

Correct Answer: D,E Vote an answer

Question #15

Which three statements are true about the TEST EXECUTE method of the SQL Performance Analyzer?

A. The SQL statements in the SQL Tuning Set (STS) are executed at least twice for both pre-change and post-change trials.

B. The execution statistics generated for SQL statements are analyzed to check whether they have improved or regressed.

C. An execution plan and statistics are generated for SQL statements only in the pre-change trial.

D. An execution plan and statistics are computes for each SQL statement in the STS.

E. The SQL statements in the STS are compared only on elapsed time for the pre-change and post-change trials.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #16

Examine the command:
SQL> ALTER SYSTEM SET TEMP_UNDO_ENABLED = TRUE;
Which two statements are true about setting the parameter value to TRUE?

A. It reduces the amount of redo generated for DML operations performed on temporary tables.

B. It improves performance because DML and DDL operations performed on temporary tables do not use the database buffer cache and redo log buffer.

C. It reduces the amount of undo stored in the undo tablespace.

D. It improves database performance by reducing the overhead on the PGA.

Discussion 0

Correct Answer: C,D Vote an answer

Question #17

You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

A. A large number of blocks are fetched from disks frequently.

B. Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.

C. Several full table scans are performed by transactions.

D. DBWR is not writing the dirty buffers fast enough.

E. The database buffer cache is inadequately sized.

F. Blocks are aging out of the buffer cache frequently.

Discussion 0

Correct Answer: A,B,D,F Vote an answer

Question #18

You want to set a priority for the workloads generated by the applications in your database instance such that report-generating tasks are assigned a lower priority.
How would you do this?

A. by using services for the applications and creating job classes associated with each service

B. by creating an active session pool using the Resource Manager

C. by using job classes with the Resource Manager

D. by using services that are assigned different priorities with the Resource Manager

Discussion 0

Correct Answer: D Vote an answer

Question #19

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

A. It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.

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

C. It documents only those components and wait classes that are significantly impacting the performance of the database.

D. ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.

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

Discussion 0

Correct Answer: B,C Vote an answer

Question #20

Your database supports an OLTP workload where applications primarily perform small random I/Os. You notice an increase in the I/O requests queued up against the storage, and an increase in the wait time in queue. The database uses file system storage.
What would you recommend to decrease the wait time of I/O requests?

A. Increase the value of the DB_WRITER_PROCESSES parameter.

B. Increase the size of the buffer cache.

C. Decrease the value of the DBWR_IO_SLAVES parameter.

D. Suggest storage admin to add more disks (spindles) to storage and stripe data across disks.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1z1-064 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-064 exam.