Question

The server is told to accept spaces after function names by _____________

(a) –sql-mode=SKIP_SPACE

(b) –sql-mode=IGNORE_SPACE

(c) –sql-mode=SPACE_IGNORE

(d) –sql-mode=SPACE_SKIP

I have been asked this question by my college director while I was bunking the class.

Origin of the question is Functions topic in portion Data Type Reference, Operators and Functions of MySQL

Answer 1

Correct answer is (b) –sql-mode=IGNORE_SPACE

For explanation I would say: The MySQL server is told to accept spaces after function names by starting it with the ‘–sql-mode=IGNORE_SPACE’ option. Individual client programs can request this behavior by using the ‘CLIENT_IGNORE_SPACE’ option for ‘mysql_real_connect()’.