RelationalDBDesign RelationalDBDesign


Physical Backups  «Prev 

Archiving Physical Backups - Quiz

Physical backups with and without archiving

Each question is worth one point. Select the best answer or answers for each question.
 

1. "Fuzzy" backup refers to a file that was copied:
Please select the best answer.
  A. While the database was running in NONARCHIVELOG mode and after the database was closed normally
  B. While the database was open and running in NOARCHIVELOG mode and the tablespace was offline and after the database had crashed
  C. While the database was open and running in ARCHIVELOG mode with the tablespace on line and after the command BEGIN BACKUP was issued
  D. While the database was open and running in NOARCHIVELOG mode with the tablespace online

2. You are not sure if the database is in ARCHIVELOG mode or not. Select the correct sequence of events for a successful online backup:
Please select the best answer.
  A. Ensure ARCHIVELOG mode, SHUTDOWN, BEGIN BACKUP, STARTUP, END BACKUP
  B. STARTUP, ALTER DATABASE ARCHIVELOG, BEGIN BACKUP, copy files, END BACKUP
  C. ALTER SYSTEM ARCHIVE LOG START, BEGIN BACKUP, copy files, END BACKUP
  D. Ensure ARCHIVELOG mode, STARTUP, BEGIN BACKUP, copy files, END BACKUP

3. Which of the following commands creates a binary copy of the control file?
Please select the best answer.
  A. ALTER DATABASE BACKUP CONTROLFILE TO 'c:\backup\control.bak';
  B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  C. ALTER TABLESPACE CONTROL BEGIN BACKUP;
  D. ARCHIVE LOG LIST;

4. In the view V$DATAFILE_HEADER, what command changes the values in column FUZZY from YES to NULL?
Please select the best answer.
  A. ALTER TABLESPACE <tablespace> BEGIN BACKUP
  B. ALTER TABLESPACE <tablespace> END BACKUP
  C. ALTER TABLESPACE <tablespace> OFFLINE
  D. An operating system command such as COPY is issued while the database is running

5. Which two of the following choices correctly explain at what point you must make a backup of a read-only tablespace?
Please select all the correct answers.
  A. After making it READ ONLY, with every subsequent full backup
  B. After altering it to READ WRITE
  C. Before altering it to READ ONLY
  D. After altering it to READ ONLY