Multiple choice technology web technology

Given there is non null data for Login column of Employee table, Running the statement "SELECT [LOGIN] FROM EMPLOYEE WHERE [LOGIN] <> NULL " will give the correct result only after executing which statement?

  1. SET ANSI_NULLS ON

  2. SET ANSI_NULLS OFF

  3. SET CONCAT_NULL_YIELDS_NULL ON

  4. SET CONCAT_NULL_YIELDS_NULL OFF
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When ANSI_NULLS is ON, the comparison operator '<>' does not work with NULL values - comparisons to NULL always return UNKNOWN. Setting ANSI_NULLS OFF allows the '<>' operator to work as expected with NULL comparisons. Options A and D are incorrect settings - CONCAT_NULL_YIELDS_NULL controls string concatenation behavior, not NULL comparisons.

Keep practicing — related questions