1Z0-062 Exam Dumps – Our Features

Which three are true about the default database buffer cache? (Choose three.)

• Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.
  
• It is in the fixed area of the SGA.
  
• Its buffers can contain data block images for blocks that have a corresponding image in a data file.
  
• Buffers containing block images may be selected for reuse based only on a touch count algorithm.
  
• It can contain block images only for database blocks whose block size is equal to the buffer size.
  
• The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.
  
• Its buffers can contain data block images for blocks that have no corresponding image in a data file.
  

Which three statements are true about the purpose of checkpoints? (Choose three.)

• They ensure that uncommitted transactions are rolled back in case of an instance failure.
  
• They ensure that all the dirty buffers are written to disk during a normal shutdown.
  
• They ensure that instance recovery starts in the event of an instance failure.
  
• They ensure that dirty buffers in the buffer cache are written to disk regularly.
  
• They reduce the time required for recovery in case of an instance failure.
  

You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)

• User session data
  
• Stack space
  
• Private SQL area
  
• Location of the runtime area for DML and DDL Statements
  
• Location of a part of the runtime area for SELECT statements
  

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATESQL > STARTUP MOUNTSQL > FLASHBACK DATABASE to TIME ''TO_DATE ('08/20/12' , 'MM/DD/YY')'';Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?

• Only 1
  
• Only 2
  
• Only 3
  
• 3 and 1
  
• 1 and 2
  

Which three are activities performed by SMON? (Choose three.)

• cleaning up the database buffer cache and freeing resources that a client process was using
  
• applying online redo during instance recovery
  
• cleaning up temporary segments that are no longer needed
  
• performing database services registration with the default listener
  
• restarting a server or a dispatcher process that terminated abnormally
  
• recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors
  

Identify three uses of the CROSSCHECK command (Choose three.)

• to validate the database backup
  
• to synchronize logical backup records with physical files in backup storage
  
• to check the obsolete backups that can be deleted from the file system
  
• to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
  
• to update the recovery catalog or control file if archived log files are deleted with operating system commands
  

Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)

• A segment cannot span data files.
  
• A data file can belong to only one tablespace.
  
• An extent cannot span data files.
  
• The size of an Oracle data block in a data file should be the same as the size of an OS block.
  

What action must you take to ensure complete database recovery till the point of failure?

• Multiplex the control files
  
• Duplex the RMAN backup sets.
  
• Multiplex the online redo log files.
  
• Configure the database to run in ARCHIVELOG mode.
  

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

• The job is terminated and the gathered statistics are not saved.
  
• The job is terminated but the gathered statistics are not published.
  
• The job continues to run until all statistics are gathered.
  
• The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
  

You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE' /mydir/rman_change_track.f';To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true? (Choose three.)

• Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  
• The change tracking file must always be backed up when you perform a full database backup.
  
• Block change tracking will always reduce I/O performed during cumulative incremental backups.
  
• More than one database block may be read by an incremental backup for a change made to a single block.
  
• The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.