READ Free Dumps For Oracle- 1z0-023
| Question ID 8892 | Which database operation reads redo logs?
|
| Option A | Commit
|
| Option B | Rollback
|
| Option C | Recover
|
| Option D | Shutdown abort
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Recover operation uses redo logs for recovery purposes. Incorrect Answers: A: Commit operation does not read redo log files. C: Rollback operation does not read redo log files. D: After SHUTDOWN ABORT instance is stopped without database close. This operation does not use redo log files. But they will be used after this type of shutdown to recover database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 332-333 Chapter 7: Managing the Physical Database Structure
| Question ID 8893 | How should you set the parameter LOG_CHECKPOINT_ to disable time-based checkpoints?
|
| Option A | TIMEOUT to 0
|
| Option B | INTERVAL to 0
|
| Option C | TIMEOUT to FALSE
|
| Option D | INTERVAL to FALSE
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. You need to set LOG_CHECKPOINT_TIMEOUT to zero to disable time-based checkpoints. LOG_CHECKPOINT_TIMEOUT is the number of seconds that should pass before another checkpoint occurs. When a log switch occurs, LGWR stops writing to the current online redo log group, a checkpoint occurs and DBWR writes the dirty buffers to the datafiles. DBWR writes to the datafiles at every log switch. The frequency of checkpoints can be controlled by these initialization parameters: LOG_CHECKPOINT_INTERVAL enables checkpoints based on the number of blocks processed. Setting the parameter to 0 disables interval checkpoints. LOG_CHECKPOINT_TIMEOUT enables time-based checkpoints. Setting the parameter to 0 disables time-based checkpoints Incorrect Answers: B: The value you set for LOG_CHECKPOINT_INTERVAL is the number of operating system blocks LGWR should write to the redo log (after a log switch) before a checkpoint should occur. C: LOG_CHECKPOINT_TIMEOUT is numeric value. D: LOG_CHECKPOINT_INTERVAL is numeric value. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 328-329 Chapter 7: Managing the Physical Database Structure