【单选题】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 cu...
A.
Create an UPDATE trigger that sends an e-mail message.
B.
Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C.
Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D.
Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
【单选题】You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database appli...
A.
Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B.
Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C.
Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D.
Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.