Testpassport IBM 000-541 exam has 120 Q&As , all the question cover the latest real test and with all the correct answer. Testpassport promise the 120 Q&A for IBM 000-541 : DB2 9.7 DBA for Linux UNIX and Windows completely covered . ensure you pass more than 96% scores ^^
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?
A. INSERT INTO v2 VALUES (35)
B. INSERT INTO v1 VALUES (5)
C. INSERT INTO v3 VALUES (25)
D. INSERT INTO v3 VALUES (200)
Answer: C
related exam : IBM 000-004
Powered By