You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?
A.
Create an INSTEAD OF trigger on the view.
B.
Define the view by using the SCHEMABINDING option.
C.
Define the view by using the CHECK option.
D.
Materialize the view.
Explanation:
http://msdn.microsoft.com/en-us/library/ms180800.aspx
http://msdn.microsoft.com/en-us/library/ms187956.aspx
A
0
0
I agree, A
0
0
I agree too. It’s “A”.
See:
– https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0864.htm
– http://stackoverflow.com/questions/4197674/insert-data-into-a-view-sql-server
0
0
agree. Ans is A – create an INSTEAD OF trigger on view
0
0
C is the correct ANS
0
0
A
0
0