2. 计算机
  3. You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory. Developers at your com

You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory. Developers at your com

admin2009-05-19  34
问题 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


You need to configure the database to support both versions of the application without affecting server performance. What should you do?
选项 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.
转载请注明原文地址:https://kaotiyun.com/show/EuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)