题目内容

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?()

A. The clustered index of the Orders table should be dropped.
B. The clustered index of the Orders table offline should be rebuilt once a month.
C. The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
D. The clustered index of the Orders table should be reorganized by reducing the fill factor.

查看答案
更多问题

尚未领到法定代码或不属于法定代码赋码范围的单位,一律由各级统计部门从临时码段中赋予代码。()

A. 正确
B. 错误

风险管理的效果就是获得的安全保障与成本的比值,比值越大,效益越好,当效益比值()时,该风险管理技术可取。

A. 小于1
B. 等于1
C. 大于1
D. 大于0

男性,25岁。下船时会阴部骑跨在船沿上,立即出现尿道口滴血,之后不能排尿,发生尿潴留。体检发现会阴部、阴茎和阴囊明显肿胀。若患者术后3周发生排尿困难,尿线变细,首先采取()

A. 尿道扩张术
B. 尿道会师术
C. 经会阴部尿道切除吻合
D. 尿道镜直视下狭窄冷刀切开术
E. 尿道镜直视下狭窄电切术

《()》的主要艺术成就,主要体现在能够综合运用曲文、念白、科介,充分刻画人物的性格,表现戏剧的冲突。

答案查题题库