网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()

  • A、1, 4, 5, 2, 3
  • B、1, 4, 3, 2, 5
  • C、4, 5, 2, 3, 1
  • D、2, 3, 4, 5, 1
  • E、1, 4, 2, 3, 5

参考答案

更多 “ The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()A、1, 4, 5, 2, 3B、1, 4, 3, 2, 5C、4, 5, 2, 3, 1D、2, 3, 4, 5, 1E、1, 4, 2, 3, 5” 相关考题
考题 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?()A. They import all metadata from the RCAT10 catalog.B. They unregister the database from the RCAT10 catalog.C. They do not register the databases registered in the RCAT10 catalog.D. They register all databases registered in the RCAT10 catalog.

考题 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?()A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

考题 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 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

考题 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.

考题 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

考题 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,2B、4,3,1,5,6,2C、4,5,1,3,2,6D、5,4,1,3,2,6E、5,4,1,3,6,2

考题 Which statement is true regarding virtual private catalogs?()A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B、The virtual private catalog owner cannot create and modify the stored scripts.C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

考题 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 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

考题 How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()  A、 Issue the grant command from the SYS user (or equivalent) of the target database.B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.

考题 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

考题 The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this:   1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb;  3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb;  5.RMAN CREATE VIRTUAL CATALOG;   What is the correct sequence in which the commands have to be executed?()  A、 1,4,5,2,3B、 1,4,3,2,5C、 4,5,2,3,1D、 2,3,4,5,1E、 1,4,2,3,5

考题 While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:() 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.A、2, 3, 5B、1, 2, 4C、1, 2, 4, 5D、1, 2, 3, 4, 5

考题 If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command

考题 In what order would you execute the following steps to create a recovery catalog?() a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.A、a,b,c,d,eB、b,a,d,c,eC、b,c,d,a,eD、b,c,d,e,aE、b,d,c,a,e

考题 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands: RMAN CONNECT CATALOG rco11/password@catdb  RMAN IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;   Which two statements are true regarding the tasks accomplished with these commands?()A、 They import all metadata from the RCAT10 catalog.B、 They unregister the database from the RCAT10 catalog.C、 They do not register the databases registered in the RCAT10 catalog.D、 They register all databases registered in the RCAT10 catalog.

考题 While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.()A、2,3,5B、1,2,4C、1,2,4,5D、1, 2, 3, 4, 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 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

考题 You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

考题 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following RMAN commands: RMAN CONNECT CATALOG rco11/password@catdb RMAN IMPORT CATALOG rcat10/oracle@inst1; What happens when you execute the above commands?()A、They deregister all databases registered in the RCAT10 catalog.B、They import metadata for all registered databases in the RCAT10 database.C、They register all the RCAT10-catalog registered databases in the RCO11 catalog.D、They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 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 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,2B 4,3,1,5,6,2C 4,5,1,3,2,6D 5,4,1,3,2,6E 5,4,1,3,6,2

考题 单选题Which statement is true regarding virtual private catalogs?()A  A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B  The virtual private catalog owner cannot create and modify the stored scripts.C  The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D  To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

考题 单选题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

考题 多选题If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command

考题 单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()A  Issue the grant command from the SYS user (or equivalent) of the target database.B  Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C  Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D  Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E  Issue the grant command from RMAN when connected to the target database.

考题 单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A  target databaseB  auxiliary databaseC  third-party databaseD  recovery catalog database

考题 单选题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.