单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()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

单选题
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()
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


参考解析

解析: 暂无解析

相关考题:

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 enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

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.

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 mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online, read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online, read/write data files when the database is in the NOMOUNT state.

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.

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.

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.

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.

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.

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 enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager

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 enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager

You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.

According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.

Which of the following shut down options should not be used before performing a consistent whole database backup?()A、NORMALB、TRANSACTIONALC、ABORTD、IMMEDIATEE、INCONSISTENT

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 terminate 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 modeB、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.

多选题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?()AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online, read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online, read/write data files when the database is in the NOMOUNT state.

单选题Which of the following shut down options should not be used before performing a consistent whole database backup?()ANORMALBTRANSACTIONALCABORTDIMMEDIATEEINCONSISTENT

单选题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?()AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.DIf you restart the database, the database will not be opened.

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

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

单选题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()AThe backup contains all the used blocks.BThe backup contains all the used and unused blocks.CThe backup contains blocks that have changed since the last level 0 backup.DThe backup contains blocks that have changed since the last level 1 backup taken last week.

多选题Which two statements about Recovery Manager (RMAN) backups are true? ()AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.

多选题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?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()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 shutting down the database.DThe backup will contain all database files that have never been backed up.

单选题According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.

多选题You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?()ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager

单选题You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.

多选题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.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager