The Following SQL2 Command Is Executed: CREATE VIEW CUST_SD2 AS

Multiple Choice

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