Multiple choice technology databases

Which one is true?

  1. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to OFF

  2. setting ANSI_WARNINGS to ON will not affect ARITHABORT settings

  3. Both are same

  4. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL Server, setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON for query execution behavior. The option stating they do not affect each other, are the same, or set it to OFF are incorrect.

Keep practicing — related questions