Question: MySQL server can operate in different SQL modes, depending on the value of the sql_mode system variable. Which mode changes syntax and behavior to conform more closely to standard SQL?

  1. TRADITIONAL
  2. ANSI
  3. MSSQL
  4. STRICT

Answer: The correct answer of the above question is Option B:ANSI