单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?()A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window

单选题
Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?()
A

The RMAN backup fails because the TOOLS tablespace is read-only

B

The RMAN skips the backup of the tablespace because backup optimization is enabled

C

The RMAN makes backup because optimization can be enabled only for backups to disk

D

The RMAN makes the backup because no backup of the tablespace exists within the seven day window


参考解析

解析: 暂无解析

相关考题:

Consider the following scenario for your database:Which statement is true regarding the backup of the TOOLS tablespace?() A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Consider the following scenario for your database:- Backup optimization is enabled in RMAN.- The recovery window is set to 7 days in RMAN.- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.- The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk.Which statement is true regarding the backup of the TOOLS tablespace?()A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN).To accomplish the backup, you issued the following RMAN command:RMAN BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true about the execution of the above command? ()(Choose two.)A. The backup piece size will be limited to 300 MBB. The RMAN uses multiplexing to perform backupC. The operation is accomplished using the default channel availableD. The RMAN parallelizes the backup although the parallelism is not set for a channel

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()A、configure a default device for RMAN backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days

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.

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.

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()A、The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB、Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC、Backup optimization is permanently disabledD、Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()A、The RMAN backup fails because the TOOLS tablespace is read-onlyB、The RMAN skips the backup of the tablespace because backup optimization is enabledC、The RMAN makes backup because optimization can be enabled only for backups to diskD、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.B、 The backup piece size will be limited to 300 MB.C、 The operation is accomplished using the default channel available.D、 Three channels for the tape drive must be configured by setting the parallelism to three.

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、 The database is in NOMOUNT state.B、 The database is in NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()A、 The command generates an error.B、 The command backs up the tablespace and creates a backup set of size 200 MBC、 The command backs up the tablespace and creates two backup sets of size 100 MB each.D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

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 set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A、 configure a default device for RMAN backupsB、 temporarily disable the retention policy for RMAN backupsC、 configure automatic channel allocation for RMAN backupsD、 use the CONFIGURE command to reconfigure the recovery window to 60 days

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

单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()AThe RMAN backup fails because the TOOLS tablespace is read-onlyBThe RMAN skips the backup of the tablespace because backup optimization is enabledCThe RMAN makes backup because optimization can be enabled only for backups to diskDThe RMAN makes the backup because no backup of the tablespace exists within the seven day window

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

单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A online redo log filesB alert log filesC control fileD datafiles associated with the SYSTEM tablespace

单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()Aconfigure a default device for RMAN backupsBtemporarily disable the retention policy for RMAN backupsCconfigure automatic channel allocation for RMAN backupsDuse the CONFIGURE command to reconfigure the recovery window to 60 days

单选题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 have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()A The command generates an error.B The command backs up the tablespace and creates a backup set of size 200 MBC The command backs up the tablespace and creates two backup sets of size 100 MB each.D The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

多选题You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()AThe RMAN parallelizes the backup although the parallelism is not set for a channel.BThe backup piece size will be limited to 300 MB.CThe operation is accomplished using the default channel available.DThree channels for the tape drive must be configured by setting the parallelism to three.

多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days