PrepAway - Latest Free Exam Questions & Answers

Which of the following INSERT statements will execute successfully?

Given the following statements:
CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3));
CREATE VIEW view1 AS
SELECT col1, col2 FROM table1
WHERE col1 < 100
WITH LOCAL CHECK OPTION;
Which of the following INSERT statements will execute successfully?

PrepAway - Latest Free Exam Questions & Answers

A.
INSERT INTO view1 VALUES (50,abc)

B.
INSERT INTO view1VALUES(100, abc)

C.
INSERT INTO view1VALUES(50, ‘abc’)

D.
INSERT INTO view1VALUES(100, ‘abc’)


Leave a Reply