单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）ArecoverBduplicateCrestoreDcopyENone of the above

题目
单选题
What RMAN command is used to execute a tablespace point-in-time recovery？（）
A

 recover

B

 duplicate

C

 restore

D

 copy

E

 None of the above

相似考题

1.WhatRMANcommandisusedtoexecuteatablespacepoint－in－timerecovery?()A.recoverB.duplicateC.restoreD.copyE.Noneoftheabove

2.You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）A. one-wayB. two-wayC. three-wayD. No handshakes required during authenticationE. None of the above

3. In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）A、The retention policy is cleared.B、RMAN does not consider any backup as obsolete.C、The retention policy is set to its default setting of redundancy 1.D、The retention policy is set to its default setting of recovery window 7.

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

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）A  recoverB  duplicateC  restoreD  copyE  None of the above”相关问题

  • 第1题：

    When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）

    • A、 The SYSTEM tablespace.
    • B、 The UNDO tablespace.
    • C、 All tablespaces with tables.
    • D、 All tablespaces with indexes.
    • E、 No tablespaces are automatically restored.

    正确答案:A,B

  • 第2题：

    Flashback Database relies on which technologies to recover to a point in time？（）  

    • A、 Flashback Data Archive
    • B、 Flashback logs in the flash recovery area
    • C、 FlashbUndo tablespace
    • D、 RMAN command line
    • E、 None of the above

    正确答案:B

  • 第3题：

    tablespace point-in-time recovery is possible only with RMAN.（）

    • A、 True
    • B、 False

    正确答案:B

  • 第4题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第5题：

    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 catalogl
    • D、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）.

    正确答案:C

  • 第6题：

    When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?（）

    • A、 The database is in ARCHIVELOG mode.
    • B、 There is not a current backup of the database available.
    • C、 The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
    • D、 The USERS tablespace is not eligible for TSPITR because it has invalid objects.
    • E、 The recover tablespace command is incorrect and generates the error.

    正确答案:B

  • 第7题：

    单选题
    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）
    A

    New channels for restore and recovery tasks

    B

    New name for the data files of the tablespace

    C

    Auxiliary name for the data files of the tablespace

    D

    Auxiliary destinations for an auxiliary set of data files


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

  • 第8题：

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

  • 第9题：

    单选题
    When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?（）
    A

     The database is in ARCHIVELOG mode.

    B

     There is not a current backup of the database available.

    C

     The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

    D

     The USERS tablespace is not eligible for TSPITR because it has invalid objects.

    E

     The recover tablespace command is incorrect and generates the error.


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

  • 第10题：

    单选题
    What RMAN command is used to execute a tablespace point-in-time recovery？（）
    A

     recover

    B

     duplicate

    C

     restore

    D

     copy

    E

     None of the above


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

  • 第11题：

    多选题
    When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）
    A

    The SYSTEM tablespace.

    B

    The UNDO tablespace.

    C

    All tablespaces with tables.

    D

    All tablespaces with indexes.

    E

    No tablespaces are automatically restored.


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

  • 第12题：

    多选题
    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 ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第13题：

    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

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

    What RMAN command is used to execute a tablespace point-in-time recovery？（）

    • A、 recover
    • B、 duplicate
    • C、 restore
    • D、 copy
    • E、 None of the above

    正确答案:A

  • 第16题：

    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.

    正确答案:C,D,E

  • 第17题：

    You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）

    • A、sbt is not a valid device type.
    • B、Media Management Library was not loaded.
    • C、The sbt device cannot be used for data file backups.
    • D、No path was defined in the ALLOCATE CHANNEL command.
    • E、The channel is currently being used by another RMAN session.

    正确答案:B

  • 第18题：

    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

  • 第19题：

    多选题
    Which of the following are valid until command options when attempting point-in-time recovery in RMAN？（）
    A

    until time

    B

    until change

    C

    until sequence

    D

    until SCN

    E

    until commit


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

  • 第20题：

    单选题
    tablespace point-in-time recovery is possible only with RMAN.（）
    A

     True

    B

     False


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

  • 第21题：

    单选题
    You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）
    A

    sbt is not a valid device type.

    B

    Media Management Library was not loaded.

    C

    The sbt device cannot be used for data file backups.

    D

    No path was defined in the ALLOCATE CHANNEL command.

    E

    The channel is currently being used by another RMAN session.


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

  • 第22题：

    单选题
    Which command is used to begin a tablespace point-in-time recovery？（）
    A

     Restore tablespace

    B

     Recover tablespace

    C

     Tablespace recover

    D

     Recover to time

    E

     recover datafile


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

  • 第23题：

    单选题
    Flashback Database relies on which technologies to recover to a point in time？（）
    A

     Flashback Data Archive

    B

     Flashback logs in the flash recovery area

    C

     FlashbUndo tablespace

    D

     RMAN command line

    E

     None of the above


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

  • 第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
    解析： 暂无解析

相关内容