You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not d

题目

You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.

  • A、4，1，5，6，3，2
  • B、4，3，1，5，6，2
  • C、4，5，1，3，2，6
  • D、5，4，1，3，2，6
  • E、5，4，1，3，6，2
相似考题

1.You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8

2.You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）A、RCO1 only.B、DB01 only.C、DB02 only.D、DB01 and DB02 only.E、DB01，DB02，and RC01.

3.Your company Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? （）A、 Create a nonclustered index on the Comments column. B、 Execute the USE Master Transact-SQL statement. C、 Create a full-text catalog. D、 Create a full-text index on the Comments column.

4.You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?（）A. A base catalog existsB. The recovery catalog is emptyC. The base recovery catalog must be droppedD. A target database is registered in the recovery catalog

更多“You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not di”相关问题

  • 第1题：

    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

  • 第2题：

    You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）  

    • A、 A base catalog exists
    • B、 The recovery catalog is empty
    • C、 The base recovery catalog must be dropped
    • D、 A target database is registered in the recovery catalog

    正确答案:A

  • 第3题：

    What RMAN command must you use before you can back up a database using the recovery catalog？（）

    • A、 create catalog
    • B、 install database
    • C、 catalog database
    • D、 merge Catalog with database
    • E、 register database

    正确答案:E

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第7题：

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

  • 第8题：

    单选题
    What RMAN command must you use before you can back up a database using the recovery catalog？（）
    A

     create catalog

    B

     install database

    C

     catalog database

    D

     merge Catalog with database

    E

     register database


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

  • 第9题：

    单选题
    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
    A

    4，1，5，6，3，2

    B

    4，3，1，5，6，2

    C

    4，5，1，3，2，6

    D

    5，4，1，3，2，6

    E

    5，4，1，3，6，2


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

  • 第10题：

    单选题
    You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）
    A

     A base catalog exists

    B

     The recovery catalog is empty

    C

     The base recovery catalog must be dropped

    D

     A target database is registered in the recovery catalog


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

  • 第11题：

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

  • 第12题：

    单选题
    You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）
    A

    RCO1 only.

    B

    DB01 only.

    C

    DB02 only.

    D

    DB01 and DB02 only.

    E

    DB01，DB02，and RC01.


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

  • 第13题：

    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

  • 第14题：

    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

    • A、flash back the database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Which command do you use to create a recovery-catalog schema? （）

    • A、create recovery catalog 
    • B、create catalog
    • C、build catalog 
    • D、catalog create 
    • E、mount catalog 

    正确答案:B

  • 第18题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第19题：

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

  • 第20题：

    单选题
    You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task：   1） Restore an autobackup of the server parameter file.  2） Restore the control file.  3） Start the target database Instance.  4） Mount the database. 5） Restore the data files.  6） Open the database with the RESETLOGS option.  7） Recover the data files.  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）
    A

     8， 1， 3， 2， 4， 5， 7， 6

    B

     1， 8， 3， 4， 2， 5， 7， 6

    C

     1， 3， 4， 2， 8， 5， 6， 7

    D

     1， 3， 2， 4， 6， 5， 7， 8


    正确答案： 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 using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task：   1） Restore an autobackup of the server parameter file. 2） Restore the control file  3） Start the target database instance  4） Mount the database  5） Restore the data files  6） Open the database with RESETLOGS option  7） Recover the data files  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）
    A

     8， 1， 3， 2， 4， 5， 7， 6

    B

     1， 8， 3， 4， 2， 5， 7， 6

    C

     1， 3， 4， 2， 8， 5， 6， 7

    D

     1， 3， 2， 4， 6， 5， 7， 8


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

  • 第23题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

相关内容