This preview shows page 1. Sign up to view the full content.
Unformatted text preview: o log member does not have to be exactly at 5 times the database block size. This
restriction works for minimal extent size.
C: Redo log member does not use the default size specified during the CREATE DATABASE
command, because members in different redo groups can have different size. Just all members in
one group must have the same size.
D: Redo logs do not use existing size of files log1b.rdo and log2b.rdo.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-332
Chapter 7: Managing the Physical Database Structure
Which SQL command forces a log switch and causes a checkpoint to occur?
A. ALTER SYSTEM CHECKPOINT
B. ALTER DATABASE CHECKPOINT
C. ALTER SYSTEM SWITCH LOGFILE
D. ALTER DATABASE SWITCH LOGFILE
Answer C is correct. A log switch is the point at which LGWR fills one online redo log group
Actualtests.com - The Power of Knowing 1Z0-023
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 LOGFIL...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09