View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view.PRODCAT

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view.PRODCAT

Post by answerhappygod »

View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view.PRODCAT_VW is used in the GET_DATA procedure.GET_DATA is called in the CHECK_DATA function.A new column PROD_QTY is added to the PRODUCTS table.How does this impact the status of the dependent objects?
View The Exhibi 1
View The Exhibi 1 (55.72 KiB) Viewed 128 times
A. All dependent objects remain valid.
B. Only the procedure and function become invalid and must be recompiled.
C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply