Oracle 1z0-064 問題集

質問 1：
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. Capture the workload, set the OPTIMIZER_USE_PENDING_STATISTICS to FALSE, and then replay the workload.
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. 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.
D. Capture the workload in an STS and submit to SQL Access Advisor as an input to generate recommendations for indexes and materialized views.
正解：D

質問 2：
A parallel SQL statement is taking a long time to execute. You want to verify how the server processes are dividing work.
How should you determine this?
A. by using SQL Tuning Advisor
B. by using ASH
C. by using services
D. by using Real-Time ADDM
E. by using Real-Time SQL monitoring
正解：C

質問 3：
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 Time Model Statistics section of the AWR report
B. the Segment Statistics section of the AWR report
C. the SQL statements based on elapsed time from the AWR report
D. the Latch Activity section
E. the V$ACTIVE_SESSION_HISTORY view
正解：A

質問 4：
Examine the parameters:

Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and a high number of direct path write wait events.
Which two actions could improve the performance? (Choose two.)
A. enabling Automatic Memory Management for the instance
B. increasing the value of the PGA_AGGREGATE_TARGET parameter
C. enabling Automatic Shared Memory Management for the instance
D. increasing the size of the default temporary tablespace
E. increasing the value of the SORT_AREA_SIZE parameter
F. using parallel hint in queries performing large sort operations
正解：C,E

質問 5：
Which two statements are true about Active Session History (ASH)? (Choose two.)
A. The Data Sample size available in an ASH report is dynamic and, at any given moment, is directly related to the amount of work being performed.
B. An ASH report can be used to identify the service that may be the cause of a transient performance problem.
C. ASH contains sampled data from all sessions that are connected to a database instance at any given moment.
D. ASH samples data from V$SESSION every second.
正解：B,D

質問 6：
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 increase the number of concurrent users during replay
B. to reduce the elapsed time between two successive user calls from a session.
C. to reduce the time of replay
D. to decrease the wait for a query, caused by noncommitted transactions
E. to decrease the number of concurrent users during replay
正解：A,C,D