Home
  • Home
  • Database
  • Oracle Database 11g Administrator Certified Professional (OCP)
26.
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
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
All types of database files are spread across all disks in the disk group to ensure redundancy unless the redundancy is set to EXTERNAL.
Report
Name Email  
27.
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;
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
Note that the UNDROP operation will cancel a drop operation in progress but cannot reverse a drop operation that has already completed. For HIGH REDUNDANCY, at least three failure groups must be specified. While you can combine a drop and add operation into one command, the command can reference only one disk group.
Report
Name Email  
28.
Which background process coordinates the rebalance activity for disk groups?
  • A.
    ORBn
  • B.
    OSMB
  • C.
    RBAL
  • D.
    ASMn
  • Answer & Explanation
  • Report
Answer : [C]
Explanation :
RBAL coordinates rebalance activity for a disk group in an ASM instance.
Report
Name Email  
29.
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
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
A fully qualified existing ASM filename has the format +group/dbname/filetype/tag .file.incarnation. In this case, filetype is datafile, and tag is the tablespace name to which it belongs, or users02.
Report
Name Email  
30.
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has not yet completed?
  • A.
    Issue the ALTER DISKGROUP … ADD DISK command.
  • B.
    Issue the ALTER DISKGROUP … UNDROP DISKS command.
  • C.
    Issue the ALTER DISKGROUP … DROP DISK CANCEL command.
  • D.
    Retrieve the disk from the Recycle Bin after the operation completes.
  • Answer & Explanation
  • Report
Answer : [B]
Explanation :
If the DROP DISK operation has not yet completed, you can cancel and roll back the entire DROP DISK operation by using ALTER DISKGROUP … UNDROP DISKS, with the disk group still being continuously available to all users.
Report
Name Email