Oracle 1Z0-053 問題集

質問 1：
Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)
A. ALTER DISKGROUP misc DROP DISK misc2;
B. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
E. ALTER DISKGROUP misc MOUNT;
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
A. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
B. The ASM-preferred mirror read feature is enabled.
C. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
正解：B,C

質問 3：
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)
A. FOREGROUND_DUMP_DEST
B. USER_DUMP_DEST
C. DIAGNOSTIC_DEST
D. BACKGROUND_DUMP_DEST
E. CORE_DUMP_DEST
F. All of the above
正解：B,D,E

質問 4：
Within a resource-plan definition, what differentiates a top-level plan from a subplan?
A. A subplan always has the CPU_MTH parameter value set to RATIO.
B. There is no difference in the resource-plan definition.
C. The string TOP_LEVEL is appended to the name of top-level resource plans.
D. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.
E. A subplan has the PLAN_SUB parameter value set to SUB.
正解：B

質問 5：
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
A. Local and global indexes are maintained automatically during the operation.
B. It does not require additional storage because the operation is done online.
C. It cannot be done in parallel.
D. It can be done at the table level or partition level.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)
A. CREATE_BITMAP_AREA_SIZE
B. HASH_AREA_SIZE
C. PGA_AGGREGATE_TARGET
D. SORT_AREA_SIZE
E. BITMAP_MERGE_AREA_SIZE
正解：A,B,D,E

質問 7：
RMAN provides more granular catalog security through which feature?
A. Virtual private database
B. Oracle Database Vault
C. Virtual private catalog
D. RMAN secure catalog
E. RMAN virtual database
正解：C
解説: (Topexam メンバーにのみ表示されます)