首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
61
问题
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]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
Supposeyouhavefoundsomethingwrongwiththebookthatyouboughtfromanonlinestoretheotherday.Writeane-mailtothe
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
补气养血方药中加入适量肉桂,其主要目的是
抢救链霉素过敏反应时,为了减轻链霉素的毒性可以静脉注射
某建筑安装公司为安装下水管道,在马路一侧挖沟,并于夜间在沟边设置了警示灯。一日,因电线老化导致短路,警示灯熄灭,恰有甲夜间骑自行车逆行途经此处,摔入沟内并受伤。在甲向建筑安装公司索赔过程中,该公司被市政总公司兼并。甲遂向市政总公司索赔,但遭到拒绝。请综合上
刘强自1990年以来一直受雇于A市B县的C公司从事汽车驾驶员工作,月工资1500元,双方从未签订书面劳动合同。2010年1月10日,刘强要求与C公司签订无固定期限劳动合同,不料得到的却是C公司的解雇通知书,要求刘强在月底前办理离职手续,工资结算至1月底。此
下列行为中,生产经营单位在“劳动防护用品”方面的违法行为有()。
预应力筋锚固后的外露长度应不宜小于()mm。
社区参与是指社区居民共同期望社区进步与发展,愿意投入思想、行为,投入个人有形或无形的资源,增强个人对社区的认同,继而形成对社区的归属感。最高层次的社区参与形式是_______。
不能说明第一段中提到的“步行须遵制合礼”的一项是:综观全文的内容,以下推断合乎原文意思的一项是:
ThenumberofwomendirectorsappointedtocorporateboardsintheUnitedStateshasincreaseddramatically,buttheratiooffe
A.becauseB.experienceC.pushedintoD.objectionsE.protestedF.complaintsG.oppose
最新回复
(
0
)