Oracle DBA Question $ Answers(Part 16)

1. 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?

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

correct answer: c

2. How often does a read-only tablespace need to be backed up?

A. At all database backups
B. Whenever the control file is recreated
C. Only once after the tablespace becomes read-only
D. When the database is put into ARCHIVELOG mode

correct answer: c

3. With the instance down, how would you recover a lost control file?

A. Restore backup control file & recover using backup controlfile
B. Use the CREATE CONTROLFILE command
C. Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
D. Use the ALTER DATABASE RECOVER CONTROLFILE FROM TRACE command

correct answer: a

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

A. Back up the data files
B. Back up the instance
C. Back up the database
D. Back up the control file
E. Archive any unarchived online redo-logs

correct answer: c

5. Which command creates a text backup of the control file?
A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B. ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C. ALTER DATABASE BACKUP CONTROLFILE TO filename;
D. ALTER DATABASE BACKUP CONTROLFILE TO TEXT filename;

correct answer: a