單項(xiàng)選擇題

你打算從SQL Server 2000數(shù)據(jù)庫的客戶表和國別表中導(dǎo)入客戶數(shù)據(jù)到SQL Server 2005數(shù)據(jù)庫中。你要確保在導(dǎo)入過程中，客戶表中國家代碼列的每個值在SQL Server 2005數(shù)據(jù)庫中國別表內(nèi)都有其相應(yīng)的紀(jì)錄。你在兩個表之間定義一外鍵，這樣，參照完整性將保證若國家代碼值在客戶表中存在，而在國別表中不存在時(shí)導(dǎo)入程序失敗。你要確保國別表無記錄時(shí)導(dǎo)入過程不失敗，該怎么做？（）

A.刪除外鍵，用腳本導(dǎo)入數(shù)據(jù)，重新創(chuàng)建外鍵
B.創(chuàng)建一個CHECK約束
C.創(chuàng)建一個DML INSTEAD OF觸發(fā)器，將錯誤記錄寫入文件或表中
D.創(chuàng)建一個DML AFTER觸發(fā)器，將錯誤紀(jì)錄寫入文件或表中

你可能感興趣的試題

單項(xiàng)選擇題

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table.
What should you do？（）

A.Drop the foreign key. Import the data by using the script. Re-create the foreign key.
B.Create a CHECK constraint.
C.Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
D.Create a DML AFTER trigger that writes the failed records to a file or table.

單項(xiàng)選擇題

You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.
What should you do？（）

A.Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
B.Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
C.Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
D.Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.