IBM

C2090-610 · Question #80

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

The correct answer is C. Ensure that any inserted or updated rows conform to the definition of the view. See the full explanation below for the reasoning.

Question

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

Options

ADefine a view on one or more tables or views.
BRevalidate all invalid objects that are referenced on a view's fullselect.
CEnsure that any inserted or updated rows conform to the definition of the view.
DDefine a view that only consists of columns that have check constraints defined.

How the community answered

(24 responses)

A
17% (4)
B
8% (2)
C
71% (17)
D
4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-610 Practice