PrepAway - Latest Free Exam Questions & Answers

What should you do?

You want to modify an existing view so that any rows that are inserted or updated with the
view will not violate the SELECT statement that was used to create the view. What should
you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Alter the view and add the ENFORCE SELECT clause to the view definition.

B.
Drop and recreate the view with the WITH CHECK OPTION clause specified.

C.
Alter the view and add the WITH CHECK OPTION clause to the view definition.

D.
Create a new view with the same name and the ENFORCE SELECT clause specified.


Leave a Reply