Online Access Free 1z0-064 Exam Questions

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.Increase the number of DBWn processes.
• B.Enable Automatic Shared Memory Management.
• C.Increase the value of the PGA_AGGREGATE_TARGET parameter.
• D.Increase the value of the SGA_TARGET parameter.
• E.Enable temporary undo.
• F.Enable Automatic Memory Management.

For which two tasks would you recommend the use of a repeating baseline template?

• A.to capture AWR data during a system test that is scheduled for a weekend
• B.to capture AWR data for a specified contiguous time period on an ongoing basis
• C.to capture user activity information for a consumer group over a specified period of time
• D.to capture AWR data for a scheduled job that runs every day over a specified period of time
• E.to capture statistics performance variation over a specified period of time

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 Access Advisor
• C.SQL Tuning Advisor
• D.Automatic Workload Repository (AWR) compare periods report
• E.Automatic Database Diagnostic Monitor (ADDM) compare periods report
• F.SQL Performance Analyzer

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 the sampling time is a small fraction of the total time for a query
• C.when an execution plan is suboptimal because of complex predicates
• D.when extended statistics are not available for SQL statements that use complex predicates
• E.when index statistics are missing on a column that is used in SQL statements with highly selective filters

A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay.
What three could be reasons for this change? (Choose three.)

• A.to reduce the time of replay
• B.to decrease the number of concurrent users during replay
• C.to reduce the elapsed time between two successive user calls from a session.
• D.to increase the number of concurrent users during replay
• E.to decrease the wait for a query, caused by noncommitted transactions