The following SQL2 command is executed: CREATE VIEW CUST_SD2 AS
SELECT * FROM CUSTOMER
WHERE Cregion = 'SD'
WITH CHECK OPTION
There is a request to execute the following SQL2 command:
UPDATE CUST_SD2
SET AGE = AGE +1,Cregion = 'LA' WHERE CNAME = 'BLACK'
Select the most appropriate statement:
A) After execution of this query, SELECT * from CUST_SD2 will show a value of 41 for BLACK
B) After execution of this query, SELECT * from CUSTOMER will show a value of 41 for BLACK
C) Both of the above
D) No update took place

Question

Quizplus · Accepted Answer

The update statement is trying to update a record in the view CUST_SD2, but the WHERE clause only filters on CNAME and not Cregion. Since the view was created with a constraint that only allows rows where Cregion = 'SD', the update will not be allowed to change Cregion to 'LA'. Therefore, no update will take place in either the view or the original table.

The Following SQL2 Command Is Executed: CREATE VIEW CUST_SD2 AS