单项选择题
A.A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.
B.On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.
C.A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.
D.On the Price column， a foreign key constraint is created to a table that valid prices are included.
单项选择题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is named SQL1. The company has backups of all system databases performed every Saturday night， and have backups of all user databases performed every Sunday night. And the company has all backups stored in an off-site facility. Because of the power outage， SQL1 accidentally turns off. And after bringing SQL1 back online， the users cannot start the SQL Server service. You can see the SQL Server error log from the exhibit below. SQL1 should be returned to working order in the shortest time. Which action should be performed first？（）
单项选择题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized. Which action should be performed？（）