adplus-dvertising
frame-decoration

Question

The best datatype for a column that is expected to store values up to 2 million is _________

a.

SMALLINT

b.

TINYINT

c.

MEDIUMINT

d.

BIGINT

Posted under MySQL Database

Answer: (d).BIGINT

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The best datatype for a column that is expected to store values up to 2 million is _________

Similar Questions

Discover Related MCQs

Q. The function that returns reference to hash of row values is ____________

Q. Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?

Q. Which privileges are required on the source server to use mysqldbcopy?

Q. The program that copies the databases from one server to another is ____________

Q. Which operator is used to check the expression is not “NULL”?

Q. Which operator is used to check whether the expression is “NULL”?

Q. Is the following statement is true/false?

“Two NULL values are equal to each other”

Q. Is the following statement is true/false?

“An expression can be NULL, but can never equal to NULL”

Q. What is the meaning of “NULL” in Mysql?

Q. Which among the following operators is/are belongs to “Range conditions”?

Q. Which among the following operators is/are belongs to “Equality conditions”?

Q. Which among the following operators is/are belongs to “Inequality conditions”?

Q. Fill the blanks with suitable options?

BETWEEN ______ AND ______

Q. Which among the following data types can be used with “Range Condition”?

Q. What is the meaning of “Range Conditions”?

Q. What is the meaning of “Inequality Condition”?

Q. What is the meaning of “Equality Conditions”?

Q. Select odd one out?

Q. Which of the following statements is/are correct?

Q. Which of the following statements is/are correct?