You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a view that has the following features:

It contains a WHERE clause that filters specific records.

It allows data updates.

You need to prevent data modifications that do not conform to the

WHERE clause. You want to achieve this goal by using minimum effort. What should you do?

Question

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a view that has the following features:

It contains a WHERE clause that filters specific records.
It allows data updates.
You need to prevent data modifications that do not conform to the

WHERE clause. You want to achieve this goal by using minimum effort. What should you do?

Accepted Answer

C. Alter the view by adding the WITH CHECK OPTION clause.

Answer

A. Create an INSTEAD OF trigger on the view.

Answer

B. Create a unique clustered index on the view.

Answer

D. Alter the view by adding the WITH SCHEMABINDING clause.

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a view that has the following features: - It contains a WHERE clause that filters…

Question

Options

How the community answered

Community Discussion