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