Oracle 1Z0-084 問題集

質問 1：
You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?
A. V$SESSION
B. V$SESSION_LONGOPS
C. V$RMAN_BACKUP_JOB_DETAILS
D. V$SESSTAT
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine this statement and output:

Which two situations can trigger this error?
A. The syntax is incomplete.
B. The capture directory is part of the root file system.
C. The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.
D. The instance is unable to access the capture directory.
E. There is a file in the capture directory.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two types of performance problems are reported by ADDM for PDBS?
A. Top SQL statements
B. I/O capacity limits
C. User I/O waits
D. SGA sizing issues
E. Excessive checkpoint writes
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:

Which two actions can help reduce the number of these waits7
A. increasing the value of DBWRITERPROCESSES to 64,
B. reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64
C. increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128
D. Increasing the size of MEMORYTARGET
E. setting dbwr_io_slaves to 64
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true about cursor sharing?
A. Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time.
B. Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
C. Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.
D. Setting Cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables.
E. Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7
A. optimizer_dynamic_sampling=11
B. optimizer_features_enable=12.2.0.1
C. optimizer_adaptive_plans=TRUE
D. optimizer_adaptive_statistics = TRUE
E. optimizer_capture_sql_plan_baselines_TRUE
正解：D
解説: (Topexam メンバーにのみ表示されます)