Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Exam Prep Questions

1:	What is the name of the background process that writes the online redo log files out to the archive logs when the database is running in ARCHIVELOG mode? A. ARCn B. DBWn C. LGWR D. CKPT
A1:	Answer A is correct. Archiver (or ARCn) is responsible for archiving the redo log files. Answer B is incorrect because Database Writer (DBWn) is responsible for writing the dirty buffers out to the data files. Answer C is incorrect because Log Writer (LGWR) is responsible for taking care of the online redo log files but not the archived redo log files. Answer D is incorrect because checkpoint has nothing to do with archive logs but is key in telling DBWn when to write out the dirty buffers.
2:	What is the name of the single parameter that ...