Click the Exhibit button.

The exhibit shows the definition of table CUSTOMER and view V1. Which statement is valid?

A.
UPDATE v1
SET state = “TEXAS” WHERE custnum = 50;

B.
UPDATE v1
SET city = “SANTA CLARA” WHERE custnum = 150;

C.
INSERT INTO v1
VALUES (150,”SMITH”,”TANTAU AVENUE”,”CUPERTINO”);

D.
INSERT INTO v1 (custnum, custname, street, city)
VALUES (50,”SMITH”,”TANTAU AVENUE”,”CUPERTINO”);