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

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: 161 – (Topic 4)

Which of the following best describes a full backup?

  1. All datafiles of a database

  2. All datafiles, archive logs, and control files

  3. All datafiles and control files

  4. All the used blocks in a datafile

Answer: D Explanation:

From the training book:

“Full backup: Makes a copy of each data block that contains data and that is within the files being backed up.”

“A full backup contains all used data file blocks.”

“A full backup is different from a whole database backup.”

Conclusion – it means that not all data files are backed up when you do full backup.

Question No: 162 – (Topic 4)

You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:

RMANgt; CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS;

After configuring the recovery window, you performed the database backup as follows:

  1. Backup RB1 at log sequence number 12871 on 5th Jan

  2. Backup RB2 at log sequence number 15622 on 12th Jan

  3. Backup RB3 at log sequence 16721 on 15th Jan

  4. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all archived redo log files to date.

Answer: D

Question No: 163 – (Topic 4)

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.

What could be a solution to make tape streaming happen during the backup?

  1. Configure backup optimization

  2. Configure the channel to increase MAXOPENFILES

  3. Configure the channel to increase the capacity with the RATE parameter

  4. Configure the channel to adjust the tape buffer size with the BLKSIZE option

Answer: C

Question No: 164 – (Topic 4)

Which command is used to configure RMAN to perform a compressed backup for every backup executed?

  1. BACKUP AS COMPRESSED BACKUPSET DATABASE

  2. BACKUP AS COMPRESSED COPY OF DATABASE

  3. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

  4. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS

  5. BACKUP DATABASE COMPRESS

Answer: C

Question No: 165 – (Topic 4)

Which view provides information on the backup status of the datafiles in the database?

  1. V$BACKUP

  2. V$BACKUP_STATUS

  3. V$BACKUP_DATAFILE

  4. V$DATAFILE_BACKUP

  5. V$TABLESPCE_BACKUP

Answer: A

Question No: 166 – (Topic 4)

What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

  1. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA

  2. CONFIGURE DEFAULT DEVICE TYPE TO TAPE

  3. CONFIGURE DEFAULT DEVICE TYPE TO SBT

  4. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

Answer: C Explanation:

SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.

Question No: 167 – (Topic 4)

Given below are RMAN commands to enable backup optimization and set the retention policy:

RMANgt; CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMANgt; CONFIGURE BACKUP OPTIMIZATION ON;

RMANgt; CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. View the Exhibit to examine the operations performed by using RMAN.

Which two statements are true about the backup of the USERS tablespace? (Choose two.) Exhibit:

Ensurepass 2018 PDF and VCE

  1. It will be backed up as a part of database backup on Friday.

  2. It will be backed up as a part of database backup on Tuesday.

  3. It will not be backed up as a part of database backup on Wednesday.

  4. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

Answer: B,D Explanation: Refer to here.

Backup Optimization for SBT Backups With Redundancy Retention Policy

Question No: 168 – (Topic 4)

What command would you issue to enable automated backups of control files?

  1. alter database controlfile autobackup on

  2. alter system controlfile autobackup on

  3. configure controlfile autobackup on

  4. enable controlfile autobackup

Answer: C

Question No: 169 – (Topic 4)

Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

  1. Differential incremental backup

  2. Different incremental backup

  3. Cumulative backup

  4. Cumulative incremental backup

Answer: A

Question No: 170 – (Topic 4)

Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

  1. a cumulative level 1 backup

  2. a differential level 1 backup

  3. a full backup

  4. a whole backup

Answer: A

Topic 5, Using RMAN to Create Backups

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 *