[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 81-90

2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 81 – (Topic 2)

If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

  1. The alter database archivelog command will fail.

  2. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.

  3. The alter database archivelog command will succeed.

  4. The alter database archivelog command will ask if you want to make the database consistent first.

  5. There is no alter database archivelog command. The correct command is alter database alterlogging.

Answer: A Explanation:

Before you change database to archivelog mode, you need to have a clean database shutdown.

Question No: 82 – (Topic 2)

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

  1. list database backup;

  2. report database backup;

  3. list backup of database;

  4. list summary backup;

  5. report backup of database;

Answer: C

Question No: 83 – (Topic 2)

You execute the following Recovery Manager (RMAN) commands in the following order: BACKUP VALIDATE DATABASE;


Which (two tasks are performed by these commands? (Choose two.)

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

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

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

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

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

Answer: D,E Explanation:

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 use only archived redo log files for recovery. Block media recovery cannot survive a missing or inaccessible log, although it can sometimes survive missing or inaccessible records (see Oracle Database Backup and Recovery User#39;s Guide).

->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 No: 84 – (Topic 2)

View the Exhibit and examine the Data Pump architecture. Identify the numbered components.


Ensurepass 2018 PDF and VCE

  1. 1 – Oracle Loader, 2 – Oracle Data Pump, 3 – Direct Path API

  2. 1 – Oracle Data Pump, 2 – Direct Path API, 3 – Oracle Loader

  3. 1 – Direct Path API, 2 – Oracle Loader, 3 – Oracle Data Pump

  4. 1 – Oracle Loader, 2 – Direct Path API, 3 – Oracle Data Pump

Answer: A

Question No: 85 – (Topic 2)

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  1. Multiple change tracking files can be created for a database.

  2. The change tracking file must be created after the first level 0 backup.

  3. RMAN does not support backup and recovery of the change tracking file.

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

Answer: C,D

Question No: 86 – (Topic 2)

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?

  1. backup database plus archivelog;

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

  3. backup database plus archivelog timeout 10:00;

  4. backup database plus archivelog duration 10:00;

  5. backup database plus archivelog timeout 10:00;

Answer: D

Question No: 87 – (Topic 2)

What is the purpose of the recover command? (Choose all that apply.)

  1. Recover database datafiles from physical disk backup sets.

  2. Recover required incremental backups from physical disk backup sets.

  3. Recover required archived redo logs from physical disk backup sets.

  4. Apply incremental backups to recover the database.

  5. Apply archived redo logs to recover the database.

Answer: B,C,D,E

Question No: 88 – (Topic 2)

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

  1. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

  2. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

  3. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

  4. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

Answer: C,D

Question No: 89 – (Topic 2)

How is block-change tracking enabled?

  1. With alter database enable block change tracking

  2. With alter system enable block change tracking

  3. With an init.ora parameter change

  4. With an spfile parameter change

Answer: A

Question No: 90 – (Topic 2)

You run the following commands:

RMANgt; list expired backup; RMANgt; delete expired backup;

What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?

  1. They will be renamed.

  2. Nothing will happen to them. The backup set pieces do not exist.

  3. They will be deleted immediately since they are not in the flash recovery area.

  4. You will need to manually remove the physical files listed in the output of the commands.

  5. They will become hidden files and removed 10 days later.

Answer: B

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

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

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


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