正确答案: A

Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

题目：You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?

解析：解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

查看原题查看所有试题

学习资料的答案和解析：

[单选题]You want to install Windows 2000 Professional on 45 new computers on your company's network. You first install Windows 2000 Professional on one of the new computers.You log on to the computer by using the local Administrator account. You install Microsoft Office 97, a virus scanner, and other company-standard applications. You then create a RIS image of the computer you configured.

Copy the local Administrator account profile to the Default Users profile

解析：解析：Explanation: By copying the local Administrator account profile to the default users profile, all users will get access to the shortcuts, which were made when the local administrator installed the applications.

[单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?

Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.

解析：解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

[单选题]You are the network administrator for Ezonexam.The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.

Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.

解析：解析：Explanation:Therearefourwaystoperform.anattendedinstallation:1.BoottoaCD-ROM,therebyinvokingthesetuproutine.2.BoottoacurrentoperatingsystemwithCD-ROMsupportandmanuallyinvokethesetuproutine.3.BoottoasetoffoursetupdisksandthenprovidetheCD-ROMwhenprompted.4.Boottoanetwork-awareoperatingsystemandinvokesetupoverthenetwork.IfyouhaveacomputerwhoseBIOSsupportsbootingfromaCD-ROM,youcansetupWindows2000Serverwithoutinstallinganoperatingsystemonyourharddriveandwithoutrequiringnetworksupport.Todoso,configureyourcomputertoboottotheCD-ROMintheBIOS.IntheabovescenariotheserverfailedandforyoutorecovertheserverasquicklyaspossibleandrecoveringasmuchdataaspossibleyouneedtousetheWindows2000ServerCDandselecttheRepairoptioninSetup.Incorrectanswers:B:Thisoptionwillnotbethebesttofollowiftheserveristoberecoveredwithintheshortestpossibletime.Youwillalsolosesomedatasincere-creatingthesharedfoldersonthefirstharddiskwouldalreadyhavedatamissingsincePartitionCiscorrupted.C:EmergencyRepairDiskenablesyoutorecoverfromRegistrysettingsthatrenderyoursysteminoperable.ThismightbemisconfigurationthatcouldnotbecaughtwiththeLastKnownGoodConfiguration,oritmightbedeleteduseraccountsorotherRegistrychanges.Thisisnotaregistryproblem.TheEmergencyRepairDiskcanbeusedtofacilitatesomesystemrepairsonyourWindows2000server.Essentially,thediskcanbeusedtorepairstartupproblems,likewhenessentialstartupfilesarenotpresentandyourServerrefusestoboot.However,thisproblemneedstobeaddressesasquicklyaspossibleandmakinguseoftheRepairoptioninSetupfromtheWindows2000ServerCDwouldbethequickermethod.D:TheRecoveryconsoleisapowerfultext-basedbootalternativeforWindows2000Server.Ifyoursystembecomessocorruptthatitwillnotbootandnootherrepairprocesswillhelp,youcanboottotheRecoveryconsoleandcopyfilestoorfromyourserver.Inaddition,youcanstopandstartservices,ifaservicethatyouhaveinstalledcausesproblemswithbooting.Thisoptiondoesnotrepresentthequickestwaytoaddresstheproblemathand.