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

题目内容 (请给出正确答案)
多选题
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 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?()AThey deregister all databases registered in the RCAT10 catalog.BThey import metadata for all registered databases in the RCAT10 database.CThey register all the RCAT10-catalog registered databases in the RCO11 catalog.DThey overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.” 相关考题
考题 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 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 also want to deregister them from the catalog after import. You executed the following commands to achieve this:   RMAN CONNECT CATALOG rco11/password@catdb  RMAN IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?()A、 The scripts in the RCO11 catalog are overwritten.B、 RMAN renames the local stored scripts in the RCO11 catalog.C、 The RMAN session in which the command is executed aborts.D、 RMAN renames the global scripts that are imported from 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

考题 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 migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace

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

考题 You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs?()A、 LGWRB、 DBWRC、 MMOND、 RVWR

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

考题 The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this?()  A、 ownerB、 touserC、 attachD、 remap_schema

考题 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 are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery

考题 单选题You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A ownerB touserC includeD schemasE fromuserF transformG remap_schemaH remap_datafileI reuse_datafilesJ remap_tablespace

考题 单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()A FULLB SCHEMASC REMAP_SCHEMAD REMAP_DATAFILESE REMAP_TABLESPACE

考题 单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task()A FULLB SCHEMASC TRANSFORMD REMAP_SCHEMAE REMAP_TABLESPACE

考题 单选题The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this?()A  ownerB  touserC  attachD  remap_schema

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

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

考题 多选题You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?()AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.

考题 单选题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 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?()AThey import all metadata from the RCAT10 catalog.BThey unregister the database from the RCAT10 catalog.CThey do not register the databases registered in the RCAT10 catalog.DThey register all databases registered in the RCAT10 catalog.

考题 多选题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.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming 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 dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs?()A  LGWRB  DBWRC  MMOND  RVWR

考题 单选题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 also want to deregister them from the catalog after import. You executed the following commands to achieve this:   RMAN CONNECT CATALOG rco11/password@catdb  RMAN IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?()A  The scripts in the RCO11 catalog are overwritten.B  RMAN renames the local stored scripts in the RCO11 catalog.C  The RMAN session in which the command is executed aborts.D  RMAN renames the global scripts that are imported from the RCAT10 catalog.