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

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

相似考题

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

2. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

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

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-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”相关问题

  • 第1题：

    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

  • 第2题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第3题：

    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

    • A、 The backup will not be performed at all.
    • B、 three times
    • C、 four times
    • D、 six times

    正确答案:C

  • 第4题：

    You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

    • A、drop the read­only tablespace and re­create the tablespace after recovery
    • B、take data files from the read­only tablespace offline before performing a recovery
    • C、perform a recovery; status of the tablespace in control file will be changed automatically
    • D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    正确答案:B

  • 第5题：

    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 MB
    • C、 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.

    正确答案:A

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

    正确答案:D

  • 第7题：

    单选题
    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）
    A

     The backup will not be performed at all.

    B

     three times

    C

     four times

    D

     six times


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

  • 第9题：

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


    正确答案： C
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）
    A

    The MTTR Advisor is disabled.

    B

    The database is in NOARCHIVELOG mode.

    C

    The tablespace is already in backup mode.

    D

    The Flash Recovery Area is not configured.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    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？（）
    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


    正确答案： B,D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

    正确答案:C,D

  • 第16题：

    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

    正确答案:D,E

  • 第17题：

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

  • 第18题：

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


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


    正确答案： B
    解析： 暂无解析

  • 第21题：

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


    正确答案： A
    解析： 暂无解析

  • 第22题：

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

    C

     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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


    正确答案： B
    解析： 暂无解析

  • 第24题：

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


    正确答案： C
    解析： 暂无解析

相关内容