IBM
C2090-600 · Question #8
Given the following: What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);
The correct answer is C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2. See the full explanation below for the reasoning.
Question
Given the following:
What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);
Exhibit
Options
- AThe insert will succeed as it passes validation.
- BThe insert will succeed as there is no WITH CHECK OPTION on view V3.
- CThe insert will result in an error as it violates the WITH CHECK OPTION on view V2.
- DThe insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.
How the community answered
(19 responses)- A5% (1)
- C84% (16)
- D11% (2)
Community Discussion
No community discussion yet for this question.