1. [单选题]You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
A. The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
B. You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
C. What should you do?
D. Create an UPDATE trigger that sends an e-mail message.
E. Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
F. Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
G. Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
2. [单选题]You are upgrading computer1 and computer2 from Windows NT Workstation 4.0 to Windows 2000 Professional. You successfully upgrade computer1. During the upgrade of computer2, a series of power outages interrupts the upgrade.You discover that the upgrade of computer2 is incomplete. Furthermore, you find that computer2 can no longer run Windows NT workstation 4.0. Computer2 does not support booting from the Windows 2000 Professional CD-ROM. You decide to use computer1 to help recover the failed upgrade.
A. What should you do?
B. On computer1, copy the CD-ROM driver and system files named ntdetect, ntbootdd.sys, Ntdll.dll and Setupldr.bin to a formatted floppy disk. On computer2, restart the computer by using the floppy disk. Then run WinNT32/debug from the Windows 2000 Professional CD-ROM.
C. From computer1, copy the CD-ROM driver and system files named Ntdetect, Ntbootdd.sys, Ntdll.dll, and Setupldr.bin to a formatted floppy disk. On the computer2, restart the upgrade by using the floppy disk. Then run WinNT32/rx from the Windows 2000 Professional CD-ROM.
D. On the computer1, run Makebt32.exe from the Bootdisk folder on the Windows 2000 Professional CD-ROM. On computer2, restart the upgrade by using the newly created floppy disks.
E. On computer1, perform. a remote installation from a network share. On computer2, when the text portion of setup has completed, resume the installation by using the Setup Manager.
3. [单选题]You plan to install Windows 2000 Server on 10 new computers. These servers will provide file and print services in branch offices of Ezonexam.com. The company wants each branch office to purchase its own copy of Windows 2000 Server, and the installation in each branch office should use the serial number associated with the branch office's own copy.You want to install, configure, and test Windows 2000 Server on these computers at the main office before shipping the computers to the branch offices. You want users in the branch office to enter the computer names and serial numbers when they receive the computers.
A. What should you do?
B. Install Windows 2000 Server on the computers by using an unattend.txt file, and then use the registry editor to remove the computer name and license details.
C. Start the installation process from an MS-DOS boot disk. Install Windows 2000 Server on the computers from an existing server by running the Winnt command with the PreInst switch.
D. Install Windows 2000 Server on the computers, and then use Setup Manager to create a sysprep.inf file for sysprep.exe. Place the sysprep.inf file on the computers and run the sysprep-nosidgen command.
E. Create an unattend.txt file by using Setup Manager. Include the following line in the unattend.txt file. emPrenistall=YES. Use this file to perform. the installation.
