Topic : Backup and Recovery

In what scenario you have to open a database with reset logs option?


  • Rename Database
  • Point in time recovery
  • All of the above

Answer :

All of the above

Show Answer Discuss

You should issue a backup of the control file after issuing which command?


  • ALTER TABLE
  • CREATE TABLE
  • CREATE TABLESPACE
  • CREATE ROLLBACK SEGMENT

Answer :

CREATE TABLESPACE

Show Answer Discuss

The alert log will never contain specific information about which database backup activity ?


  • Placing tablespaces in begin backup mode.
  • Shutting the database down with an ABORT.
  • Performing an operating system backup of the database files.
  • Changing the database backup mode from ARCHIVELOG to NOARCHIVELOG

Answer :

Performing an operating system backup of the database files.

Show Answer Discuss

A tablespace becomes unavailable because of a failure. The database is running in NOARCHIVELOG mode? What should the DBA do to make the database available?


  • Perform a tablespace recovery.
  • Perform a complete database recovery.
  • Restore the data files; redo log files; and control files from an earlier copy of a full database backup.
  • There is no possibility to make the database available.

Answer :

Restore the data files; redo log files; and control files from an earlier copy of a full database backup.

Show Answer Discuss

Which action does Oracle recommend after a DBA recovers from the loss of the current online redo-log?


  • Back up the data files
  • Back up the instance
  • Back up the database
  • Back up the control file
  • Archive any unarchived online redo-logs

Answer :

Back up the database

Show Answer Discuss