Online Access Free 11gocmu Practice Test

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)

• A.The log switch hangs occur for transactions until free space is available in the flash recovery area
• B.The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
• C.An entry is created in the alert log file and the database instance continues to function normally
• D.The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

• A.failures when no standby database is configured
• B.failures because a data file is renamed by error
• C.failures due to loss of connectivity-for example, an unplugged disk cable
• D.failures that require no archive logs to be applied for recovery

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

• A.The audit trail is stored in the database.
• B.Auditing is enabled for all privileges.
• C.Auditing is disabled for all privileges.
• D.The audit trail is stored in an operating system file.
• E.Auditing is enabled for certain privileges related to database security.

As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum in data redundancy?

• A.None of the above
• B.CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY
  failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
  diska1;
• C.CREATE DISKGROUP dg_alliance1
  HIGH REDUNDANCY
  failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_
  disk1
  failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_
  disk2
  failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
  disk3;
• D.CREATE DISKGROUP dg_alliance1
  MAXIMUM REDUNDANCY
  failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_
  disk1
  failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_
  disk2
  failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_
  disk3
  failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk4' NAME file_
  disk4;
• E.CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY failgroup diskcontrol1
  DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_ diska1 failgroup diskcontrol2 DISK
  'c:\oracle\asm_disk\_file_disk4' NAME file_
  diskb1;

Which three actions are required to configure the Flashback Database? (Choose three.)

• A.enable Flashback logging
• B.start the database in the ARCHIVELOG mode
• C.start the database in the NOARCHIVELOG mode
• D.create FLASHBACK tablespace
• E.set Flash Recovery Area