题目内容

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.
The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
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.
What should you do？

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.
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 administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.
You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.
You want the users to be able to add data, and you want to minimize administrative overhead. What should you do？

A. Increase the maximum file size of Sales_Data to 1,500MB.
B. Use the DBCC SHRINKDATABASE statement.
C. Set automatic file growth to 10 percent.
D. Create another data file named Sales_Data2 in a new SECONDARY filegroup.

查看答案

You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.
To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take？ (Each correct answer represents part of the solution. Choose two.)

A. Perform. a combination of full database and filegroup backups.
B. Perform. a combination of full database and file backups.
C. Perform. a combination of full database, differential, and transaction log backups.
D. Back up the data to a local tape drive.
E. Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.

查看答案

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？

A. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.
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.
C. Set a flag on each DTS transformation to require an exact match between source and destination columns.
D. Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.
E. Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.

查看答案

某城市1996年至2001年各年与上一年相比地价增长速度依次为1%、2%、5%、6%、5%、3%，若以1998年为基期，则2001年的增长速度为()。

A. 8.15%
B. 14.64%
C. 20.37%
D. 24.00%

查看答案