4.10. Review Questions

  1. What is another name for RMAN-based database recovery?

    1. User-managed recovery

    2. Server-managed recovery

    3. Traditional recovery

    4. Database recovery

  2. What command is responsible for automating the backup of control files?

    1. ALTER DATABASE CONTROLFILE AUTOBACKUP ON

    2. ALTER SYSTEM CONTROLFILE AUTOBACKUP ON

    3. CONFIGURE CONTROLFILE AUTOBACKUP ON

    4. ENABLE CONTROLFILE AUTOBACKUP

  3. What is the process to recover a control file?

    1. Start up database, restore control file, start up mount the database, recover the database, and open the database.

    2. Start up mount, restore control file, start up the database, recover the database, and open the database.

    3. Start up nomount, restore control file, start up mount the database, recover the database, and open the database.

    4. Start up force, restore control file, start up the database, recover the database, and open the database.

  4. When recovering a control file without the recovery catalog, what special step must be performed to identify the target database? (Choose all that apply.)

    1. You must CONNECT TARGET / to the target database within RMAN.

    2. You must STARTUP MOUNT the database because the control file is missing.

    3. You must SET DBID to the target database so that the target database can be identified with out the control file available.

    4. You must CONNECT TARGET database name to the target database within RMAN.

  5. After you restore the control file, what must you do before you execute the RECOVER command to apply archive logs?

    1. The database must be restored with the RESTORE command.

    2. The database must be reconnected with the CONNECT TARGET database name command.

    3. The database must be started in MOUNT mode.

    4. The database must open for use with ALTER DATABASE OPEN command.

  6. Which of the following methods should you use for creating a control file? (Choose all that apply.)

    1. Dump the control file information to a trace file.

    2. Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command.

    3. Use the CREATE CONTROLFILE command.

    4. None of the above.

  7. What are the two cases defined in the backup control file? (Choose two.)

    1. ALTER DATABASE OPEN

    2. ALTER DATABASE OPEN RESETLOGS

    3. ALTER DATABASE OPEN NORESETLOGS

    4. ALTER DATABASE OPEN NORESET

  8. Which files need to be available and in the matching location of the ASCII control file in order to rebuild the control file? (Choose all that apply.)

    1. Server file, PFILE or SPFILE

    2. Datafiles

    3. Control files

    4. Redo logs

  9. Which of the following descriptions best describes incomplete recovery? (Choose all that apply.)

    1. Recovery that stops before the failure

    2. Recovery that stops at the point of failure

    3. Recovery that is missing transactions

    4. Recovery that is not missing transactions

  10. What are the required steps to perform a RMAN-based incomplete recovery with the SET UNTIL TIME clause?

    1. Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate time with the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN command.

    2. Start up the database in NOMOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN RESETLOGS command.

    3. Start up the database in MOUNT mode, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN NORESETLOGS command.

    4. Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.

  11. Which command is not a valid RMAN incomplete recovery run block?

    1. run
{
set until change 7563633;
restore database;
recover database;
}

    2. run
{
set until time '06-SEP-2004 11:25:00';
restore database;
recover database;
}

    3. run
{
set until SCN 7563633;
restore database;
recover database;
}

    4. run
{
set until sequence 3 thread 1;
restore database;
recover database;
}

  12. Which of the following would be a reason for using incomplete recovery? (Choose all that apply.)

    1. Stopping the recovery at a certain redo log sequence before a database corruption point

    2. Stopping the recovery at a certain time when database corruption occurred

    3. Stopping the recovery before a bad transaction is executed

    4. Stopping the recovery only after applying all transactions

  13. Which incomplete recovery capability is available to RMAN or user-managed methods?

    1. SET UNTIL TIME

    2. UNTIL TIME

    3. UNTIL SCN

    4. UNTIL SEQUENCE

  14. When performing incomplete recovery, which command allows you to stop the recovery process at a random point?

    1. UNTIL SEQUENCE, when performing a user-managed recovery

    2. UNTIL SCN, when performing a RMAN-based recovery

    3. UNTIL CANCEL, when performing a RMAN-based recovery

    4. UNTIL CANCEL, when performing a user-managed recovery

  15. Which command is required when performing an incomplete recovery?

    1. ALTER DATABASE OPEN RESETLOGS

    2. ALTER DATABASE OPEN NORESETLOGS

    3. UNTIL CANCEL

    4. ALTER DATABASE OPEN

  16. When using EM to perform a whole database incomplete recovery, what sequence of events must occur? (Choose the best answer.)

    1. The database must be shut down and started in NOMOUNT mode.

    2. The database must be started in MOUNT mode.

    3. The database must be shut down and started in MOUNT mode.

    4. The database must be shut down and restarted.

  17. Which credentials are needed to perform a recovery with EM? (Choose all that apply.)

    1. Database account with SYSDBA privilege

    2. Administrator account in Windows

    3. Oracle account in Unix

    4. Any Windows account

  18. The RESETLOGS clause is required with which of the following types of incomplete recovery?

    1. Using the UNTIL CANCEL command and applying almost all the archived redo logs before cancelling recovery

    2. Using the UNTIL TIME command and stopping before the current time

    3. Using the SET UNTIL SEQUENCE command and stopping before the last redo log sequence

    4. All of the above

  19. What is required to perform a UNTIL SEQUENCE recovery in RMAN?

    1. Identifying the sequence number with V$LOGHISTORY

    2. Identifying the sequence number with V$LOG_HISTORY

    3. Identifying the SCN number with V$LOG_HISTORY

    4. Identifying the SCN number with V$LOGHISTORY

  20. What is required to recover your database through a RESETLOGS recovery from a backup created prior to the RESETLOGS recovery?

    1. NORESETLOGS

    2. RESETLOGS

    3. UNTIL SEQUENCE

    4. Nothing, this feature is automatic.

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

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