Download Oracle Database 11g: Administration II.1z0-053.PracticeTest.2018-06-11.425q.vcex
| Vendor: | Oracle |
| Exam Code: | 1z0-053 |
| Exam Name: | Oracle Database 11g: Administration II |
| Date: | Jun 11, 2018 |
| File Size: | 9 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
What command would you issue to enable automated backups of control files?
- alter database controlfile autobackup on
- alter system controlfile autobackup on
- configure controlfile autobackup on
- enable controlfile autobackup
Correct answer: C
Question 2
You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.
What must you set using the RMAN CONFIGURE command to achieve this?
- MAXSETSIZE TO 2;
- DEVICE TYPE DISK PARALLELISM 2;
- RETENTION POLICY TO REDUNDANCY 2;
- DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct answer: D
Explanation:
Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link) Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)
Question 3
Which of the following best describes a full backup?
- All datafiles of a database
- All datafiles, archive logs, and control files
- All datafiles and control files
- All the used blocks in a datafile
Correct 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. 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 4
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?
- Differential incremental backup
- Different incremental backup
- Cumulative backup
- Cumulative incremental backup
Correct answer: A
Question 5
Which type of backup must be performed first with an incremental backup?
- Level 1
- Level 0
- Level 2
- Level 3
Correct answer: B
Question 6
Which of the following most closely represents an image copy?
- Unix cp command of a file
- Bit-by-bit copy of a file
- Windows COPY command of a file
- All of the above
Correct answer: D
Question 7
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?
- Channel failover
- Restartable backups
- Rescheduable backups
- Automatic backup recovery
- Channel recovery
Correct answer: A
Question 8
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?
- CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
- CONFIGURE DEFAULT DEVICE TYPE TO TAPE
- CONFIGURE DEFAULT DEVICE TYPE TO SBT
- CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
Correct answer: C
Explanation:
SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike. SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.
Question 9
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN. (choose all that apply)
- Limiting the input/output (I/O) bandwidth consumption
- Specifying the size of backup sets and backup pieces
- Specifying vendor-specific information for a media manager
- Specifying the parallelism for backup and restore operations
Correct answer: AC
Explanation:
Link to here: Configuring Advanced Channel Options Link to here: Configuring Advanced Channel Options
Question 10
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.
- The MANDATORY location must be a flash recovery area.
- The optional destinations may not use the flash recovery area.
- This setting is not allowed because the first destination is not set as MANDATORY.
- 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.
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!