itgle.com

单选题Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）A V$BACKUPSETB RC_DATABASEC V$BACKUP_SETD RC_BACKUP_SET

题目
单选题
Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）
A

V$BACKUPSET

B

RC_DATABASE

C

V$BACKUP_SET

D

RC_BACKUP_SET

相似考题

1.Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

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

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

4.Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

更多“单选题Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）A V$BACKUPSETB RC_DATABASEC V$BACKUP_SETD RC_BACKUP_SET”相关问题

  • 第1题：

    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts.
    • B、 Recovery is faster if data is stored in catalog in addition to the control file.
    • C、 You can store backup Information of all registered databases in one place.
    • D、 Database backups are automatically deleted when they are older than the specified time period.

    正确答案:A,C

  • 第2题：

    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

    • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
    • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
    • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
    • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

    正确答案:C

  • 第3题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第4题：

    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

  • 第5题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第6题：

    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

    • A、 rman TARGET / NOCATALOG
    • B、 rman TARGET sys/password
    • C、 rman TARGET sys/password AS SYSDBA
    • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

    正确答案:B

  • 第7题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts
    • B、 Recovery is faster if data is stored in catalog in addition to the control file
    • C、 You can store backup information of all registered databases in one place
    • D、 Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第8题：

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

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


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

  • 第10题：

    单选题
    Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）
    A

    V$BACKUPSET

    B

    RC_DATABASE

    C

    V$BACKUP_SET

    D

    RC_BACKUP_SET


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

  • 第11题：

    多选题
    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)
    A

    To store the backup information of multiple database

    B

    To restrict the amount of space that is used by the backups

    C

    To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D

    To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.


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

  • 第12题：

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

  • 第13题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第14题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第15题：

    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

    • A、cannot be used in RMAN
    • B、by starting up the database again
    • C、by using the CATALOG command of RMAN
    • D、by using the RECOVER CATALOG command in RMAN
    • E、by re-creating the target control file to rebuild the RMAN repository

    正确答案:C

  • 第16题：

    Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）

    • A、V$BACKUPSET
    • B、RC_DATABASE
    • C、V$BACKUP_SET
    • D、RC_BACKUP_SET

    正确答案:C

  • 第17题：

    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

  • 第18题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

    • A、You can use RMAN stored scripts
    • B、Recovery is faster if data is stored in catalog in addition to the control file
    • C、You can store backup information of all registered databases in one place
    • D、Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第19题：

    单选题
    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
    A

    cannot be used in RMAN

    B

    by starting up the database again

    C

    by using the CATALOG command of RMAN

    D

    by using the RECOVER CATALOG command in RMAN

    E

    by re-creating the target control file to rebuild the RMAN repository


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

  • 第20题：

    单选题
    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）
    A

     rman TARGET / NOCATALOG

    B

     rman TARGET sys/password

    C

     rman TARGET sys/password AS SYSDBA

    D

     rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第22题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


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

  • 第23题：

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

  • 第24题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


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

相关内容