多选题Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）AOnly data files and the control file are back

题目
多选题
Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）
A

Only data files and the control file are backed up.

B

Archived redo logs are backed up only if the database is open during the backup.

C

The backup is deleted after one day，regardless of the default retention policy settings.

D

The backup becomes obsolete after one day，regardless of the default retention policy settings.

相似考题

1.You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

2.You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

3.You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

4.Examine the following RMAN command:Which two statements are true regarding the backup taken by using the above RMAN command?()A. Only data files and the control file are backed up.B. Archived redo logs are backed up only I f the database is open during the backup.C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

更多“多选题Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）AOnly data files and the control file are back”相关问题

  • 第1题：

    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)

    A. The KEEP option overrides the configured retention policy

    B. The KEEP option is an attribute of an individual backup piece

    C. The backup contains only data files and archived redo log files

    D. The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled


    参考答案：A, D

  • 第2题：

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

    • A、a tablespace is taken offline
    • B、the database instance is restarted
    • C、a new data file is added to an existing tablespace
    • D、a successful backup is recorded in the RMAN repository
    • E、the RMAN connection is disconnected from the target database

    正确答案:C,D

  • 第3题：

    You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）

    • A、 The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.
    • B、 The KEEP option overrides the configured retention policy.
    • C、 The backup contains only data files and archived redo log files.
    • D、 The KEEP option is an attribute of an individual backup piece.

    正确答案:A,B

  • 第4题：

    Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

    • A、 The block change tracking data will be used only from the next incremental 0 backup.
    • B、 The incremental backup will use change tracking data for accomplishing the backup.
    • C、 The incremental backup will not use change tracking data for accomplishing the backup.
    • D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

    正确答案:A,C

  • 第5题：

    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

    • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
    • B、 When a structural change is made to the database， then a backup of the current control file is performed.
    • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
    • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

    正确答案:D

  • 第6题：

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

    • A、 A tablespace is taken offline.
    • B、 The database instance is restarted.
    • C、 A new data file is added to an existing tablespace.
    • D、 A successful backup is recorded in the RMAN repository.
    • E、 The RMAN connection is disconnected from the target database.

    正确答案:C,D

  • 第7题：

    Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）

    • A、The block change tracking data will be used only from the next incremental 0 backup.
    • B、The incremental backup will use change tracking data for accomplishing the backup.
    • C、The incremental backup will not use change tracking data for accomplishing the backup.
    • D、The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

    正确答案:A,C

  • 第8题：

    多选题
    Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）
    A

    The block change tracking data will be used only from the next incremental 0 backup.

    B

    The incremental backup will use change tracking data for accomplishing the backup.

    C

    The incremental backup will not use change tracking data for accomplishing the backup.

    D

    The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.


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

  • 第9题：

    多选题
    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）
    A

    a tablespace is taken offline

    B

    the database instance is restarted

    C

    a new data file is added to an existing tablespace

    D

    a successful backup is recorded in the RMAN repository

    E

    the RMAN connection is disconnected from the target database


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

  • 第10题：

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


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

  • 第11题：

    单选题
    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）
    A

     When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.

    B

     When a structural change is made to the database， then a backup of the current control file is performed.

    C

     When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.

    D

     When a structural change is made to the database， then a backup of the alert log file will be performed.


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

  • 第12题：

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


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

  • 第13题：

    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）

    • A、 The copy of the datafile created is stored in the RMAN repository.
    • B、 The copy of the datafile created can be viewed using the LIST BACKUP command.
    • C、 The copy of the datafile created using this COPY command can be placed only on the disk.
    • D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
    • E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

    正确答案:C,E

  • 第14题：

    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

  • 第15题：

    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

    • A、A different procedure is required to restore a database from compressed backups 
    • B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
    • C、Using this command to create backups minimizes the bandwidth consumed.
    • D、Using this command to create backups improves the performance of the backup process 

    正确答案:C

  • 第16题：

    Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）  

    • A、 Only data files and the control file are backed up.
    • B、 Archived redo logs are backed up only if the database is open during the backup.
    • C、 The backup is deleted after one day，regardless of the default retention policy settings. 
    • D、 The backup becomes obsolete after one day，regardless of the default retention policy settings.

    正确答案:B,D

  • 第17题：

    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)

    • A、The KEEP option overrides the configured retention policy
    • B、The KEEP option is an attribute of an individual backup piece
    • C、The backup contains only data files and archived redo log files
    • D、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

    正确答案:A,D

  • 第18题：

    You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

    • A、 A different procedure is required to restore a database from compressed backups
    • B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
    • C、 Using this command to create backups minimizes the bandwidth consumed
    • D、 Using this command to create backups improves the performance of the backup process

    正确答案:C

  • 第19题：

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


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

  • 第20题：

    多选题
    You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）
    A

    The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.

    B

    The KEEP option overrides the configured retention policy.

    C

    The backup contains only data files and archived redo log files.

    D

    The KEEP option is an attribute of an individual backup piece.


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

  • 第21题：

    多选题
    Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）
    A

    Only data files and the control file are backed up.

    B

    Archived redo logs are backed up only if the database is open during the backup.

    C

    The backup is deleted after one day，regardless of the default retention policy settings.

    D

    The backup becomes obsolete after one day，regardless of the default retention policy settings.


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

  • 第22题：

    多选题
    Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）
    A

    The block change tracking data will be used only from the next incremental 0 backup.

    B

    The incremental backup will use change tracking data for accomplishing the backup.

    C

    The incremental backup will not use change tracking data for accomplishing the backup.

    D

    The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.


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

  • 第23题：

    多选题
    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)
    A

    The KEEP option overrides the configured retention policy

    B

    The KEEP option is an attribute of an individual backup piece

    C

    The backup contains only data files and archived redo log files

    D

    The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled


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

  • 第24题：

    单选题
    Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> （）  4. RMAN> ALTER DATABASE OPEN;
    A

    RECOVER DATABASE；

    B

    SWITCH DATAFILE ALL；

    C

    RESTORE CONTROL FILE；

    D

    RECOVER DATABASE USING BACKUP CONTROL FILE；


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

相关内容