Un-Answered Questions { Oracle }

How would you go about increasing the buffer cache hit ratio?

1959


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6743


Explain the use of table functions.

1803


Where in the Oracle directory tree structure are audit traces placed?

2129


How would you determine what sessions are connected and what resources they are waiting for?

1614


Give two methods you could use to determine what DDL changes have been made.

6028


What view would you use to determine free space in a tablespace?

1783


How would you determine who has added a row to a table?

1798


What is an SQL FORMS ?

2312


Design database draw er diagram for a certain scenario ?

4105


Query to retrieve record for a many to many relationship ?

2081


What are the built-in functions used for sending Parameters to forms ?

2847


Can you have more than one content canvas view attached with a window ?

1817


Is the After report trigger fired if the report execution fails ?

2406


Is it possible to split the print reviewer into more than one region ?

1837