Topic : Backup and Recovery

When performing an open database backup; which statement is NOT true?


  • The database is fully accessible to all users.
  • The database must be operating in ARCHIVELOG mode.
  • The database can be open but only in READ ONLY mode.
  • The database tablespaces should be in BEGIN BACKUP mode.

Answer :

The database can be open but only in READ ONLY mode.

Show Answer Discuss

When would a DBA need to perform a media recovery?


  • After instance failure occurs.
  • After abnormal termination of client program.
  • After the failure of an Oracle background process.
  • After the database is shutdown by using SHUTDOWN TRANSACTIONAL.
  • When a data file is not synchronized with the other data files; redo logs; and control files.

Answer :

When a data file is not synchronized with the other data files; redo logs; and control files.

Show Answer Discuss

Why would you set a data file offline when the database is in MOUNT state?


  • To minimize downtime.
  • To allow for automatic data file recovery.
  • To prevent further corruption of a damaged data file.
  • To recover it later; when database is in NOARCHIVELOG mode.

Answer :

To allow for automatic data file recovery.

Show Answer Discuss

What is the causes of media failures?


  • The server computer loses power.
  • A table is accidentally truncated.
  • The user issues an abnormal interrupt.
  • There is a logic error in the application.
  • There is a head crash on the disk containing a database file.

Answer :

There is a head crash on the disk containing a database file.

Show Answer Discuss

Which of the following would not require you to perform an incomplete recovery?


  • Instance failure
  • Missing archived redo log files during a media recovery
  • Loss of all copies of the control file
  • Media failure in a user tablespace in ARCHIEVELOG mode

Answer :

Instance failure

Show Answer Discuss