READ Free Dumps For Oracle- 1z0-023
| Question ID 8831 | Which SQL command forces a log switch and causes a checkpoint to occur?
|
| Option A | ALTER SYSTEM CHECKPOINT
|
| Option B | ALTER DATABASE CHECKPOINT
|
| Option C | ALTER SYSTEM SWITCH LOGFILE
|
| Option D | ALTER DATABASE SWITCH LOGFILE
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. A log switch is the point at which LGWR fills one online redo log group with information. At every log switch, a checkpoint occurs. A checkpoint (CKPT) is when LGWR DBWR to write all changes made to data blocks in memory to disk, and DBWR does it. ALTER SYSTEM SWITCH LOGFILE command forces a log switch and causes a checkpoint to occur. Incorrect Answers: A: There is no ALTER SYSTEM CHECKPOINT command in Oracle. C: There is no ALTER DATABASE CHECKPOINT command in Oracle. D: There is no ALTER DATABASE SWITCH LOGFILE command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 328-330 Chapter 7: Managing the Physical Database Structure
| Question ID 8832 | Which two dynamic performance views could you query to display the number of online redo log groups and the current log groups? (Choose two)
|
| Option A | V$LOG
|
| Option B | V$THREAD
|
| Option C | V$SESSION
|
| Option D | V$ARCHIVE
|
| Option E | V$INSTANCE
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B are correct. V$LOG view gives comprehensive information about the current status of the redo log. V$THREAD view provides information about the number of online redo log groups. Incorrect Answers: C: V$SESSION dictionary view contains information about every session currently connected to Oracle. D: There is no V$ARCHIVE view in Oracle. E: V$INSTANCE shows information about Oracle instance itself, not redo log groups. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 325-327 Chapter 7: Managing the Physical Database Structure