Program Global Area (PGA) - 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.	What does PGA stand for in Oracle memory architecture? Select the best answer.
	A.	Process Global Area
	B.	Program Global Area
	C.	PL/SQL Global Area
	D.	Primary Global Area

2.	In a dedicated server configuration, which two items reside in the server process's PGA? Select all correct answers.
	A.	Private SQL areas
	B.	Shared executable PL/SQL package code
	C.	Session-specific PL/SQL variable values
	D.	Shared SQL execution plans

3.	Which statement correctly describes an individual PGA? Select the best answer.
	A.	It is private to its owning Oracle process or thread.
	B.	It is shared by every session in the instance.
	C.	It is a component of the shared pool.
	D.	It is one memory area shared by all instances in a cluster.

4.	Which part of a private SQL area holds bind variable values and is released when the cursor is closed? Select the best answer.
	A.	The run-time area
	B.	The shared SQL area
	C.	The sort area
	D.	The persistent area

5.	With shared server connections, where is the user global area (UGA) stored? Select the best answer.
	A.	Always in one shared server process's PGA
	B.	In the SGA: the large pool when configured, otherwise the shared pool
	C.	In the redo log buffer
	D.	Only on the client; the database keeps no session state