首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000
You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000
admin
2009-05-19
15
问题
You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.
During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
What should you do?
选项
A、Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B、Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C、Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D、Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
答案
C
解析
Explanation: The collation of a database can be specified in the COLLATE clause of the ALTER DATABASE statement. This will change the default collation of the database that was specified when the database was created, or to alter the collation for a database where the collation was not specified when the database was created and thus the default collation of the server was used.
Incorrect Answers:
A: The collation of a database can be altered using the COLLATE clause of the ALTER DATABASE statement. It is therefore not necessary to reinstall the instance of SQL Server 2000 or to rerun the setup program. Furthermore, rerunning the SQL Server 2000 setup program would disrupt the performance of the SQL Server computer.
B: The rebuildm utility alters the master database and can be used to change the collation settings for an instance of SQL Server 2000. However, it is only the Financial database that needs to be altered as it is financial application is the only application that uses the SQL_Latin1_General_CP437_BIN collation.
D: The COLLATE clause can be specified at different levels. It can be specified for the database, a table, a column or an expression. In this scenario the collation can be altered at the database level as this will reduce administrative effort when new tables are added to the database.
转载请注明原文地址:https://kaotiyun.com/show/UuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
子宫增大的超声诊断标准是
弦脉所主的病证是
基于温度的考虑,马歇尔试件的成型过程须在一定时间内完成。()
可以把转矩和旋转运动灵活地传到任何位置的轴是(),常用于振捣设备中。
老师的泪初二时,我竞莫名其妙地喜欢上了我的语文老师。老师姓杨,爱穿白色的裙子,她在讲台上讲蓝蓝的天、青青的草,像一片白云飘来飘去,轻盈极了。她有一双大而明亮的眼睛,笑时,便成了甜甜的弯月……“齐玉。”杨老师叫我。
非全面调查包括()。
舌前2/3的边缘及外侧淋巴管一部分引流至下颌下淋巴结,另一部分引流至()。
甲破解了张某的股票账户密码,偷偷登录其账户买卖股票“练手”,案发时造成张某股票账户资金实亏15万元。甲的行为应认定为()。(2018一专一14、2018一法专一4)
ThescientificnameistheHoloceneAge,butclimatologistsliketocallourcurrentclimaticphasetheLongSummer.Thehistory
A、Themanwantstobeabusinessmanager.B、Thewomanisworkinginakindergarten.C、Thewomanisnothappywiththeman’sdeci
最新回复
(
0
)