题目内容

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query, and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table, and 50,000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal?()

A primary XML index should be created on the XML column.
B. Statistics should be created on the nvarchar columns.
C. A view should be created, and only the four columns that the query utilizes are contained by a view.
D. A composite index should be created on the three nvarchar columns, and INCLUDE should be specified for the XML column.

查看答案
更多问题

中华人民共和国公民对于任何国家机关和国家工作人员的违法失职行为,有向有关国家机关提出()、的权利,但是不得捏造或者歪曲事实进行诬告陷害。

A. 抗议
B. 申诉
C. 控告
D. 检举

呆账核销必须遵循严格认定条件,提供确凿证据,严肃追究责任,逐户、逐级上报、审核和审批,对外保密,账销案存的原则。对于金融企业申报核销呆账,必须提供的材料,以下说法不正确的是()。

A. 借款人或者被投资企业资料,包括呆账核销申报表(金融企业制作填报)及审核审批资料,债权、股权发生明细材料,借款人(持卡人)、担保人和担保方式、被投资企业的基本情况和现状,财产清算情况等
B. 经办行(公司)的调查报告,包括呆账形成的原因,抵押物(质押物)处置情况,核销的理由,债权和股权经办人、部门负责入和单位负责人情况
C. 对责任人进行处理的有关文件
D. 破产清算证明未完成的,可不提供清算证明

比例税率的表现形式是()。

A. 行业比例税率
B. 超额累进税率
C. 全率累进税率
D. 地区差别税额

下面()不是牙周细菌的致病机制。

A. 细菌侵袭
B. 体内繁殖
C. 破坏细胞
D. 损害宿主的牙周组织

答案查题题库