Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 31:

  What command is used to reset a database to a previous incarnation?

  A. reset incarnation

  B. incarnation reset

  C. reset database to incarnation

  D. reset database incarnation

  E. reset databse incarnation number

  Correct Answer: C

• Question 32:

  You execute the following Recovery Manager (RMAN) commands in the following order:

  BACKUP VALIDATE DATABASE; RECOVER CORRUPTION LIST;

  A. Repair the corrupted blocks. If any. In the backup created.

  B. Populate V$COPY_CORRUPTION with names of files that have corrupted blocks.

  C. Back up the database after checking whether array of the files have corrupted blocks.

  D. Discover any corrupt blocks that are viewable with the V$DATABASE_BLOCK_CORRUPTION view.

  E. Repair all corrupted blocks that have been logged in the V$DATABASE_BLOCK_CORRUPTION

  Correct Answer: DE

  V$DATABASE_BLOCK_CORRUPTION displays information about database blocks that were corrupted after the last backup.

  ------------------------------------------------------------------------------- BACKUP...VALIDATE

  Scans the specified files and verifies their contents, testing whether this file can be backed up and whether the data blocks are corrupt. RMAN creates no output files. This option is equivalent to using the VALIDATE command on the

  database files specified in the backup. If you do not specify CHECK LOGICAL, then BACKUP..VALIDATE checks for physical corruption only. If you specify CHECK LOGICAL, then BACKUP VALIDATE checks for both physical and logical

  corruption.

  RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with any corruptions that it finds.

  You can use the SET MAXCORRUPT command to set a limit for the number of corrupt blocks tolerated during the backup validation. The default is zero. If you execute BACKUP INCREMENTAL with VALIDATE, then the behavior depends

  on whether block change tracking is enabled. If change tracking is enabled, then RMAN validates only changed blocks; otherwise, RMAN validates all blocks in the files included in the backup.

  Note: You cannot validate backups of backup sets.

  ------------------------------------------------------------------------------- The following prerequisites apply to RECOVER BLOCK: (link) The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.

  RMAN can only recover blocks marked media corrupt. The V$DATABASE_BLOCK_CORRUPTION view indicates which blocks in a file were marked corrupt since the most recent BACKUP or BACKUP ...

  VALIDATE command was run against the file.

  The backups of the data files containing the corrupt blocks must be full backups and not proxy backups. If only proxy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file

  copies. You can then use the data file copies for block media recovery. RMAN can only archived redo log files for recovery. Block media recovery cannot survive a missing or For RMAN to be able to search the flashback logs for good copies

  of corrupt blocks, Flashback Database must be enabled on the target database. For RMAN to be able to search a standby database for good copies of corrupt blocks, the target database must be associated with a physical standby database

  in a Data Guard environment. In addition, the physical standby database must be open read-only in managed recovery.

• Question 33:

  Which of the following methods can be used to detect block corruption?

  A. ANALYZE operations

  B. dbv

  C. SQL queries that access the potentially corrupt block

  D. RMAN

  E. All of the above

  Correct Answer: E

• Question 34:

  Which statement describes the scenario that must have produced this warning?

  A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR).

  B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

  C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE.

  D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.

  Correct Answer: C

• Question 35:

  Which of the following does the recover command not do?

  A. Restore archived redo logs.

  B. Apply archived redo logs.

  C. Restore incremental backups.

  D. Apply incremental backups.

  E. Restore datafile images.

  Correct Answer: A

• Question 36:

  What will be the end result of this set of RMAN commands?

  shutdown abort

  startup mount

  restore datafile 4 until time '09/30/2008:15:00:00';

  recover datafile 4 until time '09/29/2008:15:00:00';

  alter database open resetlogs;

  A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.

  B. The restore command will fail.

  C. The recover command will fail.

  D. The alter database open resetlogs command will fail.

  E. All these commands will fail because they must be in the confines of a run block.

  Correct Answer: D

  Pay attention on the difference between two timestamps.

• Question 37:

  Which command would you use to determine what database backups are currently available for restore?

  A. list database backup;

  B. report database backup;

  C. list backup of database;

  D. list summary backup;

  E. report backup of database;

  Correct Answer: C

• Question 38:

  What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?

  A. crosscheck

  B. list backup

  C. confirm

  D. resync

  E. backup validate

  Correct Answer: A

  Crosscheck A check to determine whether files on disk or in the media management catalog correspond to the data in the RMAN repository. Because the media manager can mark tapes as expired or unusable, and because files can be deleted from disk or otherwise become corrupted, the RMAN repository can contain outdated information about backups. Run the CROSSCHECK command to perform a crosscheck.

  The "control file" in the

• Question 39:

  You want to make sure that your database backup does not exceed 10 hours in length.

  What command would you issue that would meet this condition?

  A. backup database plus archivelog;

  B. backup database plus archivelog until time 10:00;

  C. backup database plus archivelog timeout 10:00;

  D. backup database plus archivelog duration 10:00;

  E. backup database plus archivelog timeout 10:00;

  Correct Answer: D

• Question 40:

  When you create a backup control file, where is the resulting file written to?

  A. The database user dump destination directory

  B. The database diagnostic destination directory

  C. To $ORACLE_HOME/rdbms

  D. To $ORACLE_HOME/admin

  E. To the directory and filename you specify in the command

  Correct Answer: E