The QUERY_PRODUCT procedure directly references the product table. There is a NEW_PRODUCT_VIEW view created based on the NOT NULL columns of the table. The ADD_PRODUCT procedure updates the table indirectly by the way of NEW_PRODUCT_VIEW view. Under which circumstances does the procedure
ADD_PRODUCT get invalidated but automatically get complied when invoked?
A. When the NEW_PRODUCT_VIEW is dropped.
B. When rows of the product table are updated through SQI Plus.
C. When the internal logic of the QUERY_PRODUCT procedure is modified.
D. When a new column that can contain null values is added to the product table.
E. When a new procedure s created that updates rows in the product table directly.
I wanted to know how D is the correct answer , as the view is based on non null columns !!
Joined: Jun 28, 2007
Okay i got it, views get invalidated when the base table is modified get recompiled again when queried if the change is such that it does not affect the view