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 Schema Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?
A.
It withdraws permissions on a schema.
B.
It disallows permissions on a schema.
C.
It disallows permissions on an XML schema collection.
D.
It switches the execution context back to the caller of the last EXECUTE AS statement.
Explanation: