单选题
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？（）
发布日期：2021-03-17
You should drop the XML index on the table. Modify the primary key. Recreate the XML index
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.
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.
You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
以下哪项不是风险审计的目标？（）
补元散功效与作用
在营运区域内道路条件复杂或拥有较多车型时应采用的客车运行方式是（）。
新生儿生后2天，生后20个小时出现黄疸。查体：反应好，皮肤中度黄染，肝脾轻度肿大。血清胆红素为256μmol／L，血型B型，Rh阳性，直接抗人球蛋白阴性，抗体释放试验IgG抗B抗体阳性。需换血治疗最好的血源选择是（）
对未经治疗的患者，以下检查项目，哪项结果正常时最有助于排除心力衰竭（）
男性同性恋者是艾滋病感染的高危人群。
依据能力与消费行为的表现划分，成熟型消费者表现为（）。
木马程序是一种基于（）功能达到控制目标计算机的目的的一种病毒，
急性淋病的治疗，首选药物是（）。
凸透镜的焦距是20厘米，在距透镜60厘米处放一发光物体． （1）求像的位置并说明像的性质； （2）把物体放在像的位置上，试求像的位置和性质．
暂无相关推荐~