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’)
C
0
0
WITH LOCAL CHECK OPTION
The WITH LOCAL CHECK OPTION clause is identical to the WITH CASCADED CHECK OPTION clause except that you can update a row so that it can no longer be retrieved through the view. This can happen only when the view is directly or indirectly dependent on a view that was defined with no WITH CHECK OPTION clause.
0
0