[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 171-180

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 171 – (Topic 5)

Which backup option defines a user-defined name for a backup?

  1. FORMAT

  2. NAME

  3. TAG

  4. FORMAT U%

Answer: C

Question No: 172 – (Topic 5)

Which of the following RMAN structures can data from a datafile span?

  1. RMAN backup-set pieces spanning backup sets

  2. RMAN backup-set pieces within a given backup set

  3. RMAN backups

  4. RMAN channels

  5. None of the above

Answer: B

Question No: 173 – (Topic 5)

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

  1. backup database

  2. backup database and archivelogs

  3. backup database plus archivelogs

  4. backup database plus archivelog delete input

  5. backup database and archivelog delete input

Answer: D

Question No: 174 – (Topic 5)

Consider the following command:

backup database plus archivelog delete input;

How many backup sets would be created by this command if the following were true:

->Control-file auto backups were enabled.

->The size of backup sets was not restricted.

->One channel was allocated.

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

Answer: D Explanation: RMANgt; show all;

RMAN configuration parameters for database with db_unique_name TESTDB are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO

#39;%F#39;; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #

default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM #39;AES128#39;; # default

CONFIGURE COMPRESSION ALGORITHM #39;BASIC#39; AS OF RELEASE #39;DEFAULT#39; OPTIMIZE FOR LOAD

TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO

#39;/u01/app/oracle/product/11.2.0/dbhome_1/ dbs/snapcf_testdb.f#39;; # default

RMANgt; Backup database plus archivelog delete input;

Starting backup at 19-DEC-13 current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=10 RECID=5 STAMP=834597174 input archived log thread=1 sequence=11 RECID=6 STAMP=834597417 channel ORA_DISK_1: starting piece 1 at 19-DEC-13

channel ORA_DISK_1: finished piece 1 at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp tag=TAG20131219T163657 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_10_9c5csl13_.arc RECID=5 STAMP=834597174 archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_11_9c5d19cn_.arc RECID=6 STAMP=834597417 Finished backup at 19-DEC-13

Starting backup at 19-DEC-13 using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/testdb/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/testdb/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/testdb/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/testdb/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-DEC-13

channel ORA_DISK_1: finished piece 1 at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp tag=TAG20131219T163703 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05 Finished backup at 19-DEC-13

Starting backup at 19-DEC-13 current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=12 RECID=7 STAMP=834597550

channel ORA_DISK_1: starting piece 1 at 19-DEC-13 channel ORA_DISK_1: finished piece 1 at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp tag=TAG20131219T163911 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_12_9c5d5g7r_.arc RECID=7 STAMP=834597550

Finished backup at 19-DEC-13

Starting Control File and SPFILE Autobackup at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2013_12_19/ o1_mf_s_834597553_9c5d5lz1_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 19-DEC-13 RMANgt; list backup;

Latesttests 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 175 – (Topic 5)

If a backup set is expired, what can you do to correct the problem?

  1. Change the retention criteria.

  2. Make the lost backup set pieces available to RMAN again.

  3. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.

  4. Nothing. The backup set piece is lost forever.

  5. Call Oracle support, their assistance is required.

Answer: B

Question No: 176 – (Topic 5)

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  1. Data Pump Export and Import

  2. conventional export and import

  3. the CONVERT command of RMAN

  4. the BACKUP AS COPY command of RMAN

    Answer: D Explanation:

    If you have enough disk space that you can have both your entire non-ASM database and your ASM disk group on disk at the same time, you can do the migration directly without using tapes.

    1. Back up your database files as copies to the ASM disk group.

      BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT ‘ DISK’ TAG ‘ORA_ASM_MIGRATION’;

      REF: Oracle(r) 10g Backup and Recovery Advance User’s Guide, 16-2

      Question No: 177 – (Topic 5)

      What does the output on this report indicate?

      Latesttests 2018 PDF and VCE

      1. The my_data_01.dbf datafile is corrupted and needs to be restored.

      2. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.

      3. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.

      4. The my_data_01.dbf datafile no longer meets the retention criteria for backups.

      5. Datafile 5 is missing.

Answer: B

Question No: 178 – (Topic 5)

Which two statements are true about encrypting RMAN backup? (Choose two.)

  1. The transparent encryption of backups uses the encryption wallet

  2. The database uses the same encryption key for every encrypted backup

  3. The password encryption of backups only uses the password while creating and restoring backup

Answer: A,C

Question No: 179 – (Topic 5)

You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5;

Which statement is true about executing this command?

  1. It will display a list of files that need incremental backup

  2. It will display a list of files that need backup after five days

  3. It will display a list of files that were backed up in the last five days

  4. It will display a list of files that have not been backed up in the last five days

  5. It will apply the current retention policy to determine the files that need to be backed up

Answer: D

Question No: 180 – (Topic 5)

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

  1. stored scripts in the recovery catalog

  2. backups that can be deleted from disk

  3. backup sets and image copies are obsolete

  4. backups that do not have the AVAILABLE status in the RMAN repository

Answer: A,D Explanation:

About the LIST command

The primary purpose of the LIST command is to list backup and copies. For example, you can list:

->Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file

->Backups that have expired

->Backups restricted by time, path name, device type, tag, or recoverability

->Archived redo log files and disk copies

Besides backups and copies, RMAN can list other types of data. For example, you can list:

->Backup sets and proxy copies

->Image copies

->Archived redo log files

->Database incarnations

->Databases in a Data Guard environment

->Backups and copies for a primary or standby database in a Data Guard environment

->Restore points

->Names of stored scripts

->Failures for use with Data Recovery Advisor

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

Latesttests 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

2018 Latesttests IT Certification PDF and VCE