[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-053 Dumps with VCE and PDF 111-120

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 111 – (Topic 2)

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

shutdown abort startup mount

restore datafile 4 until time #39;09/30/2008:15:00:00#39;; recover datafile 4 until time #39;09/29/2008:15:00:00#39;; alter database open resetlogs;

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

  2. The restore command will fail.

  3. The recover command will fail.

  4. The alter database open resetlogs command will fail.

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

Answer: D Explanation:

Pay attention on the difference between two timestamps.

Question No: 112 – (Topic 2)

What are the different logging modes available in Oracle Database 11g? (Choose two.)

  1. NOLOG mode


  3. LOGGING mode


  5. ARCHIVELOG mode

Answer: B,E

Question No: 113 – (Topic 2)

Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command

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

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

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

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

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

Answer: C

Question No: 114 – (Topic 2)

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.

Identify the two events that can occur in the event of a log switch? (Choose two.)

  1. An entry is created in the alert log file and the database instance continues to function normally

  2. The log switch hangs occur for transactions until free space is available in the flash recovery area

  3. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

  4. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: B,C

Question No: 115 – (Topic 2)

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

  1. The database user dump destination directory

  2. The database diagnostic destination directory

  3. To $ORACLE_HOME/rdbms

  4. To $ORACLE_HOME/admin

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

Answer: E

Question No: 116 – (Topic 2)

View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.

Ensurepass 2018 PDF and VCE

Which statement is true about the block corruption detected by the command? Exhibit:

  1. No action is taken except the output in the Exhibit.

  2. The ADVISE FAILURE command is automatically called to display the repair script.

  3. The failure is logged into the Automatic Diagnostic Repository (ADR).

  4. The corruption is repaired by the command implicitly.

Answer: C Explanation:

Detection of Block Corruption (link)

Oracle Database supports different techniques for detecting, repairing, and monitoring block corruption. The technique depends on whether the corruption is interblock corruption or intrablock corruption. In intrablock corruption, the corruption occurs within the block itself. This corruption can be either physical or logical. In aninterblock corruption, the corruption occurs between blocks and can only be logical.

For example, the V$DATABASE_BLOCK_CORRUPTION view records intrablock corruptions, while the Automatic Diagnostic Repository (ADR) tracks all types of corruptions. Table 16-1 summarizes how the database treats different types of block corruption.

Question No: 117 – (Topic 2)

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

  1. crosscheck

  2. list backup

  3. confirm

  4. resync

  5. backup validate

Answer: A Explanation: 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 quot;control filequot; in the QUESTION NO: is acting as the RMAN repository if the RMAN use control file store metadata.

Topic 3, Using the RMAN Recovery Catalog (RC)

Question No: 118 – (Topic 3)

What RMAN command must you use before you can back up a database using the recovery catalog?

  1. create catalog

  2. install database

  3. catalog database

  4. merge Catalog with database

  5. register database

Answer: E

Question No: 119 – (Topic 3)

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

  5. Option E

Answer: D Explanation:

Use the EXECUTE SCRIPT command to run a stored script. If GLOBAL is specified, then a

global script with this name must exist in the recovery catalog; otherwise, RMAN returns error RMAN-06004. If GLOBAL is not specified, then RMAN searches for a local stored script defined for the current target database. If no local script with this name is found, then RMAN searches for a global script by the same name and executes it if one is found.

Ensurepass 2018 PDF and VCE


Question No: 120 – (Topic 3)

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).

Identify two scenarios is which you must have a recovery catalog. (Choose two.)

  1. To store the backup information of multiple database

  2. To restrict the amount of space that is used by the backups

  3. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

  4. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

Answer: A,D

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-053 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.