PrepAway - Latest Free Exam Questions & Answers

Which of the following is the purpose of this Transact-SQL statement?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of the REVOKE SELECT ON Object Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?

PrepAway - Latest Free Exam Questions & Answers

A.
It disallows permissions on an object.

B.
It withdraws permissions on an object.

C.
It disallows permissions on an XML object collection.

D.
It switches the execution context back to the caller of the last EXECUTE AS statement.

Explanation:


Leave a Reply