Free Oracle 1z0-064 Exam Dumps Questions & Answers

You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)

• A.  Database Replay
• B.  SQL Performance Analyzer
• C.  Automatic Database Diagnostic Monitor (ADDM) compare periods report
• D.  Automatic Workload Repository (AWR) compare periods report
• E.  SQL Tuning Advisor
• F.  SQL Access Advisor

Examine the parameters set for a database instance:

The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:

Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)

• A.  Enable Automatic Memory Management.
• B.  Enable temporary undo.
• C.  Increase the value of the PGA_AGGREGATE_TARGET parameter.
• D.  Increase the number of DBWn processes.
• E.  Enable Automatic Shared Memory Management.
• F.  Increase the value of the SGA_TARGET parameter.

Examine the query and its execution plan:

Explained.


Which two interpretations are correct?

• A.  The SORT UNIQUE operation applies only the CUST_MAIN table.
• B.  The Id 0 step indicates the cost of the entire plan.
• C.  Id 3 is the first step executed.
• D.  Id 4 is the second step executed.

Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)

• A.  Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.
• B.  Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.
• C.  Create services for the applications and set a relative priority by assigning them to application users.
• D.  Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.

In which three situations can dynamic statistics be used? (Choose three.)

• A.  when a query is on a partitioned table with a global index
• B.  when extended statistics are not available for SQL statements that use complex predicates
• C.  when an execution plan is suboptimal because of complex predicates
• D.  when the sampling time is a small fraction of the total time for a query
• E.  when index statistics are missing on a column that is used in SQL statements with highly selective filters