learn java
The moose likes Oracle/OAS and the fly likes Oracle dependencies query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle dependencies query" Watch "Oracle dependencies query" New topic

Oracle dependencies query

Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188

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.

Answer: D

I wanted to know how D is the correct answer , as the view is based on non null columns !!
Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188

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
Have you tried LearnNowOnline? http://www.learnnowonline.com/
subject: Oracle dependencies query