一番質高い 1Z0-025 試験問題集

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. STARTUP FORCE MOUNT
• C. SHUTDOWN ABORT AND STARTUP MOUNT
• D. SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT
• E. SHUTDOWN IMMEDIATE AND STARTUP MOUNT
• F. SHUTDOWN NORMAL AND STARTUP MOUNT
• G. SHUTDOWN IMMEDIATE AND STARTUP

In which mode is 'Closed database backups' the only backup option available?

• A. ARCHIVELOG mode.
• B. READ WRITE mode.
• C. READ ONLY mode.
• D. NOARCHIVELOG mode.

The RMAN script is run every Sunday
Run (
Allocate channel c1 type disk
Format='/home/disk1/BACKUP/run_is_ip.bus';
backup incremental level=0 (database);
)
This RMAN script is run everyday of the week, except Sunday
Run (
Allocate channel c1 type disk
Format+ '/home/disk1/user4/BACKUP/inc_is_ip.bus'
Backup incremental level= 1cumulative (database);
)
What do these scripts do?

• A. On Sunday, they backup the entire database. On other days of the week, they back up all blocks changed in data file two since the previous backup.
• B. On Sunday, they backup the entire database. On other days of the week, they backup all blocks changed since the previous backup.
• C. On Sunday, they backup the system tablespace. On other days of the week, they backup all blocks changed in data file log since the previous backup.
• D. They backup the entire database everyday of the week.

What is the function of SMON in instance recovery?

• A. It synchronizes data file header and control files.
• B. It roles forward by applying changes in the redo log.
• C. It frees resources held by user processes.
• D. It writes data to the archive log files.
• E. It writes dirty buffers from the buffer cache to the data files.
• F. It writes data to the online redo log files.

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. The weekly backup (level 2) and the daily backup (level 3).
• 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. A base level backup (level 0) is missing and nothing can be recovered.