Database Reference
In-Depth Information
14. Your database is ARCHIVELOG mode. Given the following steps, which option
provides the steps to do this backup in the right order and the most efficiently?
1. ALTER DATABASE BEGIN BACKUP .
2. ALTER TABLESPACE {TABLESPACE NAME} BEGIN BACKUP .
3. Back up the database data files.
4. ALTER DATABASE END BACKUP .
5. ALTER TABLESPACE {TABLESPACE NAME} END BACKUP
6. Back up the online redo logs.
7. Perform a redo log switch.
8. Back up the archived redo logs.
A. 2,3,4,6,8
B. 1,2,3,5,4,7,8
C. 1, 3,4,7, 8
D. 8 ,7,4, 3,1
E. 1,7, 8 , 9
15. From the answers available below, choose the two types of backups that can be taken
of an Oracle database.
A. Metadata backup
B. Logical backup
C. Physical backup
D. Consistent backup
E. Inconsistent backup
16. What database files would you need to back up if you are doing a NOARCHIVELOG
recovery?
A. Database data files
B. Online redo logs
C. Archived redo logs
D. Database control file
E. Database command file
Search WWH ::




Custom Search