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

查看原题查看所有试题

学习资料的答案和解析：

[单选题]From your Windows 2000 Professional computer, you need to print from a 16-bit accounting application to a network printer named Printer02. Printer02 is attached to a print server named PrtSrv. The accounting application allows you to print only to a local LPT port.You currently have two printers attached to your local LPT1 and LPT2 ports. You need to be able to print to the network printer and to both local printers. You install the driver for the network printer on your computer.

Run thenet use Lpt3: \\PrtSrv\Printer02command.

解析：解析：Explanation: The net use command is the only method available for accessing a network printer from client computers that are running 16-bit DOS applications.

[单选题]You are the administrator of a Windows 2000 Network for Ezonexam Inc. The network includes four Web servers named WWW1, WWW2, WWW3, and WWW4. Your network also includes a Windows 2000 Server computer that uses DNS.Each Web server contains exactly the same content, and users accessing www.Ezonexam.com can be directed to any one of them.

Enable round-robin in the properties of the DNS server.

解析：解析：Explanation: By enabling round robin the DNS server will start to rotate between the CNAME records when it resolves the host name www. This will result in load balancing between the web servers.

[单选题]You are the administrator of Ezonexam.com's Windows 2000 network.Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files.

Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.

解析：解析：Explanation: Windows 2000 Professional uses the NTFS 5.0 file system while Windows NT Workstation 4.0 uses the NTFS 4.0 file system. Windows NT Workstation requires Service Pack 4 or later to be able to use the NTFS 5.0 file system.

[多选题]The network consists of a single domain named Ezonexam.com that includes 20 Windows NT workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers. You install Terminal Services on one of the Windows Server computers and Terminal Services Client on the 20 Windows NT Workstation 4.0 client computers. You create a system policy on the server that is configured as the terminal server. This system policy denies access to Network Neighborhood. You find that the users of the terminal server can still browse the network when they open My Network Places from Windows 2000 Professional computer or when they open Network Neighborhood from Windows NT Workstation 4.0 computers.You want to prevent all users from browsing the network.

Create a Windows Group Policy that denies user access to My Network Places.

Create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator.

解析：解析：Explanation: The primary domain controller (PDC) is the server that maintains the master copy of the domain's user-accounts database and that validates logon requests. Prior to Windows 2000 every Windows NT network domain was required to have one, and only one, PDC. If you want to deny users of the terminal server browsing ability of the Network Neighborhood, you should create a group policy that denies access to My Network Places. (Microsoft is colloquially stuck with Network Neighborhood for My Network Places.)

[单选题]You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'

In the IIS console, enable anonymous access to WebReports.

解析：解析：Explanation: The proper NTFS permissions, read permission, have already been granted. To access the folder through Internet Explorer the folder must be published in Internet Information Services (IIS), and authentication through IIS must be provided. By enabling anonymous access in the IIS console the folder would be accessible through Internet Explorer.

[单选题]Your network uses TCP/IP as the only network protocol. Devices on the network are configured to use IP addresses from the private 10.0.0.0 range. All the client computers on the network use Windows 2000 Professional. The network includes Windows 2000 Servers and UNIX Servers.Users' print jobs are sent to shared printers on a Windows 2000 Server computer named PrintServ that directs the print jobs to the print devices attached directly to the network.

Create a local printer on PrintServ. Create a new TCP/IP port for an LPR server at address 10.1.1.99 with a queue name of GIANT. Share this printer and connect it from the users' computers.

解析：解析：Explanation:InthisscenarioanewlocalprintermustbesetuponPrintServ.TheprinterwilluseaTCP/IPportwiththecorrectIPaddress.ThequeuenamemustbesettoGIANT.ThenwecansharetheprinterandconnecttoitfromothercomputersasausualWindows2000printer.Incorrectanswers:A:MicrosoftprintservicesforUNIXwouldonlybeneedediftheprintdevicewasattachedtoaWindows2000printercomputer.B:MicrosoftprintservicesforUNIXwouldonlybeneedediftheprintdevicewasattachedtoaWindows2000printercomputer.C:TheprinterdeviceisattachedtoaUNIXcomputer,whichusestheLPRprintingprotocol.AnetworkprintercanonlybecreatedforprintdeviceconnectedtoaWindows2000printercomputer.

[多选题]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.

[多选题]计算机指令一般包括操作码和地址码两部分，为分析执行一条指令，其  （1）      

操作码和地址码都应存入指令寄存器。

操作码和地址码都应存入程序计数器

解析：

答案：（1）C    

试题解析：   

 指令寄存器（IR）用来保存当前正在执行的一条指令。当执行一条指令时，先把它从内存取到数据寄存器（DR）中，然后再传送至IR。指令划分为操作码和地址码字段，由二进制数字组成。为了执行任何给定的指令，必须对操作码进行测试，以便识别所要求的操作。指令译码器就是做这项工作的。指令寄存器中操作码字段的输出就是指令译码器的输入。操作码一经译码后，即可向操作控制器发出具体操作的特定信号。