微软MCTS考试题库之SQL.docx
- 文档编号:34238
- 上传时间:2023-04-28
- 格式:DOCX
- 页数:51
- 大小:1.26MB
微软MCTS考试题库之SQL.docx
《微软MCTS考试题库之SQL.docx》由会员分享,可在线阅读,更多相关《微软MCTS考试题库之SQL.docx(51页珍藏版)》请在冰点文库上搜索。
微软MCTS考试题库之SQL
Question:
1
YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSOL1andtheotherisSQL2.Youhavepermissions(权限)tocreateastoredprocedureonSQL1tosupportyourapplication.However,onSQL2youonlyhavepermissionstoselectdata.YouwritethestoredprocedureonSOL1.ThestoredprocedureaccessesSQL2byusingtheOPENQUERYTransact-SQLstatement.However,thequeryfailswhenexecuted.Youneedtotroubleshoot(纠正)thecauseoftheerror.Whatshouldyoudo?
你的应用程序必须访问两台装有SQLServer2005的计算机上的数据。
其中的一台被称为SQL1,另一台叫SQL2。
你在SQL1上拥有创建和执行存储过程的权限,但是在SQL2上你仅仅有选择数据的权限。
你在SQL1上写好了某个存储过程。
该存储过程使用OPENQUERYTransact-SQL语句访问SQL2。
当该存储过程执行时失败了。
你需要纠正该问题,你要怎么办?
A、Jointhetwoserversbyusingthefour-partsyntaxofserver.database.schema.table.
使用完全限定名如:
服务器名.数据库名.架构.表,以连接两个服务器。
B、ReferenceSQL2byusinganalias.
通过使用别名来引用SQL2
C、AddSQL2asaremoteservertoSQL1.
将SQL2做为一个远程服务器添加到SQL1
D、AddSQL2asalinkedservertoSQL1.
将SQL2做为一个链接服务器添加到SQL1
Question:
2
YouarepreparingforanewinstallationofSQLServer2005.Youneedtoselecttheprotocolsthatclientcomputersmightusetoconnecttotheserver.Whichtwoprotocolscanyouusetoachieve(完成)thisgoal?
(Eachcorrectanswerpresentsacompletesolution.Choosetwo.)
你计划安装一个新的SQLServer2005。
你需要选择客户端连接到服务器所可能要使用的协议。
为完成这一任务,你将会选择以下哪两个协议?
(每个正确答案提供了完整的解决方案,选择两项)
A、NamedPipes
命名管道
B、TCP/IP
TCP/IP、
C.、SharedMemory
共享内存
D、VirtualInterfaceAdapter(VIA)
虚拟接口适配器
E、Multiprotocol
多协议
Question:
3
YouconfigureanewSQLServer2005computertouseTCP/IPwithalldefaultsettings.Yourcorporatepolicyrequiresthateachserveruseafirewall.YoufindthatyoucanconnecttotheSQLServerinstancefromthelocalcomputer.However,clientcomputerscannotconnecttotheSQLServerinstance.Youneedtoidentifythemostlikelycauseoftheconnectionissues.Whatshouldyoudofirst?
你配置了一个全新安装的SQLServer2005计算机,使用所有的默认设置及TCP/IP协议。
按公司的要求,每个服务器使用一个防火墙。
你发现你可以在本地计算机上连接到SQL服务器实例,客户端计算机无法连接到SQL实例。
你需要找出最可能导致该连接问题的原因。
你首先会做什么?
A、Ensurethatport1433isopeninyourfirewall.
确认在你的防火墙上开放了1433端口
B、Ensurethatport443isopeninyourfirewall.
确认在你的防火墙上开放了433端口
C、EnsurethatclientcomputersconnectbyusingSharedMemoryprotocol.
确认客户计算机使用共享内存协议进行连接
D、Ensurethattheserverisnotpaused
确认服务器没有被暂停
Question:
4
Chasmultipleserversinadistributedenvironment.YouworkwithtwoSQLServer2005computersnamedSQL1andSQL2.EachserverusesSQLServerAuthenticationandtheyusedifferentlogins.YouneedtowriteadistributedquerythatjoinsthedataonSQL1withthedataonSQL2.Whatshouldyoudo?
贵公司在分布式环境中拥有多态服务器。
你使用两台SQLServer2005计算机,名为SQL1和SQL2。
每个服务器使用SQLServer认证并且有不同的登录。
你需要编写一个分布式查询以连接SQL1和SQL2上的数据。
你该怎么办?
A.EnsurethatbothSQL1andSQL2usethesameloginnameasthesecuritycontextforeachserver.
确认SQL1和SQL2都使用相同的登录名
B.ConfigureSQL2asaremoteserver.WritethequeryonSQL1.
配置SQL2做为远程服务器,在SQL1上编写查询
C.ConfigureSQL2asalinkedservertoimpersonatetheremotelogin.
配置SQL2作为连接服务器并实现模拟远程登陆
D.ConfigureSQL2asadistributedserver.Usepass-throughauthentication.
配置SQL2做为分布式服务器。
使用信任认证
Question:
5
CusesSQLServer2005.Usersreportthatreportexecutionisslow.Youinvestigateanddiscoverthatsomequeriesdonotuseoptimal(最佳)executionplans.Youalsonoticethatsomeoptimizerstatistics(统计)aremissingandothersareoutofdate.Youneedtocorrecttheproblemsothatreportsexecutemorequickly.WhichtwoTransact-SQLstatementsshouldyouuse?
(EachcorrectanswerpresentspartoftheSolution.Choosetwo.)
贵公司试用SQL2005。
用户报告报表的执行速度很慢。
你检查并发现某些查询没有使用最佳执行计划。
你还注意到有些优化统计信息丢失,另一些则已经过期。
你需要纠正这些问题使得报表执行更迅速。
你将会使用哪两个SQL命令?
A、DBCCCHECKTABLE
B、ALTERINDEXREORGANIZE
C、UPDATESTATISTICS
D、CREATESTATISTICS
E、DBCCSHOWSTATISTICS
F、DBCCUPDATEUSAGE
Question:
6
YouareresponsibleforimplementingmaintenancejobsonaSQLServer2005databaseserver.CertainjobsruneverySundayandotherjobsrunatthebeginningofeverymonth.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrativeeffort.Whatshouldyoudo?
你负责一个SQL2005的维护工作。
有一些任务要在每个星期日做,另一些任务在每个月的月初做。
你需要规划这些任务并采用最少的管理步骤。
你将如何?
A、CreateajobschedulethatrunseverySunday.Assignweeklytaskstothisschedule.Createasecondschedulethatrunsonthefirstdayofeverymonth.Assignmonthlytaskstothisschedule.
创建一个每周日执行的计划,指派每周的任务到该计划。
创建一个在每个月的第一天执行的计划,指派每月的任务到该计划
B、Createajobforeachtaskthatrunsonceaday.UseaTransact-SQLstatementtocheckthedateanddayoftheweek.IfthedayiseitheraSundayorthefirstdayofthemonth,executethecode.
C、Createajobschedulethatrunsonceaday.Assignjobstothisjobschedule.IfthedayiseitheraSundayorthefirstdayofthemonth,executethejobs.
D、CreateajobforeachtaskthatrunsonceaweekonSunday.Addasecondjobschedulethatrunsthejobonthefirstofthemonth.
Question:
7
YoudiscoverthatthemsdbdatabaseonaSQLServer2005computeriscorrupt(损坏)andmustberestored.Databasesarebackedupdaily.Thedatabasebackupfilesarewrittentoanetworkshare,butthefilenamesdonotclearlyindicatewhichdatabasesareineachfile.Youneedtolocatethecorrectbackupfileasquicklyaspossible.ThefirstfileinthelistisnamedDB_Backup.bak.WhichTransact-SQLstatementshouldyouuse?
A、RESTORELABELONLYFROMDISK=N\\Serverl\Backup\DB_Backup.bak
B、RESTOREHEADERONLYFROMDISK=N\\Serveri\Backup\DB_Backup.bak
C、RESTOREVERIFYONLYFROMDISK=N\\Serveri\Backup\DB_Backup.bak
D、RESTOREDATABASEMSDBFROMDISK=N\\Serveri\Backup\DB_Backup.bak
Question:
8
AsupportengineerreportsthatinsertingnewsalestransactionsinaSQLServer2005databaseresultsinanerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.
Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?
A、Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.
B、Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.
C、Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.
D、Restorethedatabasetothepointofthelastfullbackup.
Question:
9
Apowerfailureoccursonthestorageareanetwork(SAN)whereyourSQLServer2005databaseserverislocated.Youneedtochecktheallocationaswellasthestructuralandlogicalintegrityofalldatabases,includingtheirsystemcatalogs.Whatshouldyoudo?
A.ExecuteDBCCCHECKFILEGROUPforeachfilegroup.
B.ExecuteDBCCCHECKCATALOG.
C.ExecuteDBCCCHECKDB.
D.ExecuteDBCCCHECKTABLEforeachtable.
Question:
10
YouareresponsibleforimportingdataintoSQLServer2005databases.Yourdepartmentisstartingtoreceivetextfilesthatcontainsalestransactionsfromstoresacrossthecountry.Columnsinthedataareseparatedbysemicolons.Youneedtoimportthefilesintothesalesdatabase.Whatshouldyoudo?
A.Createacustomformatfile,specifyingasemicolonastherowterminator.
B.Usethebcpcommand,specifyingasemicolonasthefieldterminator.
C.Usethebcpcommandwiththedefaultarguments.
D.UsetheBULKINSERTstatementwiththedefaultarguments.
Question:
11
YouarecreatingaWeb-basedapplicationtomanagedataaggregation(聚合)forreports.TheapplicationconnectstoaSQLServer2005databasenamedDataManager.OnepageintheapplicationhascontrolsthatexecutestoredproceduresinadatabasenamedReportingDatabase.ThereisanexistingServiceBrokerconnectionbetweentheDataManagerdatabaseandReportingDatabase.Youwanttoaddtwonewmessagetypestotheexistingservice.Ineachdatabase,youcreatemessagetypesnamedProcessReportandSendResult.Youneedtoaddthetwonewmessagetypestotheexistingservice.Whatshouldyoudofirst?
A.CreateaqueueoneachdatabasewiththeACTIVATIONargumentsettoDataManager.dbo.ProcessReport
B.Createaconversationbetweenthedatabasesbyusingthefollowingstatement.BEGINDIALOGFROMSERVICE'ProcessReport'TOSERVICE'SendResult'
C.Createacontractbetweentheservicesbyusingthefollowingstatement.CREATECONTRACTProcessData(ProcessReportSENTBYINITIATOR,SendResultSENTBYTARGET)
D.Createservicesforeachdatabasebyusingthefollowingstatement.CREATESERVICEDataManagerONQUEUEProcessReport
Question:
12
Youworkattheregionalsalesoffice.YouareresponsibleforimportingandexportingdatainSQLServer2005databases.Themainofficeasksyoutosendthematextfilethatcontainsupdatedcontactinformationforthecustomersinyourregion.ThedatabaseadministratorinthemainofficeasksthatthedatabesortedbytheStateProvince,Surname,andFirstNamecolumns.Youneedtosatisfy(满足)theserequirementsbyusingtheleastamountofeffort.Whatshouldyoudo?
A.SpecifyStateProvince,Surname,andFirstNameintheORDERhintinthebcpoutcommand.
B.Createaformatfilefortheexportoperation.
C.SpecifyStateProvince,Surname,andFirstNameintheORDERBYclause(子句)inthebcpqueryoutcommand.
D.CopythedataintoanewtablethathasaclusteredindexonStateProvince,Surname,andFirstName.Exportthedata.
Question:
13
ChastwoSQLServer2005computersnamedSQL1andSQL2.Bothserverstakepartinreplication.SQL1isboththePublisheranditsownDistributorofapublicationnamedPub1.Pub1istheonlypublicationonSQL1,andSQL2ist
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 微软 MCTS 考试 题库 SQL