单选题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 wit

第1题：

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.

第2题：

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.

第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?（）

• 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题：

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.

第6题：

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.

第7题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第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题：

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

第10题：

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.