Oracle Faqs

DBA Fundamentals I 1-42

Practice 1: Solutions
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 a connection 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 by the 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 cache
d Shared Pool
3 Which two of the following statements are true 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 recently executed SQL statements and the
most recently used data.
c The Shared Pool is used for object that can be shared globally.
d The Library Cache consist of the Shared SQL and Shared PL/SQL areas.
4 Which one of the following memory areas is used to cache the data dictionary
information?
a Database Buffer Cache
b PGA
c Redo log buffer cache
d Shared Pool
5 The primary purpose of the Redo Log Buffer Cache is to record all changes to the
database data blocks.
a True
b False
Answer: True
6 The PGA is a memory region that contains data and control information for multiple
server processes or multiple background processes.
a True
b False

7 Which one of the following processes is available when an Oracle instance is started.
a User process
b Background process
c Server process
d System process
8 Identify the six mandatory background processes.
________________________________________
________________________________________
________________________________________
________________________________________
________________________________________
________________________________________
9 Which one of the following memory areas is used to cache the data dictionary
information?
a Database Buffer Cache
b PGA
c Redo log buffer cache
d Shared Pool
10 Match the process with its task.
a Database Writer ___ Assists with writing to the data file headers
b Log Writer ___ Responsible for instance recovery
c System Monitor ___ Cleans up after failed processes
d Process Monitor ___ Records database changes for recovery purposes
e Checkpoint ___ Writes dirty buffers to the data files
11 The physical structure of an Oracle database consists of control files, data files, and
redo log files.
a True
b False
12 Place the following structures in order of hierarchy beginning with database.
a Tablespaces
b Extent
c Segment
d database
e block