What are the advantages of using a PACKAGE?

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

(Continued from previous question...)

What are the advantages of using a PACKAGE?

1. Avoid having to bind a large number of DBRM members into a plan
2. Avoid cost of a large bind
3. Avoid the entire transaction being unavailable during bind and automatic rebind of a plan
4. Minimize fallback complexities if changes result in an error.

(Continued on next question...)

Other Job Interview Questions

• What does it mean if the null indicator has -1, 0, -2? –
• What is REORG? When is it used?
• What is CHECK PENDING ?
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?
• What are the isolation levels possible ?
• Can I use LOCK TABLE on a view?
• What is ALTER ?
• What are aggregate functions?
• What is ACQUIRE/RELEASE in BIND?
• What is CHECK PENDING ?
• More...