首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform ad hoc distribution queries against a da
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform ad hoc distribution queries against a da
admin
2009-05-19
46
问题
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.
You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
How should you configure SQL1?
选项
A、Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B、Add SQL2 as remote server.
C、Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D、Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
答案
C
解析
Explanation: We should set up SQL2 as a linked server. This would enable to issue distributed queries to it. We should also select Remote Collation option to use the collation on the remote server.
Note: SQL Server 2000 allows the creation of links to OLE DB data sources called linked servers. After a link has been created it is possible to reference rowsets from the OLE DB data sources as tables in Transact- SQL statements and pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements.
Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The linked server options defined by using the sp_serveroption stored procedure control how SQL Server uses collations from linked servers. When the UseRemoteCollation option is set to TRUE, it specifies that the collation of remote columns is used for SQL Server data sources, and the collation specified in CollationName is used for data sources other than SQL Server.
When FALSE, distributed queries always use the default collation of the local server instance, and CollationName and the collation of remote columns are ignored. If the UseRemoteCollation option is set to TRUE, we can specify the name of the collation used by the remote data source in the CollationName option. The collation must, however, be supported by SQL Server. This option should be used when accessing an OLE DB data source other than SQL Server, but whose collation matches one of the SQL Server collations
Incorrect Answers:
A: The COLLATE clause of the ALTER DATABASE statement can be used to change the collation used by the database. However, this solution is inappropriate as the SQL2 server contains several databases, each of which uses a different collation. We would thus not be able to specify all the collations.
B: Remote servers are set up in pairs with both servers configured to recognize each other as remote servers. The configuration options for both servers should be set so that each instance of SQL Server allows remote users to execute procedure calls. However, support for remote servers is provided for backward compatibility only. Applications that must execute procedures against remote instances of SQL Server 2000 should use linked servers instead.
D: In this scenario we cannot specify the collation name as SQL2 contains several databases, each of which use a different collation.
转载请注明原文地址:https://kaotiyun.com/show/7whZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
程序文件执行过程中要使用调试窗口,应该选择()。A.program菜单中的“trace”选项B.database菜单中的“trace”选项C.windows菜单中的“trace”选项D.debug菜单中的“trace”选项
创建层的命令是______。A.Open/LayerB.Edit/LayerC.Insert/LayerD.Save/Layer
随机试题
下列各局麻药的一次最大剂量(mg)为:普鲁卡因______、利多卡因______。
最易早期出现颅内压增高的病变部位是
A.白芍、白术B.当归、白芍C.柴胡、白术D.羌活、防风E.防风、甘草消风散与川芎茶调散的组成均有()
老年患者对低血糖的耐受能力差,治疗糖尿病时应首选不易导致低血糖反应的降糖药。下列降糖药中,单独使用不会出现低血糖的有
根据《危险化学品安全管理条例》,该企业应当对其生产、储存装置每()进行一次安全评价。该企业新招聘从业人员甲应该接受的岗前安全培训时间不得少于()。
如何进行数学基本知识与基本技能的教学?
网络文学经过20年的快速发展,已收获丰富的作品、巨大的经济效益和来自各方的关注。但在爆发式增长的同时,有关其价值及合理性的质疑也_________________。综观网络文学整体,虽然不乏_________________的佳作,但与庞大基数相比,精
某综合楼工程发包后,发包人未按约定给定预付,承包人在约定预付时间7天后向发包人发出要求预付的通知,发包人收到通知后仍未按要求预付,于是在发出通知后7天,承包人决定停止施工,承担由此造成工期损失的是()。
下列不属于打开或关闭数据表对象的命令是______。
WhichofthefollowingstatementsaboutSouthKorea’soldaddresssystemisCORRECT?
最新回复
(
0
)