When executing a stored routine, how is the SQL_MODE determined?
A.
By the default SQL_MODE of the server
B.
By the current SQL _MODE of the session
C.
By the SQL_MODE that was set when the routine was defined
D.
By using TRADITTIONAL regardless of any other settings
I think C
http://dev.mysql.com/doc/refman/5.6/en/routines-table.html
C
MySQL 5.0 Certification Study Guide by Dubois, Hinz, and Pedersen:
“When a stored routine executes, its environment is set to that database that it belongs to becomes its default database for the duration of its execution (keep reading). Also, the SQL_MODE system variable value in effect when the routine executes is the value that was current when it was defined.”
C