The default case sensitivity of database and table names depends on ___________
(a) SQL server
(b) Server SQL mode
(c) Operating system of machine
(d) Does not depend on anything
(a) SQL server
(b) Server SQL mode
(c) Operating system of machine
(d) Does not depend on anything
Correct choice is (c) Operating system of machine
To elaborate: The default case sensitivity imposes a dependency on the operating system of the machine on which the MySQL server is running. Windows does not treat database and table names as case sensitive unlike Unix.