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 view1 VALUES(100, abc)
C. INSERT INTO view1 VALUES(50, ‘abc’)
D. INSERT INTO view1 VALUES(100, ‘abc’)
|
Download Printable PDF. VALID exam to help you PASS. |
 |