Which two statements are true about Shared SQL Area and Private SQL Area? (Choose
two.)
A.
The whole of Private SQL Area will be allocated in the Program Global Area (PGA)
always
B.
Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool
C.
The number of Private SQL Area allocations is dependent on the OPEN_CURSORS
parameter
D.
Shared SQL Area will be allocated in the shared pool
E.
Shared SQL Area will be allocated when a session starts
F.
Shared SQL Area will be allocated in the large pool always
The answer is:
C.
The number of Private SQL Area allocations is dependent on the OPEN_CURSORS
parameter
D.
Shared SQL Area will be allocated in the shared pool