This preview shows page 1. Sign up to view the full content.
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.
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
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
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.
- Fall '09