单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）AThe backup will consist of used data blocks only.BThe database must be shut down to accomplish the backup.CThe backup can be accomplished without

第1题：

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.

第2题：

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

• A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
• C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
• D、 If you restart the database，the database will not be opened.

第3题：

第4题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

• A、Backup compression should be enabled
• B、Parallelism for the channel should be set to 2
• C、All the files must be backed up as backup sets
• D、The backup may be stored either on disk or on media with media manager

第5题：

You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）

• A、The backup contains all the used blocks.
• B、The backup contains all the used and unused blocks.
• C、The backup contains blocks that have changed since the last level 0 backup.
• D、The backup contains blocks that have changed since the last level 1 backup taken last week.

第6题：

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

• A、The instance aborts.
• B、The database cannot be recovered.
• C、The database can be recovered by restoring the control files from the backup.
• D、The database remains opened and you have to shut it down with the ABORT option.
• E、The database can be restored till the point of the last closed whole database backup.

第7题：

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）

• A、Multiple change tracking files can be created for a database.
• B、The change tracking file must be created after the first level 0 backup.
• C、RMAN does not support backup and recovery of the change tracking file.
• D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

第8题：

To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

• A、 The database will open，and the tablespace automatically comes out of the backup mode.
• B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
• C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
• D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

第9题：

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

• A、The backup will consist of used data blocks only.
• B、The database must be shut down to accomplish the backup.
• C、The backup can be accomplished without shutting down the database.
• D、The backup will contain all database files that have never been backed up.

第10题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）

• A、Backup compression should be enabled
• B、Parallelism for the channel should be set to 2
• C、All the files must be backed up as backup sets
• D、The backup may be stored either on disk or on media with media manager