Oracle Backup and Recovery 認定 1Z0-025 試験問題:

1. What is the function of ARCn in instance recovery?

A) It writes dirty buffers from the buffer cache to the data files.
B) It writes data to the archive log files.
C) It frees resources held by user processes.
D) It synchronizes data file header and control files.
E) It writes data to the online redo log files.
F) The archive process does not take part in instance recovery.

2. When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which three options can be used to do this? (Choose three)

A) STARTUP TRANSACTIONAL MOUNT
B) SHUTDOWN ABORT AND STARTUP MOUNT
C) SHUTDOWN IMMEDIATE AND STARTUP
D) STARTUP FORCE MOUNT
E) SHUTDOWN IMMEDIATE AND STARTUP MOUNT
F) SHUTDOWN NORMAL AND STARTUP MOUNT
G) SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT

3. Consider the following scenario using incremental backups. A level 1 backup is taken on the first of the month. A level 2 backup is taken in every Sunday, and a level 3 backup is taken daily. If the database gets corrupted on the second Wednesday of the month and is lost, which scenario would restore the database completely?

A) A base level backup (level 0) is missing and nothing can be recovered.
B) The monthly backup (level 1) and the daily backup (level 3).
C) The monthly backup (level 1), the weekly backup (level 2) and the daily backup (level5)
D) The weekly backup (level 2) and the daily backup (level 3).

4. Which statement about 'cancel-based recovery' is true?

A) Recovery is stopped when the database has committed all changes up to the specified system change number (SCN).
B) Recovery is stopped by pressing at <CTL-C> the recovery prompt.
C) Recovery is stopped by entering CANCEL at the recovery prompt.
D) Recovery is stopped after the database has committed all changes up to the specified point-in-time.
E) Recovery is stopped when the specified method of recovery (CANCEL, TIME, or CHNAGE) is completed, and the control files are recovered.

5. Why would you set a data file offline when the database is in MOUNT state?

A) To recover it later, when database is in NOARCHIVELOG mode.
B) To prevent further corruption of a damaged data file.
C) To allow for automatic data file recovery.
D) To minimize downtime.

質問と回答：