Home » MYSQL » Server SQL Mode » Question
  1. When no modes are enabled, what does this statement return?
    SELECT @@SESSION.sql_mode;
    1. zero
    2. a garbage value
    3. empty value
    4. a negative value
    5. None of these
Correct Option: C

When it is needed to determine the current value of the session SQL mode, the above statement is executed. The returned value consists of a comma-separated list of the modes that are enabled.

Your comments will be displayed only after manual approval.