正确答案: B

Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.

题目：You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.You want to prevent any loss of data during the import operations. What should you do?

解析：解析：Explanation: The ALTER COLUMN clause of the ALTER TABLE statement can be used to change the definition of a column and can be used to alter the precision and scale values of the data types. The destination precision should be changed so no data would be lost. The transformation to a data type with higher precision is automatic and would not require any coding.

查看原题 点击获取本科目所有试题

举一反三的答案和解析：

[单选题]You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?

Configure an ADM template and add the template to the GPO.

解析：解析：Explanation: It is recommended that we should use the supplied Administrative Templates where possible. Administrative Templates propagate registry settings to a large number of computers without requiring us to have detailed knowledge of the registry. However, the administrator can create custom .adm files if the supplied templates are inadequate. In Windows 2000, we use Group Policy to set registry-based policies. In Windows NT 4.0, we used the System Policy Editor (Poledit.exe) to set System Policy.

[单选题]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?

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.

解析：解析：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 are the administrator of your company's network. Your network has 20 Windows 2000 server computers in the contoso.com domain. Your network also has 250 Windows 98 computers. You want to perform. a clean installation of Windows 2000 Professional on all of the Windows 98 computers. All of the Windows 98 computers are identical models and are PXE complaint.You want to accomplish the following goals:

An unattended installation of Windows 2000 Professional will be performed.

Each computer will be assigned a unique security identifier description.

解析：解析：Explanation:Thesetupmanagerisusedtocreateanunattend.txtanswerfile.Usingtheanswerfileanunattendedinstallationwillbeperformed.Newsecurityidentifierdescriptions(SIDs)arecreatedbydefaultduringtheinstallationprocess.Incorrectanswers:B:TheSysprep.exeutilityshouldberunaftertheinstallationoftheapplicationssothattheapplicationscanbeincludedintheunattendedinstallation.D:Thecomputerswillnotautomaticallyjointhecontoso.comdomain.YouneedtoprestagecomputeraccountsanduseaUDF(UniquenessDatabaseFile)forthecomputernames.

[多选题]You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

Implement snapshot replication.

Schedule replication to run during off-peak hours.

解析：解析：Explanation:

[单选题]You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system.You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.

Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.

解析：解析：Explanation:WhenupgradingearlierversionsofWindowstoWindows2000wemustusewinnt32.exeandmustlaunchitfromwithintheWindowsenvironment.Incorrectanswers:A:Windows2000canbeinstalledorupgradedonadiskorpartitionthatisformattedwiththeFATfilesystem.ThereisthusnoneedtoconvertthefilesystemtoNTFS.B:TheAdvancedConfigurationandPowerInterfaceisusedforpowermanagementanddoesnotaffecttheinstallationorupgradeprocess.ItwouldthusnotbenecessarytodisableACPI.D:ThesetupfloppydisksuseWinnt.exetoinstallWindows2000.WehowevercanonlyusethesetupfloppydiskstoinstallacleancopyofWindows2000onthecomputer.WecannotupgradetheoperatingsystemtoWindows2000usingthesetupfloppydisks.Wemustusewinnt32.exetoupgradeearlierversionsofWindowstoWindows2000.

[单选题]From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?

Run thenet use G: \\AppSrv\C$command.

解析：解析：Explanation:Therootofeachvolumeonaharddiskisautomaticallyshared,andthesharenameisthedriveletterappendedwithadollarsign($).Theappendeddollarsigncausesthesharetobehidden.Onemethodofmappingasharetoalogicaldriveistoopenthecommandpromptandtypethecommand:NETUSEdevicename:\\computername\sharename.Inthisscenario,thecommandtranslatestothecommand:netuseG:\\AppSrv\C$IncorrectAnswers:A:Thenetsharecommandisusedtocreatesharesnottoconnecttoexistingsharesonothercomputersinthenetwork.C:ItisnotpossibletobrowsetotheadministrativeshareC$onAppSrvsincethisisahiddenshare.D:ItisnotpossibletobrowsetotheadministrativeshareC$onAppSrvsincethisisahiddenshare.