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

微软认证考试

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

TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE() function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform?()

  • A、Remove all deterministic function calls from within the view.
  • B、Remove all nondeterministic function calls from within the view.
  • C、Schema-bind all functions that are called from within the view.
  • D、Create the view and specify the WITH CHECK OPTION clause.
正确答案:B,C
答案解析:
进入题库查看解析

微信扫一扫手机做题