aspose file tools*
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
Author

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: http://aspose.com/file-tools
 
subject: Oracle dependencies query
 
Similar Threads
GridBagLayout problem
Question about table model listener
Trouble with model for calculating and adding table values dependent on multiple rows
DB2 700 and 701 - Test Sample
db2 - 703 certification