首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
66
问题
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
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writealettertooneofyourfriends,apologizingtohim/herforyourmakinghis/hercomputerstopworking.Youshouldwrite
Whileyouwereawayfromhomeonbusinessafewdaysago,yourfatherfellintoacoma.YourneighborMarystoppedacarandbro
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
随机试题
Onbehalfofboardofdirectors,Iappreciateyouforprovidingthe______________information.
中国共产党的思想路线
Studiesconfirmedthatthiseyediseasewas______intropicalcountries.
主动脉弓从右到左发出的分支依次是
A.易复性疝B.难复性疝C.嵌顿性疝D.绞窄性疝E.滑动性疝站立时肿块变大,平卧后肿块变小
失眠:睡眠:嗜睡
设计任务:请阅读下面学生信息和语言素材,设计20分钟的读写教学方案。教案没有固定格式,但须包含下列要点:.teachingobjectives.teachingcontents.keyanddifficultp
班集体在育人方面突出价值的实现是通过()。
情感具有稳定性、________、持久性的认识活动特征,它往往与人的思想观念紧密相连。
Inmany______alackofdirectionpromptedtheRepublicanGuardtocallitaday.
最新回复
(
0
)