1z1-034 無料問題集「Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP」

（A）create a backup of the database and recover all corrupted blocks found in the backup

（B）perform a backup validation and list all logically and physically corrupt blocks in the database

（C）create an image copy of the database and recover all corrupted blocks found in the image copy

（D）perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks

（E）perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found

（A）The change tracking file must be created after the first level 0 backup.

（B）Multiple change tracking files can be created for a database.

（C）The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

（D）RMAN does not support backup and recovery of the change tracking file.

（A）Restore the backup of only the data files that contain the dropped tables.

（B）Restore the backup of all the data files and the control file.

（C）Restore the backup of all the data files belonging to the tablespace containing the dropped tables.

（D）Restore the backup of all the data files.

（A）The number of DBWR_TO_SLAVES increases

（B）The number of DBWR processes increases

（C）The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead

（D）The number of ASMB processes increases

（A）Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files

（B）Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location

（C）Restoring the server parameter file from the backup by using the recovery catalog to restore,

（D）Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.

（A）Option D

（B）Option B

（C）Option C

（D）Option A

（A）Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

（B）Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

（C）The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

（D）The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.

（A）EXAMPLE

（B）SYSTEM

（C）SYSAUX

（D）SAMPLE

（E）USERS

（A）hash clustered table

（B）object table

（C）heap table

（D）external table

（E）sorted hash clustered table

（F）global temporary table

（A）You must take the tools01.dbf data file offline before you start a block media recovery.

（B）You must ensure that the SALES database is mounted or open.

（C）You must restore a backup control file to perform a block media recovery.

（D）You must put the database in NOARCHIVELOG mode to perform a block media recovery.

（E）You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.