1.What facilities of Oracle 8i Enterprise allows you to define API for supporting IIOP?

A. Parallel
Server

B. Enterprise Manager Packs

C. DBA Management Pack

D. None of the choices.

E. JServer

F. Partitioning

Ans:E

2.In
Oracle, what is known as the memory area used to store database information that is shared by the database processes?

A. PGA

B. None of the
choices.

C. MGA

D. Instance

E. SGA


Ans:E

3.Which of the following correctly describe the database files in Oracle?

A. They
are operating system files

B. They are used mainly for recovery

C. They are used mainly for maintaining consistency

D. None of the
choices.

E. They provide storage for system configuration information


Ans:A

4.Which of the following are the valid characteristics of
the Oracle data files?

A. they form tablespaces

B. each database has at least one data file.

C. each data file can be associated with
only one database.

D. they might be automatically extended


Ans:A,B,C,D

5.Which of the following are the structures of the Oracle SGA?


A. The undo log entries

B. The shared pool

C. The parallel pool

D. The redo log buffer

E. The database buffer cache



Ans:B,D,E

6.What Oracle background process is responsible for cleaning up resources used by failed processes?

A. Process Monitor


B. Checkpoint Process

C. None of the choices.

D. System Monitor

E. Database Writer

F. Log Writer


Ans:A

7.Which of the
following memory structures of the Oracle SGA are considered as OPTIONAL in Oracle 8i?

A. The database buffer cache

B. The redo log buffer


C. The undo log entries

D. The parallel pool

E. Large pool

F. Java pool

G. The shared pool


Ans:E,F

8.Which of the
following correctly describe the Oracle instances?

A. They consist of the SGA memory structure and the background processes

B. Each of them
can open and use only one database at a time.

C. They are used mainly for recovery

D. They are used mainly for maintaining consistency


E. They provide storage for system configuration information


Ans:A,B

9.What Oracle background process is responsible for writing
changed data from the buffer cache to the data files?

A. Log Writer

B. System Monitor

C. Process Monitor

D. Checkpoint Process


E. Database Writer


Ans:E

10.What Oracle background process is responsible for maintaining database consistency?

A. Process Monitor


B. Database Writer

C. Log Writer

D. Checkpoint Process

E. System Monitor


Ans:E

---