adplus-dvertising
frame-decoration

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

Posted under Data Security SQL Server

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

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Point out the wrong statement.

Similar Questions

Discover Related MCQs

Q. Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?

Q. View that contains the list of all the security labels present in the database are __________

Q. Point out the correct statement.

Q. Which of the following condition in the where clause will return the login identification name of the user?

Q. Which of the following functions decrypts data by using a symmetric key?

Q. ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.

Q. Which of the following catalog view is used to monitor TDE?

Q. Which of the following is valid code to backup a certificate?

Q. Like data compression, TDE database encryption is performed at the ______ level.

Q. Point out the wrong statement.

Q. Which of the statement is used to create a new certificate with a valid subject in SQL Server?

Q. Which of the following script creates master key?

Q. Point out the wrong statement.

Q. To add or remove server role membership use ____________

Q. Any SQL Server authentication login can see ________ login name.

Q. Which of the following returns a row for each security principal in a SQL Server database?

Q. The schema securable scope contains the following securable is __________

Q. Point out the wrong statement.

Q. What is the syntax for fn_my_permissions function in SQL Server 2014?

Q. _________ returns a list of the permissions effectively granted to the principal on a securable.