Oracle Database 12c: Performance Management and Tuning: 1z0-064 Exam Premium File as PDF & Test Engine

From the free demo to instant delivery, from 365 days of updates to a money-back guarantee, Fast2test covers every step of your Oracle Database 12c: Performance Management and Tuning journey in 2026. Pick your 1z0-064 package, work through 120 expert-verified questions, and book your exam with confidence.

Oracle 1z0-064 Exam Overview:

Oracle 1z0-064 Exam Syllabus Topics:

Oracle 1z0-064 FAQs: What Every Candidate Asks

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

Question 1

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. increasing the size of the PGA
B. creating a bitmap index on the COUNTRY_ID column
C. creating a SQL profile
D. regathering statistics on the CUSTOMERS table
E. creating a KEEP cache
F. creating a histogram on the COUNTRY_ID column

Question 2

As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?

A. Set the PUBLISH statistic preference to FALSE, gather statistics, capture the workload in a SQL Tuning Set (STS), and submit the STS to SQL Tuning Advisor.
B. Capture the workload in an STS and submit to SQL Tuning Advisor as an input to generate recommendations for indexes and SQL profiles.
C. Capture the workload in an STS and submit to SQL Access Advisor as an input to generate recommendations for indexes and materialized views.
D. Capture the workload, set the OPTIMIZER_USE_PENDING_STATISTICS to FALSE, and then replay the workload.

Question 3

You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base.
Examine the parameters:

Which two statements are true in this scenario?

A. The SQL plan baselines are used by the SQL statements and ensure that the best plan is used.
B. The SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.
C. The SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.
D. The SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.

Question 4

You execute this query twice in a session:

Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.

Which two statements are true? (Choose two.)

A. The second execution of the query was hard parsed because the estimated cardinality was inaccurate.
B. The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.
C. No statistics were collected during the first execution of the query.
D. A subsequent execution of the query in this session will undergo a hard parse.
E. A subsequent execution of the query in this session is likely to undergo a soft parse.

Question 5

You are administrating a database that supports a DSS workload. Syntactically similar queries using joins and aggregate functions are frequently executed by users to fetch data from remote databases by using database links.
Which three tasks should you perform to improve the performance of these queries?

A. Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the local database instance.
B. Ensure that the RESULT_CACHE_MAX_RESULT parameter is set to 100.
C. Ensure that the RESULT_CACHE_MAX_MODE parameter is set to FORCE for the local instance.
D. Ensure that the RESULT_CACHE_MODE parameter is set to FORCE for remote database instances.
E. Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on both the local and remote database instances.
F. Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the remote database instance.
G. Ensure that the RESULT_CACHE_REMOTE_EXPIRATION parameter is set to a nonzero value for the local instance.

Solutions: