Oracle cursor : Implicit & Explicit cursors

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

(Continued from previous question...)

61. Oracle cursor : Implicit & Explicit cursors

Oracle uses work areas called private SQL areas to create SQL statements. PL/SQL construct to identify each and every work are used, is called as Cursor. For SQL queries returning a single row, PL/SQL declares all implicit cursors. For queries that returning more than one row, the cursor needs to be explicitly declared.

(Continued on next question...)

Other Job Interview Questions

• Shall we create procedures to fetch more than one record?
• What are the different Parameter types?
• Is it possible to link two groups inside a cross products after the cross products group has been created?
• Where is the external query executed at the client or the server?
• What is the use of break group?
• Briefly, how do you install Oracle software on UNIX.
• What is the remove on exit property?
• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• What are the different file extensions that are created by oracle reports?
• How to implement the multiple control files for an existing database?
• More...