File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
I agree. Here's the link:
subject: Oracle dependencies query
It's not a secret anymore!