File Info
| Exam | Oracle Database 11g: Administration II |
| Number | 1z0-053 |
| File Name | Oracle.1z0-053.PracticeTest.2018-03-29.404q.tqb |
| Size | 12 MB |
| Posted | Mar 29, 2018 |
| Download | Oracle.1z0-053.PracticeTest.2018-03-29.404q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
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.
- 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.
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?
- The backup will terminate because the FORMAT clause was not configured for the channel
- It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
- It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
- 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.)
- Backup retention policy
- Default backup device type
- Default destinations for backups
- Multiple backup device types for single backup
- 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.
