首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
61
问题
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
微软认证
相关试题推荐
Chinaplanstospendbillionsofdollarsinthenextfewyearstodevelopmediaandentertainmentcompaniesthatithopescanco
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
CompanyIsMoreImportantthanGiftsWriteanessayof160-200wordsbasedonthedrawing.Inyouressay,youshould1)
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Writeane-mailofabout100wordstoaforeignteacherinyourcollege,invitinghim/hertobeajudgefortheupcomingEnglish
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
Faceit,moviefans:theDVDisdestinedtobedeadasadoornail.OnlyafewBlockbusterstoresarestillopen.Netflix’s(o
Exhibit:BULKINSERTEzonexam.dbo.employeesFROM‘tk\africe\fubar512.txt’WITHDATAFILETYPE=‘char’,FIELD/TERMINATOR=‘\t’,R
Youaretheadministratorofyourcompany’snetwork.Thenetworkisconfiguredasshownintheexhibit.YouwanttoinstallWi
随机试题
在教学当中详细阱解语言规则,使学习者注意某一形式的教学称作显性教学。()
化脓性关节炎患者放置的引流管,其拔管指征为
在证券市场卜,投机者的投机活动是具有双重作用的活动,它有积极意义,也有消极意义,其中积极意义有()。
下列各项中,关税纳税义务人可以自缴纳关税之日起1年内申请退还关税的情形有()。
孙某与甲公司签汀了为期3年的劳动合同,月工资1200元(当地最低月工资标准为800元)。期满终止合同时,甲公司未向孙某提出以不低于原工资标准续汀劳动合同的意向。甲公司应向孙某支付的经济补偿金额为()元。(2011年)
领导效能与领导效率是两个不同的概念。
传统上,人们认为由经理们一步一步理性地分析做出的决策要优于凭直觉做出的决策。然而,最近的一项研究发现,高级经理使用直觉比大多数中级或低级经理多得多。这确证了一项替代观点,即直觉实际上比仔细的、有条不紊的理性更有效。以上结论基于以下哪一条假设?
以下选项中函数形参不是指针的是
带链栈空的条件是
Fearcanbeaneffectivewaytochangebehavior.Onestudycomparedtheeffectsofhigh-fearandlow-fearappealsonchangesin
最新回复
(
0
)