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

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 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

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

考题 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 databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager (RMAN) to recover the database

考题 You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery

考题 You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID).  In which two sources would you find the DBID? ()A、the trace fileB、the alert log fileC、an RMAN session log fileD、the server parameter fileE、the formatted name of a control file autobackup

考题 You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()A、 SQL scriptsB、 Recovery Manager (RMAN) scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database

考题 You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()A、RESYNC CATALOG;B、REGISTER DATABASE;C、CREATE CATALOG TABLESPACE rman_ts;D、GRANT recovery_catalog_owner TO rman_db01;

考题 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 / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 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 work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

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

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

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

考题 单选题The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()A  time-based recoveryB  log sequence recoveryC  cancel-based recoveryD  change-based recovery

考题 单选题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 / NOCATALOGB  rman TARGET sys/passwordC  rman TARGET sys/password AS SYSDBAD  rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 单选题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 databaseB perform point-in-time recoveryC perform a full database recoveryD drop and re-create the tablespaceE use Recovery Manager (RMAN) to recover the database

考题 多选题You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID).  In which two sources would you find the DBID? ()Athe trace fileBthe alert log fileCan RMAN session log fileDthe server parameter fileEthe formatted name of a control file autobackup

考题 单选题The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt.  With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()A time­based recoveryB log sequence recoveryC cancel­based recoveryD change­based recovery

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

考题 单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?()A using only the RMAN SWITCH command to set the new location for the data fileB placing the database in the MOUNT state for the restore and recovery operations.C using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.D configuring two channels: one for the restore operation and the other for the recovery operation

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