File Info
| Exam | Oracle Database 11g: Administration II |
| Number | 1z0-053 |
| File Name | Oracle.1z0-053.ActualTests.2019-02-07.443q.tqb |
| Size | 11 MB |
| Posted | Feb 07, 2019 |
| Download | Oracle.1z0-053.ActualTests.2019-02-07.443q.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
Which statement is true regarding the VALIDATE DATABASE command?
- It checks the database for intrablock corruptions only.
- It checks for block corruption in the valid backups of the database.
- It checks the database for both intrablock and interblock corruptions.
- It checks for only those corrupted blocks that are associated with data files.
Correct answer: A
Explanation:
interblock corruption A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption. intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption. interblock corruption
A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption.
intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption.
Question 2
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch’
LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN_SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?
- The online redo log file is not allowed to be overwritten.
- The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
- The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
- The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Correct answer: D
Question 3
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.
What do you do?
- Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
- Tell them that their request cannot be met with the current backup strategy.
- Restore the 19ths backup, apply the online redo logs, and open the database.
- Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
- Use the recover database command to roll back the database from today to the 19th of the month.
Correct answer: B
