Incorrect answers a redo log member does not have to

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 QUESTION 85: 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 Explanation: Answer C is correct. A log switch is the point at which LGWR fills one online redo log group - 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.

Ask a homework question - tutors are online