PrepAway - Latest Free Exam Questions & Answers

Which statement will fail?

Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ;
CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ;
Which statement will fail?

PrepAway - Latest Free Exam Questions & Answers

A.
INSERT INTO v2 VALUES (35)

B.
INSERT INTO v1 VALUES (5)

C.
INSERT INTO v3 VALUES (25)

D.
INSERT INTO v3 VALUES (200)


Leave a Reply