What is the purpose of the catalog command？（）  A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the rec

题目

What is the purpose of the catalog command？（）  

  • A、 To review RMAN control file and recovery catalog metadata and ensure that its correct
  • B、 To delete RMAN backup-related metadata from the recovery catalog
  • C、 To create metadata in the control file and the recovery catalog related to backup set pieces 
  • D、 To create a report that lists database backups
  • E、 To rebuild the recovery catalog
相似考题

1.You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog？（）A、 synch catalogB、 resync catalogC、 replicate catalogD、 update catalogE、 restore catalog

2.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 fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 the trace file

3. You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

4.The RVPC user can do which of the following？（）A、 Register databases if granted the register database privilegeB、 See all databases in the recovery-catalog schemaC、 See all database-related metadata in the recovery catalog if they are granted access to that databaseD、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant commandE、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

更多“What is the purpose of the catalog command？（）  A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the rec”相关问题

  • 第1题：

    Why would you run the delete obsolete command？（）  

    • A、 To remove missing backup set pieces physically from disk
    • B、 To remove metadata related to backup set pieces in the control file and the recovery catalog
    • C、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
    • D、 To delete backup set pieces associated with backups that are no longer needed due to retention criteria
    • E、 To remove old versions of RMAN backups

    正确答案:C,D

  • 第2题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第3题：

    You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  

    • A、 register database
    • B、 recover catalog
    • C、 load backupset
    • D、 synch metadata
    • E、 catalog start with

    正确答案:E

  • 第4题：

    ou have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? （）

    • A、synch catalog 
    • B、resync catalog
    • C、replicate catalog 
    • D、update catalog  
    • E、restore catalog

    正确答案:B

  • 第5题：

    What is the purpose of the RMAN recovery catalog？（） 

    • A、 It must be used because all RMAN-related backup and recovery metadata information is contained in it.
    • B、 It provides a convenient， optional， repository of backup- and recovery-related metadata.
    • C、 It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
    • D、 It provides a means of storing all RMAN backup sets physically in an Oracle database server. 
    • E、 It provides the ability to store backup records for more than a year.

    正确答案:B,C,E

  • 第6题：

    Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）

    • A、COPY
    • B、BACKUP
    • C、CHANGE
    • D、DELETE
    • E、CATALOG

    正确答案:A,B,D

  • 第7题：

    单选题
    What is the purpose of the catalog command？（）
    A

     To review RMAN control file and recovery catalog metadata and ensure that its correct

    B

     To delete RMAN backup-related metadata from the recovery catalog

    C

     To create metadata in the control file and the recovery catalog related to backup set pieces 

    D

     To create a report that lists database backups

    E

     To rebuild the recovery catalog


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

  • 第8题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第9题：

    单选题
    RMAN automatically propagate information about the database structure， archived redo logs， backup sets， and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the （）command.
    A

    LIST

    B

    SWITCH

    C

    VALIDATE

    D

    CONFIGURE

    E

    RESYNC CATALOG

    F

    UPGRADE CATALOG


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

  • 第10题：

    单选题
    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）
    A

     The backup would be retained on the media for 31 days.

    B

     The backup would be maintained in the recovery catalog for 31 days.

    C

     The backup metadata would be retained in the control file for 31 days.

    D

     The backup metadata would be maintained in the recovery catalog for 31 days.

    E

     Automatic backups of the control file will be retained in the flash recovery area for 31 days.


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

  • 第11题：

    单选题
    ou have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? （）
    A

    synch catalog 

    B

    resync catalog

    C

    replicate catalog 

    D

    update catalog  

    E

    restore catalog


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

  • 第12题：

    多选题
    What is the purpose of the RMAN recovery catalog？（）
    A

    It must be used because all RMAN-related backup and recovery metadata information is contained in it.

    B

    It provides a convenient， optional， repository of backup- and recovery-related metadata.

    C

    It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

    D

    It provides a means of storing all RMAN backup sets physically in an Oracle database server.

    E

    It provides the ability to store backup records for more than a year.


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

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

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第15题：

    You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）

    • A、 The backup metadata will be maintained in the control file for 100 days.
    • B、 The backup metadata will be maintained in the recovery catalog for 100 days.
    • C、 The backup metadata will be maintained in the flash recovery area for 100 days.
    • D、 After 100 days， the backup sets and image copies will be deleted from the media.

    正确答案:B

  • 第16题：

    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）

    • A、 The backup would be retained on the media for 31 days.
    • B、 The backup would be maintained in the recovery catalog for 31 days.
    • C、 The backup metadata would be retained in the control file for 31 days.
    • D、 The backup metadata would be maintained in the recovery catalog for 31 days.
    • E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.

    正确答案:C

  • 第17题：

    Why would you execute the report obsolete command？（）  

    • A、 To list all backups that were no longer available for restore operations
    • B、 To list all backups that had aged beyond the RMAN retention criteria
    • C、 To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
    • D、 To list all datafiles that are no longer part of the database and thus do not need to be backed up
    • E、 To list all archived redo logs that are no longer needed for any database recovery

    正确答案:B

  • 第18题：

    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）

    • A、 The statement will not execute successfully.
    • B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
    • C、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
    • D、 Backups will be deleted from the media after 400 days.

    正确答案:A

  • 第19题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）
    A

    RMAN would use the current operating system location to place the backup.

    B

    RMAN would use the control file of the target database to maintain the backup.

    C

    RMAN would use the recovery catalog of the target database to maintain the backup.

    D

    RMAN would use the control file of the target database to maintain the backup metadata. 

    E

    RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）
    A

     The statement will not execute successfully.

    B

     The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

    C

     The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

    D

     Backups will be deleted from the media after 400 days.


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

  • 第21题：

    多选题
    Why would you run the delete obsolete command？（）
    A

    To remove missing backup set pieces physically from disk

    B

    To remove metadata related to backup set pieces in the control file and the recovery catalog

    C

    To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

    D

    To delete backup set pieces associated with backups that are no longer needed due to retention criteria

    E

    To remove old versions of RMAN backups


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

  • 第22题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第23题：

    单选题
    You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog？（）
    A

     synch catalog

    B

     resync catalog

    C

     replicate catalog

    D

     update catalog

    E

     restore catalog


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

相关内容