Question

Point out the correct statement.

(a) Implementing row level security based on security labels is possible in SQL Server 2008

(b) A security label is a marking that describes the securable content of an item

(c) Row-level permissions are used for applications that store information in a single table

(d) None of the mentioned

This question was addressed to me by my school principal while I was bunking the class.

This question is from Row Level Security topic in portion Security of SQL Server

Answer 1

Correct answer is (c) Row-level permissions are used for applications that store information in a single table

To explain I would say: SQL Server does not have support for implementing row-level security. You must create additional columns in your tables that define row filtering mechanisms.