首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
37
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
随机试题
沉香治疗喘证,是取其何种功效()
A.脐带先露B.脐带脱垂C.脐带缠绕D.脐带长度异常E.脐带扭转使用脐血流图及彩色超声多普勒或B超检查可诊断
用于显示退变神经纤维的染色方法是
甲公司和乙公司订立购销化工原料的合同,约定8月5日交货。8月1日,甲公司听说乙公司已经濒临破产,于是决定中止履行合同。并通知乙公司,要求其提供适当担保,乙公司答复上述说法纯属谣传,拒绝提供担保,并要求甲公司如期履行合同。甲公司坚持要求乙公司提供担保,乙公司
房地产估价的技术性原则是为了使不同的估价人员对房地产估价的基本前提具有认识上的一致性,对同一估价对象在()下的估价结果具有近似性。
账页格式一般有()。
跆拳道是一门韩国格斗术,以其腾空、旋踢脚法而闻名。其在1988年和1992年间作为表演项目出现在奥运会中,在()成为奥运会的正式比赛项目。
设α1,α2,…,αs,β1,β2,…,βt线性无关,其中α1,α2,…,αs是齐次方程组Aχ=0的基础解系.证明Aβ1,Aβ2,…,Aβt线性无关.
在IDEF1X模型中,矩形框表示______。A)父实体B)子实体C)分类实体D)属性
FDAhasapprovedtheplanofusingHIVtocurecancerinhumans.ItisthelackofmoneythathashelduptheprogressInusing
最新回复
(
0
)