#1.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 parse
operations were aborted by users

B. Number of times the parse operations were processed

C. Number of times the execute operations were
processed

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

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

F. Number of times the fetch operations were processed

Ans:B,C,F.

#2.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 not will be a serious
performance degrade

B. There is absolutely NO performance degrade

C. There will be a serious performance degrade

D. Mirroring the redo
logs is useless and meaningless


Ans:A.

#3.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/(a+b), 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/(b-a), 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:D.

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

Ans:BUFFER_POOL_KEEP.


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

A. Tune the Data Design

B. Tune Database Operations

C. Tune the Business Rules

D. Tune Resource
Contention

E. Tune I/O and Physical Structure

F. Tune the Logical Structure of the Database

G. Tune the Underlying Platform

Ans:A.



#6.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. Physical reads

B. Logical reads

C.
Scan reads

D. Table reads

E. Physical/logical reads

F. Join reads


Ans:E.

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

A. Reorganize specific schema objects

B. Reorganize an entire tablespace

C. Repair migrated rows

D.
Repair un-migrated rows


Ans:A,B,C


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


A. To evaluate the effects of delaying buffer refreshing

B. To evaluate the effects of parameters adjustment

C. To evaluate the effects
of LUR defragmentation

D. To evaluate the effects of adjusting timeout

E. To evaluate the effects of adding buffer

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

Ans:E.


#9.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:BD_BLOCK_SIZE.


#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 30 seconds

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

C. Make it as small as
possible to avoid overhead

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

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

F. Make it flush every 5 seconds


Ans:D.

---