READ Free Dumps For Oracle- 1z0-023
| Question ID 8833 | All members of the current online redo log group are not available. Which action does Oracle take?
|
| Option A | The instance crashes.
|
| Option B | The instance writes to the next online redo log group
|
| Option C | The instance hangs until the DBA switches the redo log file.
|
| Option D | The instance hangs until the DBA restart the archive process.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. The instance will crash if all members of the current online redo log group are not available. To avoid this situation Oracle recommends to use multiplexing of redo log files. If the redo log file has only one member, or if multiple online redo log members are not multiplexed and not available, LGWR will not be able to write redo log entries, and the Oracle instance will fail. Incorrect Answers: B: LGWR will not write changes to the next online redo log group. Oracle instance will fail. C: Oracle instance will not hang, like it does when there is no space for archived log files, it will just crash. D: Restarting of archive process ARCH will not help in this situation, because instance will fail. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-332 Chapter 7: Managing the Physical Database Structure
| Question ID 8834 | A data block is put on the free list when the _____ data space in the block falls _____ the _______ setting.
|
| Option A | Free, below, PCTFREE
|
| Option B | Free, above, PCTFREE
|
| Option C | Used, below, PCTUSED
|
| Option D | Used, above, PCTUSED
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. When the used data space in the block falls below the PCTUSED setting, a data block is put on the free list of blocks and can be used for new inserts. Incorrect Answers: A: When the free data space in the block falls below the PCTFREE settings a data block will be out of the free list. B: The free data space in the block cannot fall above the PCTFREE setting, it can fall just below it. D: The used data space in the block cannot fall above the PCTUSED setting, it can just fall below it. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352 Chapter 7: Managing the Physical Database Structure