SGA Memory Structures - Quiz

Answer all five questions about Oracle AI Database 26ai. Each question is worth one point. For checkbox questions, select every correct option and no incorrect options to earn the point; there is no partial credit. Submit to see your score and explanations.

1.	Which SGA component caches copies of data blocks read from data files? Select the best answer.
	A.	The database buffer cache
	B.	The redo log buffer
	C.	The shared pool
	D.	The large pool

2.	Which optional buffer pool is intended to keep selected objects in memory and reduce repeated physical reads? Select the best answer.
	A.	The permanent buffer pool
	B.	The KEEP buffer pool
	C.	The default buffer pool
	D.	The pinned buffer pool

3.	Which two statements about dirty buffers in the database buffer cache are correct? Select all correct answers.
	A.	They contain modified blocks that have not yet been written to the data files.
	B.	They contain only redo entries waiting for LGWR.
	C.	They cannot contain changes from committed transactions.
	D.	Database writer processes write dirty buffers to the data files.

4.	What is the primary purpose of the redo log buffer? Select the best answer.
	A.	To cache old archived redo logs for queries
	B.	To hold redo entries until LGWR writes them to the online redo log
	C.	To store the data blocks that DBW writes to data files
	D.	To sort redo entries before archiving

5.	Which statement best describes how Oracle tracks buffer usage when deciding what to retain in the buffer cache? Select the best answer.
	A.	Every access physically moves the data block to another memory address.
	B.	Touch counts help identify frequently used buffers within an LRU-based replacement algorithm.
	C.	A buffer is permanently pinned after its first access.
	D.	All buffers are replaced strictly in the order in which they were loaded.