Online Access Free 1Z0-084 Exam Questions

Which procedure gathers statistics that are always used in the generation of any execution plan?

• A.DBMS_STATS.GATHER_DICTIONARY_STATS
• B.DBMS_STATS.GATHER_DATABASE_STATS
• C.DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS
• D.DBMS_STATS.GATHER_SYSTEM_STATS

Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000', DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1', DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

• A.A critical alert will be issued when CPU time exceeds 2 minutes for each user call.
• B.A warning alert will be issued when CPU time exceeds 1 minute for each user call.
• C.A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.
• D.A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

• A.SQL Plan Directives
• B.Dynamic Statistics
• C.Automatic Reoptimization
• D.Statistics Feedback
• E.Statistics Collector

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?

• A.It requires a database instance restart to take effect.
• B.All SGA components retain their current sizes at the time of disabling.
• C.Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.
• D.The SGA size remains unaffected after disabling ASMM.
• E.All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.
• F.All auto-tuned SGA components are reset to their original user-defined values.

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

• A.The proportion of WAIT TIME to CPU TIME always increases with increased system load.
• B.Parse Time Elapsed accounts for successful soft and hard parse operations only.
• C.Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.
• D.Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.
• E.When WAIT TIME is high, instance tuning may improve performance.
• F.DB Time accounts for all time used by background processes and user sessions.