How do you open and close a cursor variable. Why

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

(Continued from previous question...)

How do you open and close a cursor variable. Why it is required?

Using OPEN cursor_name and CLOSE cursor_name commands. The cursor must be opened before using it in order to fetch the result set of the query it is associated with. The cursor needs to be closed so as to release resources earlier than end of transaction, or to free up the cursor variable to be opened again.

(Continued on next question...)

Other Job Interview Questions

• Can you clone from multi node system to single node system and vice versa ?
• ADIDENT UTILITY is used for what ?
• What is US directory in $AD_TOP or under various product TOP's .
• Where is DATABASE/PLSSQL cache stored ?
• Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why its used ?
• What are cursor attributes?
• If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?
• How to compile Invalid Objects in database ?
• What is OCI. What are its uses?
• What is difference between Rename and Alias?
• More...