9. Which of the following area of PGA stores binding variables and run-time buffers information?a) Stack spaceb) SQL areac) Session aread) Private SQL area

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

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

Local variables are stored in an area called ___________OptionsPermanent storage areaHeapFree memoryStack

rrect answerThe storage area for auto variableOptionscacheprocessor registermain memoryvirtual