What is difference between an implicit and an ex

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

(Continued from previous question...)

What is difference between an implicit and an explicit cursor.

The implicit cursor is used by Oracle server to test and parse the SQL statements and the explicit cursors are declared by the programmers.

(Continued on next question...)

Other Job Interview Questions

• How will you find Invalid Objects in database ?
• Where is applications start/stop scripts stored ?
• What is difference between a formal and an actual parameter?
• What should be the return type for a cursor variable. Can we use a scalar data type as return type?
• How do you pass cursor variables in PL/SQL?
• What is .dbc file , where its stored , whats use of .dbc file ?
• What is iAS Patch ?
• Which is more faster - IN or EXISTS?
• What are between database triggers and form triggers?
• What is Multi Node System ?
• More...