GIAC
GSSP-NET · Question #362
GSSP-NET Question #362: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-NET to reveal the answer and full explanation for question #362. The question stem and answer options stay visible for context.
Question
You work as a Database Administrator for ABC Inc. The company has a SQL Server 2000 computer. One of the databases on the server contains a table named Employees, for storing information about employees in the company. There are two employees, Joe and Rick, to whom you want to give additional responsibilities. You want Joe to be allowed to modify only the E-mail column of the table, and Rick should be allowed to modify only the Salary column of the table. Neither Joe nor Rick should be allowed to have permission on the Employees table. You want to ensure that the above rule is followed strictly. What will you do to accomplish this?
Options
- ACreate a user-defined function to modify data.
- BCreate a RULE on both the columns.
- CCreate a stored procedure to modify data
- DCreate a CHECK constraint on both the columns.
Unlock GSSP-NET to see the answer
You've previewed enough free GSSP-NET questions. Unlock GSSP-NET for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.