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

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

Oracle Database 11g: Administration II

Question No: 211 – (Topic 5)

What is an obsolete backup set?

  1. A backup set that is missing one or more backup set pieces

  2. A backup that has exceeded the retention criteria and is no longer needed

  3. A backup set that does not include archived redo logs

  4. A backup set that can not be recovered due to corruption

  5. A backup set superceded by a datafile copy

Answer: B

Question No: 212 – (Topic 5)

Compressed backups work with which of the following commands?

  1. copy as backup

  2. backup as copy

  3. backup

  4. copy

Answer: C Explanation:

The backup compression only works with backup set, NONE of image copies can work with compression.

Topic 6, Performing User-Managed Backup and Recovery

Question No: 213 – (Topic 6)

A database has three online redo log groups with one member each. A redo log member with the status ACTIVE is damages while the database is running.

What is the first step you should take to solve this problem?

  1. Attempt to Issue a checkpoint.

  2. Restart the database using the RESETLOGS option.

  3. Drop the redo log number and create it in a different location.

  4. Perform and incomplete recovery up to the most recent available redo log.

Answer: A 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.

Recovering After the Loss of an Online Redo Log Group Inactive

It is not needed for crash recovery Clear the archived or unarchived group. Active

It is needed for crash recovery Attempt to issue a checkpoint and clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.

Current

It is the redo log that the database is currently writing to Attempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.

Question No: 214 – (Topic 6)

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:

SQLgt; ALTER TABLESPACE users BEGIN BACKUP;

While copying the file to the backup destination a power outage caused the instance to terminate abnormally.

Which statement is true about the next database startup and the USERS tablespace?

  1. The database will open, and the tablespace automatically comes out of the backup mode.

  2. The database will be mounted, and recovery must be performed on the USERS tablespace.

  3. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

  4. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    Answer: C

    Question No: 215 – (Topic 6)

    Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called USERS. The database is still running.

    Which answer properly describes the order of the steps that you would use to recover from this error?

    1. Shut down the database.

    2. Take the users_01.dbf datafile offline with the alter database command.

    3. Restore the users_01.dbf datafile from backup media with the required archived redo logs.

    4. Restore all users tablespace-related datafiles from backup media.

    5. Issue the recover tablespace users command.

    6. Issue the recover datafile users_01.dbf command.

    7. Start up the database.

    8. Bring the users_01.dbf datafile online with the alter database command.

      A. 1, 3, 6, 7

      B. 2, 3, 6, 8

      C. 1, 2,3,6,7

      D. 1, 2, 3, 6, 7, 8

      E. 2, 3,6,5,7

      Answer: B

      Question No: 216 – (Topic 6)

      Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don#39;t want you to shut down the database to perform the backup. What options are available to you?

      1. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.

      2. Just back up the database datafiles without shutting down the database.

      3. You will have to wait until you can shut down the database to perform the backup.

      4. Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.

      5. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

Answer: C

Question No: 217 – (Topic 6)

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)

  1. Control files

  2. Password files

  3. Inactive online redo log file

  4. Archived log files required to perform recovery

  5. Newly created tablespace which is not backed up

    Answer: A,D Explanation:

    The RESETLOGS options is required in:

    1. Imcomplete Recovery

    2. Change of control file

      So that, the control file and archived redo logs are required.

      Question No: 218 – (Topic 6)

      You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?

      1. Restore the SYSTEM tablespace from the last backup set and then recover the database.

      2. Restore the SYSTEM tablespace image copy using the restore command and then restore the database.

      3. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.

      4. The database is not recoverable in this situation with image copies.

      5. Manually copy the datafile image copy to the correct location and then manually restore the database from SQL*Plus.

Answer: C

Question No: 219 – (Topic 6)

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;

While you are performing the backup, an error occurs that causes the instance to terminate abnormally.

Which statement about the DATA1 tablespace is true?

  1. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

  2. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

  3. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

  4. If you restart the database, the database will not be opened.

Answer: D Explanation:

After database instance failure, the BEGIN BACKUP option would not obtain the tablespace online, it will be OFFLINE mode. so that the instance cannot load the database file online.

Question No: 220 – (Topic 6)

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to #39;ora_%t_%s_%r.log#39;. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

  1. The archived redo log files will be overwritten.

  2. The archived redo log files are deleted automatically.

  3. The archived redo log files should be moved to some other location.

  4. The archived redo log files are still maintained because the file names are unique.

    Answer: D

    100% Ensurepass Free Download!
    Download Free Demo:1z0-053 Demo PDF
    100% Ensurepass Free 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
    PDF VCE 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 *