单选题 You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory.Developers at your company upgrade an inventory tracking application. Users report that when they insert new information in the Locations table, the upgrade application returns the following error message ‘string or binary data would be truncated. The statement has been terminated.’When you use SQL profiler to trace the activity of the application, you receive the results as shown in the trace exhibit.

You examine the design of the locations table as shown in the table design exhibit.Table Schema

A、 Alter the data type of the description field to varchar(50).
B、 Alter the data type of the Special field to varchar(50).
C、 Alter the data type of the CubicFeet field to float.
D、 In the locations table, create an INSTEAD OF trigger that truncates the description field at 10 characters when the record is updated.
E、 In the locations table, create an INSTEAD OF trigger that truncates the Special field at 10 characters when the record is updated.

【正确答案】 A

【答案解析】解析：Explanation: By examining the first exhibit we see that the Visual Basic application tries to update the Description field. Apparently there is a problem with this field. The description field must be adapted. We increase the field to accommodate for both versions of the application. Incorrect Answers: B: The description field, not the special field, is the problem. C: The error message doesn’t indicate a problem in float column, more likely a character column. D: This would lose data. E: The description field, not the special field, is the problem.