Which memory structure in an Oracle instance is exclusive to each server process and contains control information for that process?A) Database buffer cacheB) Program Global Area (PGA)C) Large PoolD) System Global Area (SGA)

Which of the following memory structures are part of the SGA? A. The PL/SQL pool B. The log buffer C. The shared pool D. The database buffer cache E. The program global area

The main memory accommodates ____________a.Central processing unitb.Operating systemc.All of the mentionedd.User processes

Which of the following is NOT a component of the System Global Area (SGA)?A) Database buffer cacheB) Redo log bufferC) Program Global Area (PGA)D) Shared pool

8. Which of the following components comprise an Oracle architecture?a) Tablespacesb) Datafilesc) Database related background processesd) All of the Mentioned

Apart from the buffer that hold data retrieved from the databases and the buffer that hold instance recovery information, the following are specific pools in a SGA, except... A. All these options B. Java C. shared D. varied E. stream