Which of the following INSERT statements will execute successfully?

seenagape

9 years ago

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?

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’)