How do you pass cursor variables in PL/SQL?

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

(Continued from previous question...)

How do you pass cursor variables in PL/SQL?

Pass a cursor variable as an argument to a procedure or function. You can, in essence, share the results of a cursor by passing the reference to that result set.

(Continued on next question...)

Other Job Interview Questions

• How you will avoid your query from using indexes?
• What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?
• How to retrieve SYSADMIN password ?
• What is a pseudo column. Give some examples?
• What is main concurrent Manager types.
• Where is Concurrent Manager log file location.
• How can you licence a product after installation ?
• Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?
• What is forms server executable Name ?
• What is difference between SUBSTR and INSTR?
• More...