单选题
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 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task？（）
发布日期：2020-04-10
A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.
A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.
标签： professional level sql server 2005
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
幼儿在户外活动中流鼻血了，你作为在场的老师，应该怎么做？
公司发行的刊物在内容编排上须真实反映企业发展状况，严禁随意刊登领导内部或尚未公开的讲话稿、公司核心数据资料、公司机密、（）、会议纪要及公司尚未确定的事宜。
在发放了股票股利后，股东所持股份增加，因而，每位股东所持股票的市场价值总额也增加。
李先生在A地旅行社购买了B地5日游的旅游服务产品，旅行期间合法权益受损，他应向谁提出赔偿要求？（ ）
国务院信息产业主管部门必须在受理了符合规定要求的基础电信业务申请后，______个工作日内审查完毕；而对于经营增值电信业务的申请，管理部门应该在自收到申请之日起______日内审查完毕，做出批准或者不予批准的决定。（ ）
今年8月23日，信息产业部与新华通讯社联合在京举办了2000信息产业发展国际论坛。信息产业部副部长曲维枝出席会议并在论坛上作了题为（）的主题发言。
男性患者，75岁，既往高血压20余年，冠心病15年，糖尿病10年，近一年血压、血糖控制良好，无心绞痛发作。3天前行胃大部切除术，术后应用静脉补液，今日输液中突发呼吸困难，濒死感。查体：急性病容，端坐位，BP170/110mmHg，HR130/分。口唇发绀，双肺可闻及较多干湿啰音，心音强弱不等，心律不齐。双下肢轻度水肿。查心电图为快速房颤。指尖血糖12mmol／L，CK-MB16U/L，肌钙蛋白正常，D二聚体正常。用于控制房颤心室率的药物有（）。
行车延误
早期声带小结治疗可选择（）。
工业管道正常运行时的检查主要包括哪些内容？
暂无相关推荐~
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...