Question

INT3 maps to MySQL type _____________

(a) TINYINT

(b) SMALLINT

(c) MEDIUMINT

(d) BIGINT

I have been asked this question in a job interview.

This is a very interesting question from Choosing Data Types topic in division Data Types of MySQL

Answer 1

Right option is (c) MEDIUMINT

To explain I would say: In order to facilitate the use of the code written for SQL implementations (reusability of code) from other vendors, MySQL maps the data types from the other vendor types to the appropriate MySQL type.