首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
62
问题
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
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
Chinaplanstospendbillionsofdollarsinthenextfewyearstodevelopmediaandentertainmentcompaniesthatithopescanco
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
程序文件执行过程中要使用调试窗口,应该选择()。A.program菜单中的“trace”选项B.database菜单中的“trace”选项C.windows菜单中的“trace”选项D.debug菜单中的“trace”选项
随机试题
Itishightimewe______.
伦琴(R)和库伦每千克(C/kg)的换算关系是
某工业项目厂房主体结构工程的招标公告中规定,投标人必须为国有一级总承包企业,且近3年内至少获得过1项该项目所在省优质工程奖;若采用联合体形式投标,必须在投标文件中明确牵头人并提交联合投标协议,若某联合体中标,招标人将与该联合体牵头人订立合同。该项目的招标
堆石坝垫层料的摊铺多采用(),以减轻物料的分离。
基金必然的当事人是()。I.基金管理人Ⅱ.基金投资者Ⅲ.基金托管人Ⅳ.第三方服务机构
按照《关于调整证券资格会计师事务所申请条件的通知》的规定,会计师事务所申请证券资格的,会计师事务所注册会计师不少于200人。其中最近5年持有注册会计师证书且连续执业的不少于()人,且每一注册会计师的年龄均不超过()周
巴金的《爱情三部曲》不包括()。
发散思维的主要特征有:流畅性、变通性、_________。
验收测试的依据是什么?验收测试对测试环境有何要求?在实际的软件测试过程中,对缺陷的管理与分析至关重要。回答如下问题:(1)针对本测试,Bug的错误类型除了功能性错误外,还可能会包括哪些?(2)严重性级别是Bug的重要属性,请写出常见的功
有关查询设计器,正确的描述是
最新回复
(
0
)