10.6. Review Questions

  1. Which of the following is the most serious type of redo log file failure?

    1. The loss of an entire redo log file group, but no loss in any other group

    2. The loss of one member of each redo log file group

    3. The failure of the ARC0 background process

    4. The failure of the LGWR background process

  2. Which of the following tools or options does not ensure that either no committed transactions are lost or the MTBF is minimized?

    1. Streams

    2. Real Application Clusters

    3. LogMiner

    4. Archived redo logs

    5. Standby databases

  3. When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?

    1. The last redo log file switch

    2. The last checkpoint position

    3. The last commit

    4. The last incremental backup using RMAN

  4. From the following, select the true statement regarding image copies and backup sets.

    1. An image copy stores one datafile per image copy, and a backup set can store all datafiles in a single file.

    2. An image copy stores one datafile per image copy, and a backup set consists of one file per datafile backed up.

    3. Both image copies and backup sets use a single file to store all objects to be backed up.

    4. A backup set stores each datafile in its own backup file, but an image copy places all datafiles into a single output file.

  5. The option on the EM Database Control backup scheduling options screen that allows you to refresh an image copy on disk with an incremental backup is known as which new RMAN feature?

    1. Incrementally updated backups

    2. Incremental level 0 backups

    3. Compressed image copy refresh

    4. Compressed incremental backups

  6. When should the DBA make a trace copy of the control file using ALTER DATABASE BACKUP CONTROLFILE TO TRACE?

    1. After every backup

    2. After multiplexing the control files

    3. Whenever restarting the instance

    4. Whenever the physical structure of the database changes

  7. Which of the following is not a step in configuring your database to archive redo log files?

    1. Place the database in ARCHIVELOG mode.

    2. Multiplex the online redo log files.

    3. Specify a destination for archived redo log files.

    4. Specify a naming convention for your archived redo log files.

  8. Why are online backups known as inconsistent backups?

    1. Because not all control files are synchronized to the same SCN until the database is shut down

    2. Because both committed and uncommitted transactions are included in a backup when the database is online

    3. Because a database failure while an online backup is in progress can leave the database in an inconsistent state

    4. Because online backups make copies of datafiles while they are not consistent with the control files

  9. In the Disk Settings section of the EM Database Control Configure Backup Settings page, which of the following backup settings is not configurable?

    1. Disk Backup Type

    2. Control File Autobackup Format

    3. Disk Backup Location

    4. Parallelism

  10. Which of the following initialization parameters specifies the location where the control file trace backup is sent?

    1. USER_DUMP_DEST

    2. BACKGROUND_DUMP_DEST

    3. LOG_ARCHIVE_DEST

    4. CORE_DUMP_DEST

  11. Which of the following pieces of information is not available in the control file?

    1. Instance name

    2. Database name

    3. Tablespace names

    4. Log sequence number

  12. Which data dictionary view shows that the database is in ARCHIVELOG mode?

    1. V$INSTANCE

    2. V$LOG

    3. V$DATABASE

    4. V$THREAD

  13. Which file records all changes made to the database and is used only when recovering an instance?

    1. Archive log file

    2. Redo log file

    3. Control file

    4. Alert log file

  14. Which initialization parameter contains the value used as the default for archived log file destination 10?

    1. LOG_ARCHIVE_DEST

    2. STANDBY_ARCHIVE_DEST

    3. LOG_ARCHIVE_DUPLEX_DEST

    4. DB_RECOVERY_FILE_DEST

    5. USE_DB_RECOVERY_FILE_DEST

  15. Which of the following commands is a key step in multiplexing control files using an SPFILE?

    1. ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=SPFILE;

    2. ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=MEMORY;

    3. ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=BOTH;

    4. The number of control files is fixed when the database is created.

  16. Which statement adds a member /logs/redo22.log to redo log file group 2?

    1. ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;

    2. ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;

    3. ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;

    4. ALTER DATABASE ADD LOGFILE '/logs/redo22.log';

  17. What is the biggest advantage of having the control files on different disks?

    1. Database performance.

    2. Guards against failure.

    3. Faster archiving.

    4. Writes are concurrent, so having control files on different disks speeds up control file writes.

  18. To place the database into ARCHIVELOG mode, in which state must you start the database?

    1. MOUNT

    2. NOMOUNT

    3. OPEN

    4. SHUTDOWN

    5. Any of the above

  19. Which of the following commands places the database in ARCHIVELOG mode?

    1. ALTER SYSTEM ARCHIVELOG;

    2. ALTER DATABASE ARCHIVELOG;

    3. ALTER SYSTEM SET ARCHIVELOG=TRUE;

    4. ALTER DATABASE ENABLE ARCHIVELOG MODE;

    5. ALTER DATABASE ARCHIVELOG MODE;

  20. Which of the following substitution variables formats are always required for specifying the names of the archived redo log files? (Choose all that apply.)

    1. %d

    2. %s

    3. %r

    4. %t

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset