Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?
A.
INSERT INTO view2VALUES(50, ‘abc’)
B.
INSERT INTO view1 VALUES (100, ‘abc’)
C.
INSERT INTO view2VALUES(150, ‘abc’)
D.
INSERT INTO view1VALUES(100, ‘abc’)