Datasheet

50
Chapter 1
Using Oracle ASM
12. To reference existing ASM files, you need to use a fully qualified ASM filename. Your
development database has a disk group named DG2A, the database name is DEV19, and the
ASM file that you want to reference is a datafile for the USERS02 tablespace. Which of the
following is a valid ASM filename for this ASM file?
A. dev19/+DG2A/datafile/users02.701.2
B. +DG2A/dev19/datafile/users02.701.2
C. +DG2A/dev19/users02/datafile.701.2
D. +DG2A.701.2
E. +DG2A/datafile/dev19.users.02.701.2
13. Which background process coordinates the rebalance activity for disk groups?
A. ORBn
B. OSMB
C. RBAL
D. ASMn
14. On the development database rac0, there are six raw devices: /dev/raw/raw1 through
/dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB
each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and
/dev/raw/raw2. Which series of the following commands will drop one of the failure
groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw
devices, and then cancel the drop operation from +DATA1?
A. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B DISK
‘/dev/raw/raw4’;ALTER DISKGROUP DATA1 UNDROP DISKS;
B. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 HIGH
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B
DISK ‘/dev/raw/raw4;’ALTER DISKGROUP DATA1 UNDROP DISKS;
C. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B DISK
‘/dev/raw/raw4’;ALTER DISKGROUP DATA1 UNDROP DATA1_0001;
D. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001 ADD DISK GROUP DATA2 NORMAL
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B DISK
‘/dev/raw/raw4’;ALTER DISKGROUP DATA1 UNDROP DISKS;
15. Which type of database file is spread across all disks in a disk group?
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
95134c01.indd 50 1/28/09 9:43:48 AM