Multiple choice

When is the SGA created in an Oracle database environment?

  1. When the database is created

  2. When the instance is started

  3. When the database is mounted

  4. When a user process is started
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The System Global Area (SGA) is allocated when the Oracle instance starts up, not when the database is created or mounted. The instance consists of memory structures (SGA) and background processes. Database creation creates physical files, mounting reads the control file, but neither allocates the SGA. User processes connect to an already-running instance with an existing SGA.

Keep practicing — related questions