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.