Oracle Database 11g Certified Master Upgrade Sample Questions:
1. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute
from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
A) all disks in the disk group only if all of them are ONLINE
B) all disks that are currently in OFFLINE mode
C) all disks that are not currently in OFFLINE mode
D) all disks in the disk group
2. Which statement about the enabling of table compression in Oracle Database 11g is true?
A) Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B) Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
C) Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
D) Compression can be enabled only at the table level for both direct loads and conventional DML.
3. You want to use the automatic management of backup and recovery operations features for your database.
Which configuration must you set?
A) Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
B) Enable the flash recovery area and specify it as the archived redo log destination.
C) Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
D) Enable the flash recovery area but do not specify it as the archived redo log destination.
4. Which backup option defines a user-defined name for a backup?
A) TAG
B) FORMAT
C) FORMAT U%
D) NAME
5. Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)
A) Specifying vendor-specific information for a media manager
B) Specifying the parallelism for backup and restore operations
C) Limiting the input/output (I/O) bandwidth consumption
D) Specifying the size of backup sets and backup pieces
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: A,C |

We're so confident of our products that we provide no hassle product exchange.


By Isaac


