CSC 544 Test 1questions and answers
Key Components of Oracle11g ✅✅Enterprise Manager: Console, Database Control, Grid Control
Oracle Net Service: SQL*Plus, Utilities, Precompilers, Add-Ons
Java/Web: Add-ons
Types of Memory ✅✅System Global Area (SGA): Allocated when instance is started.
Program Global Area (PGA): Used in session connection memory. Broken into private chunks for
each server process.
Instance ✅✅Background process, Memory (SGA)
Database ✅✅Database file, Control file, Redo log file
Database Instance ✅✅Runs on a database server and uses data inside the database.
Oracle Instance ✅✅Part of an Oracle database executing in memory, made up of processes and
memory structures.
Dedicated server ✅✅Every user session has its own server process.
Shared server ✅✅Uses CPU and memory more efficiently by swapping out user sessions during
idle time.
Datafiles ✅✅Physical files stored in the OS. Datafiles can be stored on separate disk drives.
Multiple tablespaces cannot share the same datafile.
Tablespaces ✅✅Logical overlays of underlying datafiles, allowing access to data stored in
datafiles. A tablespace can contain multiple datafiles.
Tables in tablespaces ✅✅SYSTEM: Mandatory tablespace for critical database components.
Key Components of Oracle11g ✅✅Enterprise Manager: Console, Database Control, Grid Control
Oracle Net Service: SQL*Plus, Utilities, Precompilers, Add-Ons
Java/Web: Add-ons
Types of Memory ✅✅System Global Area (SGA): Allocated when instance is started.
Program Global Area (PGA): Used in session connection memory. Broken into private chunks for
each server process.
Instance ✅✅Background process, Memory (SGA)
Database ✅✅Database file, Control file, Redo log file
Database Instance ✅✅Runs on a database server and uses data inside the database.
Oracle Instance ✅✅Part of an Oracle database executing in memory, made up of processes and
memory structures.
Dedicated server ✅✅Every user session has its own server process.
Shared server ✅✅Uses CPU and memory more efficiently by swapping out user sessions during
idle time.
Datafiles ✅✅Physical files stored in the OS. Datafiles can be stored on separate disk drives.
Multiple tablespaces cannot share the same datafile.
Tablespaces ✅✅Logical overlays of underlying datafiles, allowing access to data stored in
datafiles. A tablespace can contain multiple datafiles.
Tables in tablespaces ✅✅SYSTEM: Mandatory tablespace for critical database components.
