PrepAway - Latest Free Exam Questions & Answers

What will be the result of the following SQL statement?

Given the following:

What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);

PrepAway - Latest Free Exam Questions & Answers

A.
The insert will succeed as it passes validation.

B.
The insert will succeed as there is no WITH CHECK OPTION on view V3.

C.
The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

D.
The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.


Leave a Reply