可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are creating a&ens


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?()

  • ACreate CHECK constraints on the tables.
  • BCreate a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
  • CCreate the view, specifying the WITH SCHEMABINDING option.
  • DCreate the view, specifying the WITH CHECK option.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、You are creating a&ens

You are creating a Windows Forms application for inventory management by using the .NET Framewo...

2、You are creating a&ens

You are creating a locally managed tablespace to meet the following requirements: All the exte...

3、You are creating a&ens

You are creating a Windows Forms application by using the .NET Framework 3.5. You have imp...

4、You are creating a&ens

You are creating a new security policy for an application domain. You write the following ...

5、You are creating a&ens

You are creating a SQL Server 2005 database for a mortgage company. The database will supp...

6、You are creating a&ens

You are creating a Windows Forms application by using the .NET Framework 3.5.You need to p...