How would you go about increasing the buffer cache hit ratio?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain the use of table functions.
Where in the Oracle directory tree structure are audit traces placed?
How would you determine what sessions are connected and what resources they are waiting for?
Give two methods you could use to determine what DDL changes have been made.
What view would you use to determine free space in a tablespace?
How would you determine who has added a row to a table?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
HOW TO SPOT AHIERARCHY?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?