[Free] 2018(Jan) Dumps4cert Braindumps Oracle 1z0-053 Dumps with VCE and PDF 261-270

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 261 – (Topic 6)

Your database is running In ARCHIVELOG mode. One of the data files, USERDATA01.DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.

Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

  1. Redo logs

  2. Control file

  3. The latest backup of only the damaged data file

  4. The latest backup of all the data file in the USERS tablespace

  5. Temporary files of temporary tablespace

  6. Archive Logs since the latest backup to point of failure

Answer: A,C,F

Question No: 262 – (Topic 6)

Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

  1. alter tablespace DAVE_TBS backup mode;

  2. alter tablespace DAVE_TBS start backup;

  3. alter tablespace DAVE_TBS begin backup;

  4. alter tablespace DAVE_TBS backup begin;

  5. alter tablespace DAVE_TBS backup;

Answer: C

Question No: 263 – (Topic 6)

Another DBA issues a shutdown abort command on a database on which you were running an online backup.

What will happen when you try to restart the database?

  1. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.

  2. Oracle will automatically take the datafile out of hot backup mode and then open the database.

  3. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mode. You will need to correct this error before you can open the database.

  4. The database will open with the file in hot backup mode. You can restart the backup at any time.

  5. The datafile in hot backup mode will be corrupted and you will have to recover it.

Answer: C

Question No: 264 – (Topic 6)

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?

  1. Restore and recover the datafile.

  2. Restore and recover the tablespace.

  3. Restore and recover the database.

  4. Restore and recover the control file.

  5. Restore and recover the parameter file.

Answer: A

Question No: 265 – (Topic 6)

Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

  1. Archive log generation is suspended until the tablespaces are taken out of hot backup


  2. Datafiles are not written to during hot backups.

  3. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

  4. The datafile headers are not updated during the backup.

  5. The way data is written to the online redo logs is unchanged during the backup.

Answer: D

Question No: 266 – (Topic 6)

Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)

  1. Database datafiles

  2. Online redo logs

  3. Archived redo logs

  4. Backup control file

  5. Control file from a backup

    Answer: A,C,D

    Question No: 267 – (Topic 6)

    You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?

    1. Take the datafiles that were lost offline.

    2. startup mount the database

    3. Issue the alter database open command.

    4. Restore the datafiles that were lost

    5. Recover the datafiles with the recover datafile command.

    6. Bring the datafiles back online.

    7. Recover the database with the recover database command.

      A. 2, 1, 3, 4, 5, 6

      B. 2, 4, 5, 3

      C. 4, 7, 3

      D. 2, 4, 7, 3

      E. 2, 7, 3

      Answer: B

      Question No: 268 – (Topic 6)

      You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

      1. Mount the database

      2. Open the database in NORMAL mode

      3. Open the database in RESTRICTED mode

      4. Open the database with the RESETLOGS option

Answer: A Explanation:

After restoring the control file, it is time to load the restored control file onto the database instance, to issue STARTUP MOUNT command to load it.

Question No: 269 – (Topic 6)

What methods of point-in-time recovery are available? (Choose all that apply.)

  1. Change-based

  2. Cancel-based

  3. Time-based

  4. Sequence number-based

  5. Transaction number-based

Answer: A,B,C,D

Question No: 270 – (Topic 6)

A database is running In ARCHIVELOG mode. It has two online redo log groups and each group has one member.

A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.

  1. Restore the corrupted redo log group.

  2. Restore from a whole database backup.

  3. Perform incomplete recovery.

  4. Relocate by renaming the member of the damaged online redo log group to a new location.

  5. Open the database with the RESETLOGS option.

  6. Restart the database instance.

  7. Issue a checkpoint and clear the log.

Identify the option with the correct sequential steps to accomplish the task efficiently.

A. 1, 3, 4, and 5

B. 7, 3, 4. and 5

C. 2, 3, 4, and 5

D. 7, 4, 3. and 5

E. Only 6 is required

Answer: C Explanation:

Recovering After Losing All Members of an Online Redo Log Group

If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure and the archiving mode of the database.

If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not. Table 30-4 outlines the various recovery scenarios.

Dumps4Cert 2018 PDF and VCE


Topic 7, Using RMAN to Perform Recovery

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

Dumps4cert 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.