首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
39
问题
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,
Imaginativeworkssuchasnovels,plays,films,fairytales,andlegendspresentamoreaccurateandmeaningfulpictureofhuman
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Supposeyouhavefoundsomethingwrongwiththebookthatyouboughtfromanonlinestoretheotherday.Writeane-mailtothe
Faceit,moviefans:theDVDisdestinedtobedeadasadoornail.OnlyafewBlockbusterstoresarestillopen.Netflix’s(o
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
在用户管理组administrators中删除lusi用户。
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
《刑法》第232条规定:“故意杀人的,处死刑、无期徒刑或者十年以上有期徒刑。”法官对杀人案中的被告人依法判处无期徒刑,这体现了()
Notes:CPR心肺复苏campcounselor夏令营负责人WhattrainingwillalsobeofferedinthecourseinadditiontoCPRFirstAidskills?
摩托车后轮胎爆裂时,驾驶人应保持镇定,______,极力控制摩托车保持直线行驶,减速停车。
根据加拿大心血管病学会分类分级,Ⅲ级心绞痛是指
阳虚寒湿之体,痰饮聚久化热;或气血亏虚者,感受湿热之邪,可见胃肠先有宿食湿浊,积久化热,薰蒸秽浊上泛舌面;或血瘀气滞或湿热夹痰,可见
拦水缘石的施工应符合的规定有()。
承担支持农业政策性贷款任务的政策性银行是()。
我国公有制经济包括以下哪些经济形式()
Thefactoryproduceshalfamillionpairsofshoeseveryyear,80%______aresoldabroad.
Completetheformbelow.WriteONEWORDONLYforeachanswer.HOUSESERVICEINFORMATIONExampleAnswerNameBarbaraHill
最新回复
(
0
)