What is the best datatype for a column that is expected to store values up to 2 million? - MySQL MCQs

Home / Programming MCQs / MySQL MCQs / Question

M

Manisha Agrawal • 9.32K Points
Tutor III

Q. What is the best datatype for a column that is expected to store values up to 2 million?

(A) BIGINT

(B) SMALLINT

(C) TINYINT

(D) MEDIUMINT

Correct answer: Option(A)

MySQL Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

What does the DROP TABLE Statement do?

What does the CREATE DATABASE Statement do?

The updated MySQL extension with PHP5 is typically referred to as

What does the DROP DATABASE Statement do?

Which clause names the parent table and the index columns in the table?

What is the difference between nvarchar and ntext?

REPAIR TABLE does not work for

What is the maximum collations a character set can have?

Which of the following query is correct to get Current Date from Query?A. SELECT DATE ( NOW() ) as today;B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;

The keyword used with UNION that does not retain duplicate rows is ________

Learn All MySQL MCQs