Given the following:
What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |