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

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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 MB

B. The RMAN uses multiplexing to perform backup

C. The operation is accomplished using the default channel available

D. The RMAN parallelizes the backup although the parallelism is not set for a channel


参考答案:A, C

第2题:

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.

正确答案:C

第3题:

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


参考答案:D

第4题:

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-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

正确答案:D

第5题:

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 MB
  • B、The RMAN uses multiplexing to perform backup
  • C、The operation is accomplished using the default channel available
  • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

正确答案:A,C

第6题:

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 backups
  • B、temporarily disable the retention policy for RMAN backups
  • C、configure automatic channel allocation for RMAN backups
  • D、use the CONFIGURE command to reconfigure the recovery window to 60 days

正确答案:B

第7题:

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.

正确答案:D

第8题:

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-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


参考答案:D

第9题:

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 enabled
  • B、Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
  • C、Backup optimization is permanently disabled
  • D、Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

正确答案:B

第10题:

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 files
  • B、 alert log files
  • C、 control file
  • D、 datafiles associated with the SYSTEM tablespace

正确答案:C

更多相关问题