053-265

转载于 2017-11-15 16:04:00 发布 · 68 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Babylon/p/7839470.html

本文探讨了在数据库中，当PRODUCTS表新增PROD_QTY字段时，对其它依赖对象如视图PRODCAT_VW、过程GET_DATA及函数CHECK_DATA的影响。分析了不同对象的有效状态变化及自动重新验证机制。

View the Exhibit for the object interdependency diagram.
The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function. A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status of the dependent objects?

A. All dependent objects remain valid.
B. Only the procedure and function become invalid and must be recompiled.
C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.