多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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. 
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题