Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS ONSELECT ProfessionFROM UserProfileWHERE (Profession <> NULL)
A. Returns records which has values in profession column B. Gives an error. C. Does not retrieve any records even if profession column contains values. D. None of the above.