Oracle Practica 1

Practice 1: Oracle Architectural Components
1 Which one of the following statements is true?
a An Oracle server is a collection of data consisting of three file types.
b A user establishes aconnection with the database by starting an Oracle instance.
c A connection is a communication pathway between the Oracle server and the
Oracle instance.
d A session starts when a user is validated bythe Oracle server.
2 Which one of the following memory areas is not part of the SGA?
a Database Buffer Cache
b PGA
c Redo Log Buffer
d Shared Pool
3 Which two of the following statements aretrue about the Shared Pool?
a The Shared Pool consists of the Library Cache, Data Dictionary Cache, Shared
SQL area, Java Pool, and Large Pool.
b The Shared Pool is used to store the most recentlyexecuted SQL statements.
c The Shared Pool is used for an object that can be shared globally.
d The Library Cache consists of the Shared SQL and Shared PL/SQL areas.
4 Which one of the followingmemory areas is used to cache the data dictionary
information?
a Database Buffer Cache
b PGA
c Redo Log Buffer
d Shared Pool
5 The primary purpose of the Redo Log Buffer is to record all changesto the database
data blocks.
a True
b False
6 The PGA is a memory region that contains data and control information for multiple
server processes or multiple background processes.
a True
bFalse
7 Which of the following becomes available when an Oracle instance is started?
a User process
b Server process
c Background processes
8 Identify five mandatory background processes.
1. DBWn2. PMON
3. CKPT
4. LGWR
5. SMON





9 Match the process with its task.
a Database Writer 1 Assists with writing to the data file headers
b Log Writer 2Is responsible for instance recovery
c System Monitor 3 Cleans up after failed processes
d Process Monitor 4 Records database changes for recovery purposes
e Checkpoint...