This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android forum!
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
db2 - 703 certification
DB2 700 and 701 - Test Sample
Trouble with model for calculating and adding table values dependent on multiple rows
Question about table model listener
GridBagLayout problem