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.
Bạn đang xem 1. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P163 DOC