单项选择题
A.A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
B.A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
C.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.
D.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.
单项选择题 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. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）
单项选择题 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 user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）
单项选择题 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 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）