Shared Pool and Large Pool - 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 two allocations can use the large pool? Select all correct answers.
	A.	I/O buffers for RMAN backup and restore operations
	B.	Shared SQL execution plans
	C.	General overflow from the shared pool
	D.	Session memory for shared server connections

2.	With `CURSOR_SHARING=EXACT`, which two statements below have identical SQL text for parent-cursor matching? Select all correct answers.
	A.	`select * from COIN where coin_year = 1999`
	B.	`select * from COIN where coin_year=1999`
	C.	`select * from coin where coin_year=1999`
	D.	`select * from COIN where coin_year=1999`

3.	Which three items are cached in the shared pool? Select all correct answers.
	A.	Shared SQL execution plans
	B.	Redo entries awaiting LGWR
	C.	Database buffer-cache replacement lists
	D.	Copies of table and index data blocks
	E.	Cached data dictionary information
	F.	Compiled PL/SQL program units

4.	Where are `MEMOPTIMIZE FOR WRITE` fast-ingest inserts buffered in Oracle AI Database 26ai? Select the best answer.
	A.	The shared pool
	B.	The redo log buffer
	C.	An ingest buffer in the large pool
	D.	The database buffer cache

5.	Which two statements about the library cache are correct? Select all correct answers.
	A.	It is the general overflow area for the large pool.
	B.	It caches executable SQL and PL/SQL code in the shared pool.
	C.	It contains control structures such as locks and library cache handles.
	D.	Its main purpose is to buffer RMAN backup I/O.