When no modes are enabled, what does this SQL statement return?
SELECT @@SESSION.sql_mode;
SELECT @@SESSION.sql_mode;A. empty value
B. zero
C. a negative value
D. a garbage value
Answer: Option A
Solution (By Examveda Team)
This question is about SQL modes in MySQL. SQL modes are settings that control how MySQL interprets and executes SQL statements.The code
SELECT @@SESSION.sql_mode; is used to check the current SQL mode set for the current session.
If no modes are enabled, it means that the default SQL mode is being used.
In the default mode, the statement
SELECT @@SESSION.sql_mode; will return an empty value.
Therefore, the correct answer is Option A: empty value.

Join The Discussion