tailieunhanh - OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P20

OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P20: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Exam Essentials 881 Know how flashback database option works. The flashback database option can greatly reduce the time required to rewind the database to a prior point in time. Understand the parameters associated with flashback database. Understand backup catalog maintenance. Show how the EM Database Control interface simplifies cataloging crosschecking and cleaning up. 882 Chapter 15 Implementing Database Backups Review Questions 1. Among the failure events which is the most serious A. The loss of an entire redo log file group but no loss in any other group B. The loss of one member of each redo log file group C. The failure of the ARC0 background process D. The failure of the LGWR background process 2. To enable the flashback database option the database must be in which of the following modes A. NOARCHIVELOG mode B. ARCHIVELOG mode C. FLASHBACK LOG mode D. BEGIN BACKUP mode 3. When the database is in ARCHIVELOG mode database recovery is possible up to which event or time A. The last redo log file switch B. The last checkpoint position C. The last commit D. The last incremental backup using RMAN 4. From the following choose the true statement regarding image copies and backup sets. A. An image copy stores one data file per image copy and a backup set can store all data files in a single file. B. An image copy stores one data file per image copy and a backup set consists of one file per data file backed up. C. Both image copies and backup sets use a single file to store all objects to be backed up. D. A backup set stores each data file in its own backup file but an image copy places all data files into a single output file. 5. The option on the EM Database Control backup-scheduling options screen that allows you to refresh an image copy on disk with an incremental backup is known as which RMAN feature A. Incrementally updated backups B. Incremental level-zero backups C. Compressed image-copy refresh D. Compressed incremental backups Review Questions 883 6. When