当前位置:MCTS(70-432)题库

问题:

[单选]

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. 
So what action should you perform to achieve this goal?()  

A . You should drop the XML index on the table. Modify the primary key. Recreate the XML index 
B . You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 
C . You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 
D . You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

一个合理的系统划分应该是各模块之间的联系()。 弱。 强。 独立。 简单。 Your network contains a Network Policy Server (NPS) named NPS1.You deploy a new NPS named NPS2.You need to ensure that NPS2 sends all authentication requests to NPS1.What should you modify on NPS2?() health policies。 network policies。 RADIUS clients。 remote RADIUS server grou。 在行为科学理论中侧重研究人的需要、动机和激励问题的理论是() 人性管理理论。 群体行为理论。 人类需要理论。 领导行为理论。 系统设计阶段的最后一项工作是编写()。 可行性分析报告。 系统设计说明书。 系统功能结构图。 系统说明书。 Your company has an Active Directory forest. The forest includes organizational units corresponding  to the following four locations:  (London  .Chicago  .New York  .Madrid   Each location has a child organizational unit named Sales. The Sales organizational unit contains all the  users and computers from the sales department.   The offices in London, Chicago, and New York are connected by T1 connections. The office in Madrid is  connected by a 256-Kbps ISDN connection.   You need to install an application on all the computers in the sales department.   Which two actions should you perform() Disable the slow link detection setting in the Group Policy Object (GPO).。 Configure the slow link detection threshold setting to 1,544 Kbps (T1) in the Group Policy Object  (GPO).。 Create a Group Policy Object (GPO) named OfficeInstall that assigns the application to users. Link the  GPO to each Sales organizational unit.。 Create a Group Policy Object (GPO) named OfficeInstall that assigns the application to the computers.  Link the GPO to each Sales organizational unit.。

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. 
So what action should you perform to achieve this goal?()  

参考答案:

  参考解析

本题暂无解析

在线 客服