题目内容

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys 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.

查看答案
更多问题

采取气体试样时,应该注意哪些问题?

人体细胞直接生活的环境称为()、即()。

行车上滑轮组可分为()和()两种,其倍率是指()。

闸管反并联可逆调速电路中采用配合控制可以消除()。

A. 直流平均环流
B. 静态环流
C. 瞬时脉动环流
D. 动态环流

答案查题题库