In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()
第1题:
You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?()
第2题:
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? ()
第3题:
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?()
第4题:
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()
第5题:
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()
第6题:
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.
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.
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.
If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
第7题:
a data recovery agent
a recovery key
a recovery password printed and stored in a secure location
a recovery password stored in Active Directory
第8题:
SCN
Timestamp
Named recovery point
Transaction ID
Session ID
第9题:
The location can be changed only if the flash recovery area is empty.
After executing the command, all new flash recovery area files will be created in the new location.
The command will generate an error because you cannot change the flash recovery area while the database is open.
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.
第10题:
Whole database
Tablespaces
Datafiles
Archive logs
Redo logs
第11题:
Complete database recovery.
Incomplete database recovery.
Approximate database recovery.
Archived database recovery.
The database could not be recovered with RMAN.
第12题:
Setting the FAST_START_MTTR_TARGET to set the mean time to recover
Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
第13题:
You can control instance recover performance by setting parameters to define targets for()
第14题:
Which of the following is the BEST solution for repairing a hard drive that results in the NTLDR ismissing display upon booting?()
第15题:
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?()
第16题:
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()
第17题:
You need to recommend a BitLocker recovery method that meets the company’s technical requirements. Which recovery method should you recommend?()
第18题:
SET AUTORECOVERY ON
SET RECOVERY ON
SET AUTO ON
You cannot enable automatic media recovery.
第19题:
The next time you back up the database when you are also connected to the recovery catalog and the target database
The next time you are connected to the target database and the recovery catalog database and issue the resync command
The next time you connect RMAN to just the recovery catalog
The next time you connect to the recovery catalog and the target database with RMAN
Connecting to the recovery catalog and issuing the resync all databases command
第20题:
The location can be changed only if the flash recovery area is empty.
After executing the command, all new flash recovery area files will be created in the new location.
The command will generate an error because you cannot change the flash recovery area while the database is open.
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.
第21题:
Enable the flash recovery area and specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
Enable the flash recovery area but do not specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
第22题:
BMR lowers the mean time to recover (MTTR).
BMR supports point-in-time recovery of individual data blocks.
BMR enables you to use incremental backups for block recovery.
BMR enables recovery even when the database is not mounted or open.
BMR enables you to use proxy backups to perform block media recovery.
BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
第23题:
The size of the redo buffer in SGA.
The instance that will perform recovery in Real Application Cluster database.
The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.