Multiple choice technology databases

Oracle Instance comprises of

  1. Physical files

  2. Memory buffers

  3. Background processes

  4. Database
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

An Oracle Instance consists of memory structures (SGA and PGA) and background processes. The System Global Area (SGA) is a shared memory region containing data and control information for one Oracle instance. Background processes are processes that handle various tasks like database writing, log writing, and process monitoring. Physical files and the database itself are storage components, not instance components.

Keep practicing — related questions