1Z0-064 Exam Questions & Answers

Exam Code: 1Z0-064

Exam Name: Oracle Database 12c: Performance Management and Tuning

Updated: Mar 25, 2024

Q&As: 119

At Passcerty.com, we pride ourselves on the comprehensive nature of our 1Z0-064 exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.


Download Free Oracle 1Z0-064 Demo

Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Oracle 1Z0-064 exam.

Instant download
Latest update demo according to real exam

*Email Address

* Our demo shows only a few questions from your selected exam for evaluating purposes

Free Oracle 1Z0-064 Dumps

Practice These Free Questions and Answers to Pass the Oracle Database Exam

Questions 1

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

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

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

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

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

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

Show Answer
Questions 2

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

A. Use the Resource Manager.

B. Enable SQL Trace at the session level.

C. Create a service.

D. Use a dedicated server configuration.

E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

Show Answer
Questions 3

You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.

Examine the parameters set for the instance: Which three tasks would you perform to improve the performance of these queries? (Choose three.)

A. Gather statistics for the objects used in the queries.

B. Use the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve new plans and fix the plans for the statements.

C. Create a SQL Tuning Set (STS) and run it through the SQL Access Advisor to generate recommendations.

D. Create an STS and run it through the SQL Tuning Advisor to generate recommendations.

E. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

F. Use the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function to alter the accepted plans as fixed plans.

Show Answer
Questions 4

Examine the query and its execution plan:

Explained.

Which two interpretations are correct?

A. Id 3 is the first step executed.

B. The Id 0 step indicates the cost of the entire plan.

C. Id 4 is the second step executed.

D. The SORT UNIQUE operation applies only the CUST_MAIN table.

Show Answer
Questions 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 bitmap index on the COUNTRY_ID column

B. regathering statistics on the CUSTOMERS table

C. creating a histogram on the COUNTRY_ID column

D. increasing the size of the PGA

E. creating a SQL profile

F. creating a KEEP cache

Show Answer

Viewing Page 1 of 3 pages. Download PDF or Software version with 119 questions