PrepAway - Latest Free Exam Questions & Answers

Which statement will fail?

Given the DDL shown below:
CREATE TABLE tab1 (col1 CHAR(2), COI2 SMALLINT );
CREATE VIEW v1 AS SELECT col2 FROM tab1 WHERE col2 > 50 ;
CREATE VIEW V2 AS SELECT COI2 FROM v1 WITH LOCAL CHECK OPTION
CREATE VIEW V3 AS SELECT COI2 FROM v2 WHERE COI2 < 200 ;
Which statement will fail?

PrepAway - Latest Free Exam Questions & Answers

A.
INSERT INTO v1 VALUES (5)

B.
INSERT INTO v2 VALUES (5)

C.
INSERT INTO v3 VALUES (75)

D.
INSERT INTO v3 VALUES (200)


Leave a Reply