#1.What statistic reflects the number of times a user process waits for space in the redo log buffer?


Ans:REDO BUFFER ALLOCATION RETRIES

#2.Per the recommendation from Oracle, when tuning your 8i database, what should be done prior to tuning
the OS platform?

A. Tune the Business Rules

B. Tune the Data Design

C. Tune the Logical Structure of the Database

D. Tune Database
Operations

E. Tune I/O and Physical Structure

F. Tune Resource Contention

Ans:F.


#3.In Oracle 8i, from what view can you find out
and determine if there are multiple processes trying to access the same disk simultaneously?


Ans:V$FILESTAT.

#4.You just used Oracle
Expert for a tuning session. An analysis report is generated. Which of the following information is NOT included?

A. List of all attributes for
the instance you are interested in

B. List of all attributes for all the instances that have been run in the past 24 hours

C. List of all
attributes for all the instances that have been run since the last reboot

D. List of all attributes for all the instances currently running



Ans:B,C,D.

#5.In Oracle 8i, what is used to control the allocation of space for redo entries in the redo log buffer?

A. buffer control
latch

B. redo control latch

C. redo allocation latch

D. cache latch

E. contention latch


Ans:C.

#6.In Oracle 8i, what
buffer pool is used for keeping the object schemas in memory?

A. RESET

B. RECYCLE

C. DEFAULT

D. TIME

E. None of the choices.


F. KEEP


Ans:F.

#7.In Oracle 8i, what value for REDO BUFFER ALLOCATION RETRIES will you consider as "healthy"?

A. close to zero


B. about 10

C. less than 90

D. None of the choices.

E. negative


Ans:A.

#8.In Oracle 8i, what buffer pool is used for
eliminating unneeded data blocks in memory?

A. DEFAULT

B. RESET

C. TIME

D. RECYCLE

E. None of the choices.

F. KEEP



Ans:D.


#9.Per the recommendation from Oracle, what is the last step in tuning your 8i database?

A. Tune the Data Design

B. Tune
the Application Design

C. Tune the Logical Structure of the Database

D. Tune Database Operations

E. Tune Resource Contention

F. Tune
the Underlying Platform

G. Tune I/O and Physical Structure

H. Tune the Business Rules


Ans:F.


#10.In Oracle 8i , what columns in
V$LATCH reflects willing-to-wait requests?

A. WRITES

B. GETS

C. SLEEPS

D. MISSES

E. READS


Ans:B,C,D.

---