How does this impact the status of the dependent objects?

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?
Exhibit:

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?
Exhibit:

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.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

jabrzoza

jabrzoza

A is correct.
From: Home / Database / Oracle Database Online Documentation 11g Release 1 (11.1) / Database Administration / Managing Object Dependencies

“Between a referenced object and each of its dependent objects, the database tracks the elements of the referenced object that are involved in the dependency. For example, if a single-table view selects only a subset of columns in a table, only those columns are involved in the dependency. For each dependent of an object, if a change is made to the definition of any element involved in the dependency (including dropping the element), the dependent object is invalidated. Conversely, if changes are made only to definitions of elements that are not involved in the dependency, the dependent object remains valid.”

Reply