（15）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 will be allocated when a session starts.

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

D.Private SQL Area will be allocated in the Program Global Area (PGA) always.

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

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

答案：（A、F）

解析：

B（X）. 实例启动时Shared SQL Area被分配

D（X）. Private SQL Area分为Persistent Area和Runtime Area，Runtime Area一直位于PGA中，而Persistent Area对于Dedicated Server它位于PGA中；对于Shared Server位于SGA中。

E（X）. Shared SQL Area在SGA中

ITPub博客

Oracle 11G OCP 1Z0-052 15