Which two statements are true about Shared SQL Area and Private SQL Area?

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

A.
Shared SQL Area will be allocated in the shared pool

B.
Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

C.
The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

D.
Shared SQL Area will be allocated in the large pool always

E.
Shared SQL Area will be allocated when a session starts

F.
The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mr_tienvu

mr_tienvu

I agree with the answer. AF