> > >

DB2 Programming MCQs

Given the following DDL statements: CREATE TABLE Smart1 (a INT, b INT, c INT) CREATE VIEW View1 AS SELECT a,b,c FROM Smart1 WHERE a > 250 WITH CHECK OPTION Which of the following INSERT is correct

INSERT INTO Smart1 VALUES (200, 2, 3)

INSERT INTO Smart1 VALUES (350, 2, 3)

INSERT INTO View1 VALUES (250, 2, 3)

INSERT INTO View1 VALUES (300, 2, 3)

Answer

Correct Answer: INSERT INTO View1 VALUES (300, 2, 3)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Programming Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it