首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
69
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]Ontheotherhandaretwocompellingargumentsagainstplacingadutyonhumanstoprotectendangeredspecies.Thefirstis
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Youaretheadministratorofyourcompany’snetwork.Thenetworkisconfiguredasshownintheexhibit.YouwanttoinstallW
随机试题
老年人的晶态智力一般不随年龄的增长而减退。晶态智力是指
男性,60岁,晚餐后突然头痛、呕吐、很快昏迷,体格检查:左侧瞳孔扩大,对光反射消失,右侧对光反射存在。初步诊断为()
某期货公司的期末财务报表显示,流动资产为6000万元,流动负债为5500万元。根据《期货公司风险监管指标管理试行办法》,中国证监会派出机构应当对该公司采取以下监管措施()。[2010年3月真题]
2004年度的会计利润为( )万元。2004年度应纳所得税额为( )万元。
下列哪些观点是持遗传决定论认识的?()
某单位派60名运动员参加运动会开幕式,他们着装白色或黑色上衣,黑色或蓝色裤子。其中有12人穿白上衣蓝裤子,有34人穿黑裤子,29人穿黑上衣,那么穿黑上衣黑裤子的有多少人?
从组织病理学角度描述牙周炎的发展过程。
不与克服困难相联系的行动不是意志行动。()
A、 B、 C、 C(A)利用move有“搬家”和“移动”的双重意思引起混淆。(B)这个回答虽然包含了时间,看上去像是回答了间接疑问句的when,但是内容不对,是在谈论自己的访问时间。(C)没听说什么。因此不知道什么时候
JusticeisoneofthemostpopularcoursesinHarvard’shistory.NearlyonethousandstudentscrowdHarvard’shistoricSandersT
最新回复
(
0
)