Q21
Single choice
Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM
v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;
INSERT INTO v1 VALUES(5);
INSERT INTO v2 VALUES(5);
INSERT INTO v3 VALUES(20);
INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?