itgle.com

多选题When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）AAt the end of every RUN block.BAfter every SET CONTROLFILE AUTOBACKUP FORMAT command.CAfter every BACKUP or COPY comm

题目
多选题
When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）
A

At the end of every RUN block.

B

After every SET CONTROLFILE AUTOBACKUP FORMAT command.

C

After every BACKUP or COPY command issued at the RMAN prompt.

D

At the end of every RUN block if the last command in the block was either BACKUP or COPY.

E

Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.

F

After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

相似考题

1. Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

2. The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only.  What is the order of precedence？（） 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGUREA、1,2,3 B、2,3,1 C、3,2,1 D、There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session. 

3. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

4. 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 offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

更多“多选题When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）AAt the end of every RUN block.BAfter every SET CONTROLFILE AUTOBACKUP FORMAT command.CAfter every BACKUP or COPY comm”相关问题

  • 第1题：

    What command would you issue to enable automated backups of control files？（）  

    • A、 alter database controlfile autobackup on
    • B、 alter system controlfile autobackup on
    • C、 configure controlfile autobackup on
    • D、 enable controlfile autobackup

    正确答案:C

  • 第2题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第3题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

    • A、 By using the trace file.
    • B、 By using the alert log file.
    • C、 By using the database ID
    • D、 By using the server parameter file.
    • E、 By using the V$CONTROLFILE view.
    • F、 By using the autobackup format configuration setting.

    正确答案:C,F

  • 第4题：

    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

    • A、 Start the database in the MOUNT stage.
    • B、 Back up the control file to trace.
    • C、 Set the DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第5题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）

    • A、by using the trace file
    • B、by using the alert log file
    • C、by using the database ID
    • D、by using the server parameter file
    • E、by using the V$CONTROLFILE view
    • F、by using the autobackup format configuration setting

    正确答案:C,F

  • 第6题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第7题：

    多选题
    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）
    A

    the trace file

    B

    the alert log file

    C

    an RMAN session log file

    D

    the server parameter file

    E

    the formatted name of a control file autobackup


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

  • 第8题：

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


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

  • 第9题：

    单选题
    The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only.  What is the order of precedence？（） 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGURE
    A

    1,2,3 

    B

    2,3,1 

    C

    3,2,1 

    D

    There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session. 


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

  • 第10题：

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

  • 第11题：

    多选题
    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）
    A

    by using the trace file

    B

    by using the alert log file

    C

    by using the database ID

    D

    by using the server parameter file

    E

    by using the V$CONTROLFILE view

    F

    by using the autobackup format configuration setting


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

  • 第12题：

    多选题
    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）
    A

    At the end of every RUN block.

    B

    After every SET CONTROLFILE AUTOBACKUP FORMAT command.

    C

    After every BACKUP or COPY command issued at the RMAN prompt.

    D

    At the end of every RUN block if the last command in the block was either BACKUP or COPY.

    E

    Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.

    F

    After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.


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

  • 第13题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

    • A、the trace file
    • B、the alert log file
    • C、an RMAN session log file
    • D、the server parameter file
    • E、the formatted name of a control file autobackup

    正确答案:C,E

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    What command would you issue to enable automated backups of control files? （）

    • A、alter database controlfile autobacku on
    • B、alter system controlfile autobackup on 
    • C、configure controlfile autobackup on 
    • D、enable controlfile autobackup

    正确答案:C

  • 第17题：

    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）

    • A、At the end of every RUN block. 
    • B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
    • C、After every BACKUP or COPY command issued at the RMAN prompt. 
    • D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
    • E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
    • F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

    正确答案:C,D,E

  • 第18题：

    多选题
    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）
    A

    The command restores only the missing control file.

    B

    The command restores all the control files.

    C

    The command fails because the database is running.

    D

    This is the correct way to address this problem.

    E

    This is not the correct way to address this problem.


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

  • 第19题：

    多选题
    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）
    A

    By using the trace file.

    B

    By using the alert log file.

    C

    By using the database ID

    D

    By using the server parameter file.

    E

    By using the V$CONTROLFILE view.

    F

    By using the autobackup format configuration setting.


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

  • 第20题：

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

  • 第21题：

    多选题
    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）
    A

    the alert log file

    B

    the server parameter file

    C

    the formatted name of a control file autobackup

    D

    an RMAN session log file

    E

    the trace file


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

  • 第22题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


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

  • 第23题：

    单选题
    What command would you issue to enable automated backups of control files? （）
    A

    alter database controlfile autobacku on

    B

    alter system controlfile autobackup on 

    C

    configure controlfile autobackup on 

    D

    enable controlfile autobackup


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

  • 第24题：

    单选题
    What command would you issue to enable automated backups of control files？（）
    A

     alter database controlfile autobackup on

    B

     alter system controlfile autobackup on

    C

     configure controlfile autobackup on

    D

     enable controlfile autobackup


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

相关内容