What is the result of the below query. Assuming UserProfile is a table containing a column Proession which accepts NULL value. SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL)
A. Gives an error. B. Returns all Professions which has not null values. C. <> is not an operator in SQL Server. D. None of the above.