What is difference between procedure and functio

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

(Continued from previous question...)

What is difference between procedure and function.

A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable.

(Continued on next question...)

Other Job Interview Questions

• There is a % sign in one field of a column. What will be the query to find it?
• How you will avoid your query from using indexes?
• What is use of Applications listener ?
• There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?
• Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global OraInventory after clone ?
• What is .dbc file , where its stored , whats use of .dbc file ?
• What is difference between ADPATCH and OPATCH ?
• What is FNDSM ?
• Can a function take OUT parameters. If not why?
• What is Web Listener ?
• More...