1.In Oracle 8i, what is the parameter for configuring the KEEP buffer pool?

Ans:BUFFER_POOL_KEEP


2.To determine the PCTFREE value for a frequently updated table in your Oracle 8i database, which of the following formula should you use?


A. 100*a/(b-a), a is the row size AFTER expansion, b is the initial row size

B. 100*a/(a-b), a is the row size AFTER expansion, b is the
initial row size

C. 100*a/(a+b), a is the row size AFTER expansion, b is the initial row size

D. 100/a/(a-b), a is the row size AFTER
expansion, b is the initial row size


Ans:B

3.Per the recommendation from Oracle, when tuning your 8i database, what should be done prior
to tuning the application design?

A. Tune the Underlying Platform

B. Tune Resource Contention

C. Tune the Data Design

D. Tune I/O
and Physical Structure

E. Tune the Business Rules

F. Tune the Logical Structure of the Database

G. Tune Database Operations


Ans:C


4.You consider the mirroring of your redo logs for maximum protection. Your boss concerns about the performance impact. Which of the following
is true?

A. There will be a serious performance degrade

B. There not will be a serious performance degrade

C. There is absolutely NO
performance degrade

D. Mirroring the redo logs is useless and meaningless

Ans:A

5.You just run SQL Trace. It provides some information
to aid in the SQL statement tuning process. You go through the parse, execute, fetch counts values. What useful information is presented to you?


A. Version number of instances the fetch operations were aborted by scripts

B. Version number of instances the parse operations were aborted
by users

C. Version number of instances the execute operations were aborted by system

D. Number of times the fetch operations were processed


E. Number of times the parse operations were processed

F. Number of times the execute operations were processed


Ans:D,E,F


6.You
are tuning the performance of your Oracle 8i database. To compute the database buffer size in units of bytes, what value, in addition to
DB_BLOCK_BUFFERS, will you need for the computation

Ans:DB_BLOCK_SIZE


7.You are tuning your Oracle 8i database. Why would you want to use
DB_BLOCK_LRU_EXTENDED_STATISTICS?

A. To evaluate the effects of flushing buffer in real time

B. To evaluate the effects of delaying buffer
refreshing

C. To evaluate the effects of parameters adjustment

D. To evaluate the effects of LUR defragmentation

E. To evaluate the
effects of adding buffer

F. To evaluate the effects of adjusting timeout


Ans:E

8.You just run SQL Trace. It provides some information
to aid in the SQL statement tuning process. You want to find out the total number of data blocks read from the datafiles on disks for parse. Which
of the following should you look at?

A. Table reads

B. Physical/logical reads

C. Scan reads

D. Join reads

E. Physical reads


F. Logical reads


Ans:B

9.You are using the Reorg Wizard. What are the options available for your use?

A. Reorganize an entire
tablespace

B. Repair migrated rows

C. Repair un-migrated rows

D. Reorganize specific schema objects


Ans:A,B,D

10.You are
tuning your Oracle 8i database. When setting the buffer pool, what is a good guideline to follow during the creation of the recycle buffer pool?


A. Make it flush every 5 seconds

B. Make it as small as possible to fit into memory

C. Make it flush every 30 seconds

D. Make it as
small as possible to avoid overhead

E. Make it large enough to retain the blocks until the transaction finish

F. Make it large enough to
retain the blocks until the transaction start


Ans:E

---