单选题Which files must be synchronized in order for a database to start？（）A temp filesB online data filesC offline data filesD read only data files

第1题：

The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）

• A、data files
• B、backup sets
• C、control files
• D、archived redo log files

第2题：

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

• A、Only the data files.
• B、Only the data files and the online logs.
• C、The data files， control files， and the online logs.
• D、The data files and control files， but not the online logs.

第3题：

Which of the following files cannot be cataloged using the CATALOG command？（）

• A、Data files
• B、Control files
• C、Archived log files
• D、Files storing RMAN scripts

第4题：

When performing an incomplete recover of the whole database， which data files must you restore？ （）

• A、Only the damaged or lost data files.
• B、All of the data files of the database.
• C、Only the data files belonging to the SYSTEM tablespace.
• D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

第5题：

You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）

• A、 The data file backup is done with multiple channels
• B、 The data files is in the read-write mode after being backed up in the read only mode
• C、 The backup was taken after the data files was taken offline-normal or is in the read only mode
• D、 The data file backup complies with the back retention policy and the backup duplexing fe ture

第6题：

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

• A、The data files can be recovered till the last committed transaction.
• B、The data files can be recovered without shutting down the database.
• C、The data file is taken offline automatically； the database remains open.
• D、The data files can be recovered to the time of the most recent backup.

第7题：

Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

• A、data files
• B、control files
• C、parameter file
• D、online redo log files
• E、server parameter file

第8题：

The loss of which two types of files may require a recovery with the RESETLOGS option？（）

• A、 control files
• B、 password file
• C、 archived log files
• D、 system-critical data files for which all the redo entries are present
• E、 non-system-critical data files for which all the redo entries are present

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

• A、A backup of the target database when it is mounted
• B、A backup of online redo log files when the database is open
• C、A backup of only used data blocks in the file beingbeingbackup up
• D、A backup of online， read/write data files when the database is open
• E、A backup of only those data blocks that have changed since a previous backup
• F、A backup of online， read/write data files when the database is in the NOMOUNT state.

第14题：

Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

• A、The data files can be recovered till the last committed transaction.
• B、The data files can be recovered without shutting down the database.
• C、The data file is taken offline automatically; the database remains open.
• D、The data files can be recovered to the time of the most recent backup.

第15题：

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

• A、The data files of the read-only tablespaces in the target database are not duplicated
• B、The read-only tablespaces in the target database are still defined in new the database
• C、The read-only tablespaces in the target database are changed to online after duplication
• D、The data files of the read-only tablespaces in the target database get duplicated
• E、The read-only tablespaces in the target database are not defined in the new database

第16题：

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

• A、only the control file, the current SPFILE, and data files
• B、only the current SPFILE and data files if autobackup is disabled
• C、only the data files and the archived redo logs
• D、the control file, current SPFILE file, data files, and archived redo logs

第17题：

Which three statements are true about the stages of database startup？（）

• A、Data files and redo log files can be renamed at the MOUNT stage.
• B、Control files are read at the OPEN stage for the location of data files.
• C、Control files are required to bring the database to the NOMOUNT stage.
• D、Data files and redo log files are made available to users at the OPEN stage.
• E、Data files and online redo log files are checked for consistency while opening the database

第18题：

Which files must be synchronized in order for a database to start？（）

• A、temp files
• B、online data files
• C、offline data files
• D、read only data files

第19题：

Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

• A、Data files
• B、Control files
• C、Parameter file
• D、Online redo log files
• E、Server parameter file

第20题：

Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

• A、Shut down the database, restore the two data files and then start up the database. 
• B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
• C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
• D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

第21题：

第22题：

第23题：

第24题：