You work as a Database Administrator for ABC Inc.

GIAC GSSP-NET-CSHARP Question Answer

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?

Create a user-defined function to modify data.

Create a RULE on both the columns.

Create a stored procedure to modify data

Create a CHECK constraint on both the columns.

GSSP-NET-CSHARP PDF/Engine

Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions

Get 65% Discount on All Products, Use Coupon: "ac4s65"

You work as a Software Developer for ABC Inc.

Halloween Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

You work as a Database Administrator for ABC Inc.

The Answer Is:

Quick Links