Question 61 :
Use the add_group_column function to add a column to record group that was created at a design time?
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?
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?
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)
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)
Oracle provide the following tools/ utilities to assist with performance monitoring and tuning:
. UTLBSTAT.SQL and UTLESTAT.SQL - Begin and end stats monitoring
. Oracle Enterprise Manager - Tuning Pack