考题
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase?()A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE,DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET
考题
Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()
A.EXECUTE_CATALOG_ROLEB.CONNECTC.RESOURCED.RECOVERY_CATALOG_OWNERE.RECOVERY_CATALOG_USER
考题
毒理学研究中提倡3R原则是指A、replacement\reduction\refinementB、replacement\recovery\refinementC、replacement\reduction\referenceD、replacement\recovery\reactivityE、replacement\recovery\reference
考题
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 Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?()A、 Whole databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs
考题
You can control instance recover performance by setting parameters to define targets for()A、The size of the redo buffer in SGA. B、The instance that will perform recovery in Real Application Cluster database. C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
考题
Which of the following is the BEST solution for repairing a hard drive that results in the Could not readfrom selected boot disk display upon booting? ()A、Use recovery console and the bootcfg /rebuild command.B、Use recovery console and the chkdsk command.C、Use recovery console and the fixboot command.D、Use recovery console and the fixmbr command.
考题
Which of the following is the BEST solution for repairing a hard drive that results in the NTLDR ismissing display upon booting?()A、Use recovery console and the fixmbr command.B、Use recovery console and the bootcfg /rebuild command.C、Use recovery console and the fixboot command.D、Use recovery console and the chkdsk command.
考题
If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?() A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.
考题
You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()A、 The location can be changed only if the flash recovery area is empty.B、 After executing the command, all new flash recovery area files will be created in the new location.C、 The command will generate an error because you cannot change the flash recovery area while the database is open.D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
考题
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()A、BMR lowers the mean time to recover (MTTR).B、BMR supports pointintime recovery of individual data blocks.C、BMR enables you to use incremental backups for block recovery.D、BMR enables recovery even when the database is not mounted or open.E、BMR enables you to use proxy backups to perform block media recovery.F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
考题
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
考题
You have an enterprise subordinate certification authority (CA) configured for key archival. Three key recovery agent certificates are issued. The CA is configured to use two recovery agents. You need to ensure that all of the recovery agent certificates can be used to recover all new private keys. What should you do()A、Add a data recovery agent to the Default Domain Policy.B、Modify the value in the Number of recovery agents to use box.C、Revoke the current key recovery agent certificates and issue three new key recovery agent certificates.D、Assign the Issue and Manage Certificates permission to users who have the key recovery agent certificates.
考题
You need to recommend a BitLocker recovery method that meets the company’s technical requirements. Which recovery method should you recommend?()A、a data recovery agentB、a recovery keyC、a recovery password printed and stored in a secure locationD、a recovery password stored in Active Directory
考题
单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario?()A
If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.B
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.C
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.D
If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
考题
单选题Which of the following would you use to enable automatic media recovery for a database?()A
SET AUTORECOVERY ONB
SET RECOVERY ONC
SET AUTO OND
You cannot enable automatic media recovery.
考题
单选题You need to recommend a BitLocker recovery method that meets the company’s technical requirements. Which recovery method should you recommend?()A
a data recovery agentB
a recovery keyC
a recovery password printed and stored in a secure locationD
a recovery password stored in Active Directory
考题
多选题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
考题
多选题Which of these are valid Flashback Database recovery point parameters?()ASCNBTimestampCNamed recovery pointDTransaction IDESession ID
考题
单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()A
The location can be changed only if the flash recovery area is empty.B
After executing the command, all new flash recovery area files will be created in the new location.C
The command will generate an error because you cannot change the flash recovery area while the database is open.D
All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
考题
单选题You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()A
The location can be changed only if the flash recovery area is empty.B
After executing the command, all new flash recovery area files will be created in the new location.C
The command will generate an error because you cannot change the flash recovery area while the database is open.D
All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
考题
单选题You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()A
Enable the flash recovery area and specify it as the archived redo log destination.B
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C
Enable the flash recovery area but do not specify it as the archived redo log destination.D
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
单选题You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?()A
Whole databaseB
TablespacesC
DatafilesD
Archive logsE
Redo logs
考题
多选题What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()ABMR lowers the mean time to recover (MTTR).BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
考题
单选题If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()A
Complete database recovery.B
Incomplete database recovery.C
Approximate database recovery.D
Archived database recovery.E
The database could not be recovered with RMAN.
考题
单选题You can control instance recover performance by setting parameters to define targets for()A
The size of the redo buffer in SGA. B
The instance that will perform recovery in Real Application Cluster database. C
The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D
The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
考题
多选题Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()ASetting the FAST_START_MTTR_TARGET to set the mean time to recoverBSetting the RECOVERY_PARALLELISM parameter to twice the number of CPUsCUsing the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaDUsing the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area