Set - 9

Question 61 :

Use the add_group_column function to add a column to record group that was created at a design time?

Answer :

False


Question 62 :

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Answer :

Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.


Question 63 :

What is the use of break group? What are the various sub events a mouse double click event involves?

Answer :

A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.


Question 64 :

What tuning indicators can one use? (for DBA)

Answer :

The following high-level tuning indicators can be used to establish if a database is performing optimally or not:
. Buffer Cache Hit Ratio
Formula: Hit Ratio = (Logical Reads - Physical Reads) / Logical Reads
Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio
. Library Cache Hit Ratio
Action: Increase the SHARED_POOL_SIZE to increase hit ratio


Question 65 :

What tools/utilities does Oracle provide to assist with performance tuning? (for DBA)

Answer :

Oracle provide the following tools/ utilities to assist with performance monitoring and tuning:
. TKProf
. UTLBSTAT.SQL and UTLESTAT.SQL - Begin and end stats monitoring
. Statspack
. Oracle Enterprise Manager - Tuning Pack