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.
答案:d。
a Database Buffer Cache
b PGA
c Redo Log Buffer
d Shared Pool
答案:b。
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.
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 following memory 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 changes to the database
data blocks.
a True
b False
server processes or multiple background processes.
a True
b False
a User process
b Server process
c Background processes
8 Identify five mandatory background processes.
答案:DBWn,LGWR,SMON,PMON,CKPT
9 Match the process with its task.
a Database Writer 1 Assists with writing to the data file headers
b Log Writer 2 Is 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 5 Writes dirty buffers to the data files
online redo log files.
a True
b False
11 Place the following structures in order of hierarchy beginning with database.
a Tablespaces
b Extent
c Segment
d Database
e Block
12 Identify the components of an Oracle server.
答案:database,instance。
13 Identify the components of an Oracle instance.
答案:内存结构(或SGA)和后台进程
答案:data files,control files,redo log files。