Question

What will the fn_Dominates return if A dominates B where A and B both are security label?

(a) 0

(b) 1

(c) NULL

(d) None of the mentioned

I got this question by my school principal while I was bunking the class.

The query is from Row Level Security topic in section Security of SQL Server

Answer 1

The correct answer is (b) 1

To explain I would say: fn_Dominates (Function) compares two labels and determines whether label A dominates label B.