English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Backup and Recovery 

АвторSubject: Q65
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Oracle performs a delayed block clean out and flushes the dirty blocks in he database buffer cache to disk during a checkpoint. A checkpoint is when Oracle writes all dirty buffers in the buffer cache to disk. Behind the scenes, Oracle's CKRT process marks the datafile header as current, and records the sequence number for the current checkpoint in the control file(s). Checkpoints are used to ensure that, at some point, all of the information in both the buffer cache is copied to disk, which synchronizes write activities performed by LGWR and DBWR.
Incorrect Answers:
1: A checkpoint will occur at least as often as a log switch, but can occur more frequently, depending on several factors.
2: Oracle does not perform a control file. Control file is used to mount and open database.
4: Oracle copies the online redo log files to the archive destinations regardless a checkpoint.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 5695-571
Chapter 12: Overview of Backup and Recovery

Current tread:
back to list

Q65 - Go to question 10:10 19.01.08

back to list
Up ^ gen. 0.08 Server date 03:57 10-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments