YOU ARE CREATING A VIEW NAMED WEEKLYSALES. THIS VIEW IS USED TO CRE...

1. You are creating a view named WeeklySales. This view is used to create a sales

report that is presented to management at the beginning of each week. You

want to ensure that the underlying tables on which this view is based are not

accidentally modified causing the report to break. What is the easiest way to

implement this?

A. Use a CREATE VIEW WITH CHECK constraint to create a view.

B. Use a CREATE VIEW WITH SCHEMABINDING statement to create

the view.

C. Do nothing. When a view is based on a table, the underlying table cannot

be modified until the view is dropped.

D. Use a DDL trigger to roll back any statement that attempts to modify the

table that the view depends on.