Monday, July 24, 2006

Architecture Q & A set 1

Practice 1:
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 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 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

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

No comments:

Post a Comment