You work as a database administrator at Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB03. You have received instruction from the CIO to create a view to join the Customers and Orders tables in Certkiller -DB03. You make sure that the view cannot be affected by modifications to underlying table schemas. You need to accomplish this objective by using the minimal amount of overhead.
How can you accomplish this?
A.
You should create a CHECK constraint to validate the data and to assign the default value to each item in the table.
B.
You should create the view by specifying the WITH SCHEMABINDING option.
C.
You should create the view by specifying the WITH CHECK option.
D.
You should implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
E.
You should create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
Explanation:
When you create a view and specify the SCHEMABINDING option, you are unable to drop any tables, views or functions referenced by the view without first dropping the view.