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

正确答案 ：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.

解析：解析：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.

[单选题]Your Windows 2000 Server computer has a 10-GB hard disk with two partitions: Drive C and drive D. Windows 2000 Server is installed on Drive D. Both partitions are formatted as NTFS. Your office experiences a power failure that causes your Windows 2000 Server computer to restart.When the computer is restarting, you receive the following error message "NTLDR is missing. Press any key to restart".

正确答案 ：B

Start the computer by using Windows 2000 Server computer CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system partition.

解析：解析：Explanation:Theproblemposedinthisscenariocouldarisefromanumberofcauses.ItcouldbethattheNTLDRismissing,orthebootsectoriscorrupt,orthediskisphysicallydamaged.IfweassumethattheproblemcausedbyamissingNTLDR,wecoulduseeithertheEmergencyRepairDisk(ERD)ortheRecoveryConsoletocorrectheproblem.UsingeithertheEmergencyRepairDiskortheRecoveryConsolewewouldattempttocopytheNTLDRfilefromtheWindows2000installationCD-ROMtotherootofthesystempartition,whichcouldsolvethebootproblem.Incorrectanswers:B:Debuggingmodeisaspecialsafemodeoptionthatusedbydeveloperstodebugprograms.ItcannotbeusedrestoretheNTLDR.C:Windows2000doesnotsupportabootablefloppydisk,althoughthefourWindows2000setupdiskscouldbeusedtostartthecomputerinWindows2000.TheRecoveryConsoleortheERDprocessmustbeusedtorestoretheNTLDR.D:TheFileSignatureVerificationutilityisusetotesttheintegrityofdevicedrivers.ItcannotbeusedrestoretheNTLDR.

查看原题