When do you use WHERE clause and when do you use

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

When do you use WHERE clause and when do you use HAVING clause?

The WHERE condition lets you restrict the rows selected to those that satisfy one or more conditions. Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE.

(Continued on next question...)

Other Job Interview Questions

• What are main configuration files in Web Server (Apache) ?
• If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?
• How do you open and close a cursor variable. Why it is required?
• How many ORACLE HOME are Oracle Applications and whats significance of each ?
• What is difference between an implicit and an explicit cursor.
• What is *.DBC file and whats is location of DBC file ?
• Where is applications start/stop scripts stored ?
• What is forms server executable Name ?
• What are different modes of forms in which you can start Forms Server and which one is default ?
• What is a OUTER JOIN?
• More...