Question

In the CREATE TABLE statement, the engine name specified is case sensitive.

(a) True

(b) False

This question was addressed to me in unit test.

My question is taken from Creating, Dropping, Indexing and Altering Tables topic in chapter Using SQL to Manage Data of MySQL

Answer 1

Correct choice is (b) False

To elaborate: Suppose a table is created using the following statement: ‘CREATE TABLE my_tbl (…..) ENGINE = InnoDB;’. The engine name ‘InnoDB’ used is always case insensitive.