首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
14
问题
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
"3M"comesfrom"MinnesotaMining&Manufacturing,"butthosethreeMsmightbetterstandforMistake=Magic=Money.Throughoutit
Thepicturedepictsafunnysceneinthehospitalvividly.Severalpeoplearewaitinginquitealongqueueoutsidetheclinicw
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
随机试题
魏晋南北朝美术发展的新特点。[吉林2019]
由于液压泵精度低,径向和轴向间隙因磨损增大,以及液压泵型号不对和液压泵吸油部分有损坏等原因,会使液压泵产生( )。
下面表述不属于设备安装进度控制目标分解的是()。
为了防止外加剂对混凝土中钢筋锈蚀产生不良影响,应控制外加剂中()的含量。
进口食品的承运者应在取得检验检疫机构的通关单后方可向海关报关。( )
关于固定资产的后续支出,下列说法不正确的是()。
根据下列资料,回答下列小题。图中a-b=()。
下列活动中,不属于教育现象的是()
材料题(四川省公务员面试真题)2012年6月,北京某高校大四学生吕江父亲被诊断身患白血病,因家住农村,父母以务农为生,家中经济困难无力承担至少40万元的医疗费用,被迫无奈,吕江在微博、淘宝等网络平台讲述了自己的故事并向大家借钱,承诺会在3至5年内
Whichofthefollowingwouldbethemostsuitabletitleforthispassage?Theauthorwouldprobablyagreethatinmodemconflic
最新回复
(
0
)