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 :
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. |
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?
/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 :
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. |
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 :
Explanation :
| RBAL coordinates rebalance activity for a disk group in an ASM instance. |
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 : [B]
Explanation :
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. |
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 :
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. |
|
|
||||||||||||||||||||||||||||
