Oracle 11G OCP 1Z0-052 15

（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1175894/，如需轉載，請註明出處，否則將追究法律責任。