I

DB2 9.7 DBA for Linux UNIX and Windows

103 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

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?
 

Choose the correct option from the given list.
01 / 103

0 Discussions

Trending Exams