How do you reference a Parameter?

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

(Continued from previous question...)

340. How do you reference a Parameter?

In Pl/SQL, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = ‘’ or :block.item = PARAMETER Parameter name

(Continued on next question...)

Other Job Interview Questions

• What is the fastest query method for a table?
• Diffrence between a “where” clause and a “having” claus
• What are the built-ins used for Creating and deleting groups?
• Give some examples of Analytical functions
• Do you consider yourself a development DBA or a production DBA and why?
• Give two UNIX kernel parameters that effect an Oracle install
• How to drop the index ?
• How do you switch to DOS prompt from SQL prompt?
• Do you consider yourself a development DBA or a production DBA and why?
• What are the various sub events a mouse double click event involves?
• More...