You also need to take a backup of your control file

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: our Oracle database. You also need to take a backup of your control file if you change the archiving status of your database. Furthermore, you should back up the control file whenever you drop tablespaces or change them from read-write to read-only state, or vice-versa. Incorrect Answers: A: You don't need to back up your control file after ALTER TABLE command. B: You don't need to back up your control file after CREATE TABLE command. D: You don't need to back up your control file after creation of rollback segment. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 591-593 Chapter 12: Overview of Backup and Recovery QUESTION 101: During an opened database backup, a power failure occurs. Which SQL statement do you issue to resolve this situation after mounting the database? A. ALTER DATABASE n END BACKUP B. ALTER DATABASE OPEN RESETLOGS C. ALTER DATABASE DATAFILE n END BACKUP D. ALTER TABLESPACE name DATAFILE n END BACKUP Answer: C Explanation: To fix this problem you need to stop backup mode for the datafile, so usage of ALTER DATABASE DATAFILE n END BACKUP comman...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online