搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单选题】

You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?()

A、Create CHECK constraints on the tables. 

B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 

C、Create the view, specifying the WITH SCHEMABINDING option. 

D、Create the view, specifying the WITH CHECK option. 

更多“You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?()”相关的问题
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服