Question

Point out the wrong statement.

(a) usp_EnableCellVisibility opens all the symmetric keys that are mapped to security labels

(b) usp_DisableCellVisibility opens all the symmetric keys that were previously opened

(c) On SQL Server 2012 you can use the Contained Database feature to create a user without a login

(d) No arguments are available for usp_EnableCellVisibility

This question was posed to me by my college director while I was bunking the class.

Asked question is from Row Level Security topic in division Security of SQL Server

Answer 1

The correct answer is (b) usp_DisableCellVisibility opens all the symmetric keys that were previously opened

Best explanation: usp_DisableCellVisibility (Stored Procedure) closes all the symmetric keys that were previously opened by calling usp_EnableCellVisibility.