单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and 

题目
单选题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）
A

 Zero

B

 One or more

C

 NONE

D

 DEFAULT

相似考题

1.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

2.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 databaseB、To restrict the amount of space that is used by the backupsC、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.

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

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

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and ”相关问题

  • 第1题：

    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

    • A、 Reregistering the target database in recovery catalog
    • B、 Transporting the new tablespaces to the recovery catalog database
    • C、 Syncronizing the recovery catalog with the target database control file
    • D、 Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

  • 第2题：

    You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

    • A、 0
    • B、 1
    • C、 NONE
    • D、 DEFAULT

    正确答案:A

  • 第3题：

    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

  • 第4题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第5题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第6题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    单选题
    You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
    A

     0

    B

     1

    C

     NONE

    D

     DEFAULT


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

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

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

  • 第13题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）

    • A、 Zero
    • B、 One or more
    • C、 NONE
    • D、 DEFAULT

    正确答案:B

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

    • A、Reregistering the target database in recovery catalog
    • B、Transporting the new tablespaces to the recovery catalog database
    • C、Syncronizing the recovery catalog with the target database control file
    • D、Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

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


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

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第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 are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


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

  • 第23题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


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

相关内容