Multiple choice

Which of the following is the correct statement about the System Global Area (SGA) in memory structure of Oracle Database?

  1. It is a shared memory region that contains data and control information for one Oracle instance.

  2. The database buffers and the shared pool are not the parts of SGA.

  3. It also consists of stack-space and session-information.

  4. It maintains the memory in a non-shared medium.

  5. One can create a number of instances for the shared memory.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle allocates the SGA when an instance starts and deallocates it when the instance shuts down.

Keep practicing — related questions