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. [单选题]Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named Share
A. You want to respond to the user's problem as quickly as possible by using an administrative tool.
B. What should you do?
C. Use Windows Explorer to display the file paths of your shared folders.
D. Use Storage in Computer Management to view logical drive properties.
E. Use Event Viewer in Computer Management to search for shared folder error messages.
F. Use System Tools in Computer Management to display the file paths of your shared folders.
