Consider the following View definition and update statement:

What will be the result of this?

a. The update can be successfully made but only the PRODUCT table will be updated.

b. The update can be successfully made and both the View and PRODUCT table will be updated.

c. The update will be halted because of the WITH CHECK OPTION.

d. The update can be successfully made but only the View will be updated.

Transcribed Image Text:

CREATE VIEW TOPPRODUCTS(PRODNR,PRODNAME,QUANTITY) AS SELECT PRODNR, PRODNAME, AVAILABLE_QUANTITY FROM PRODUCT WHERE AVAILABLE_QUANTITY>100 WITH CHECK OPTION UPDATE TOPPRODUCTS SET QUANTITY=80 WHERE PRODNR=0153