Download Oracle.1z0-053.PracticeTest.2018-03-29.404q.vcex

Download Exam

File Info

Exam Oracle Database 11g: Administration II
Number 1z0-053
File Name Oracle.1z0-053.PracticeTest.2018-03-29.404q.vcex
Size 10 MB
Posted Mar 29, 2018
Download Oracle.1z0-053.PracticeTest.2018-03-29.404q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' 
LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' 
LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' 
LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' 
Identify the statement that correctly describes this setting.


  1. The MANDATORY location must be a flash recovery area.
  2. The optional destinations may not use the flash recovery area.
  3. This setting is not allowed because the first destination is not set as MANDATORY.
  4. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
Correct answer: D
Explanation:
MANDATORY Specifies that filled online log files must be successfully archived to the destination before they can be reused. If MANDATORY is not specified, then, by default, the destination is considered to be optional. At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.
MANDATORY 
Specifies that filled online log files must be successfully archived to the destination before they can be reused. 
If MANDATORY is not specified, then, by default, the destination is considered to be optional. 
At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.



Question 2

You issued the following commands to configure setting in RMAN; 
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; 
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; 
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; 
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; 
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; 
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 
Which statement is true about the execution of the above command?


  1. The backup will terminate because the FORMAT clause was not configured for the channel
  2. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
  3. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
  4. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
Correct answer: D



Question 3

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)


  1. Backup retention policy
  2. Default backup device type
  3. Default destinations for backups
  4. Multiple backup device types for single backup
  5. Default section size for backups
Correct answer: ABC
Explanation:
SECTION SIZE cannot be configured through CONFIGURE command.
SECTION SIZE cannot be configured through CONFIGURE command.



Question 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
Correct answer: C



Question 5

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
Correct answer: A



Question 6

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
Correct answer: A



Question 7

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:
RMAN> 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.
Correct answer: D



Question 8

You issue the following RMAN command to set a retention policy on a database:
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; 
What will be the outcome of issuing this command?


  1. After two days, a backup will be marked obsolete
  2. After two days, a backup will be deleted from the media
  3. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
  4. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
Correct answer: D



Question 9

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; 
RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 
Which prerequisite must be met before accomplishing the backup?


  1. Provide a password for the encryption
  2. Set up an Oracle wallet for the encryption
  3. No setup is required as it is a default encryption method
  4. Both Oracle wallet and password must be set up for the encryption
Correct answer: B



Question 10

Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; 
RMAN> CONFIGURE BACKUP OPTIMIZATION ON; 
RMAN> 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:
  


  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.
Correct answer: BD
Explanation:
Backup Optimization for SBT Backups With Redundancy Retention Policy
Backup Optimization for SBT Backups With Redundancy Retention Policy









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files