#1.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.

#2.Which of the following are the structures of the Oracle SGA?

A. The redo log buffer

B. The
shared pool

C. The database buffer cache

D. The parallel pool

E. The undo log entries


Ans:A,B,C

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

A. They are used mainly for recovery

B. They are operating system files

C. They provide
storage for system configuration information

D. None of the choices.

E. They are used mainly for maintaining consistency


Ans:B.



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

A. JServer

B. Enterprise Manager Packs

C.
None of the choices.

D. Partitioning

E. Parallel Server

F. DBA Management Pack


Ans:A

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

A. None of the choices.

B. PGA

C. Instance

D. MGA


E. SGA


Ans:E

#7.Which of the following correctly describe the Oracle instances?

A. They are used mainly for maintaining
consistency

B. They provide storage for system configuration information

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


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

E. They are used mainly for recovery


Ans:C,D.

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

A. Process Monitor

B. Checkpoint Process

C. Database
Writer

D. Log Writer

E. System Monitor


Ans:E.


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

A. Large pool

B. The database buffer cache

C. Java pool

D. The undo log entries

E. The shared pool

F.
The redo log buffer

G. The parallel pool


Ans:A,C

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

A. None of the choices.

B. Database Writer

C. Log Writer

D. System Monitor

E. Process Monitor

F.
Checkpoint Process


Ans:E.

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

A. System Monitor

B. Database Writer

C. Process Monitor

D. Checkpoint Process

E. Log Writer


Ans:B.

---