MySQL Questions and Answers – MySQL Datatypes – 2

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “MySQL Datatypes – 2”.

1. What will happen if the data being loaded into a text column exceeds the maximum size of that type?
a) Extra memory will be allocated
b) Process terminate
c) Data will be truncated
d) Depend on the system
View Answer

2. Which data type is more suitable for storing “small notes” in Mysql?
a) Char
b) Varchar
c) Mediumtext
d) Longtext
View Answer

3. Which data type is more suitable for storing “documents” in Mysql?
a) Varchar
b) Longtext
c) Mediumtext
d) Either Varchar or Longtext
View Answer

4. “Numeric Data” is used to store ____________
a) Whole numbers
b) Natural numbers
c) Rational numbers
d) Both Whole and Natural numbers
View Answer

5. Which Numeric Data type has the largest range?
a) Mediumint
b) Smallint
c) Int
d) Tinyint
View Answer

6. What will be the storage pattern for “float(4,2)” in Mysql?
a) Total of four digits, two to the left of decimal and two to the right of decimal
b) Total of six digits
c) Total of four digits, not distributed uniformly
d) None of the mentioned
View Answer

7. Which among the following are the correct representation of “float(4,2)”?
a) 24.33
b) 124.4
c) 12.123
d) Both 24.33 and 124.4
View Answer

8. Which among the following is the correct representation of “float(5,0)”?
a) 12345.123
b) 12345.1
c) 12345
d) 123.123
View Answer

9. Which among the following is the correct representation of “float(1,1)”?
a) Total of 1 digit
b) Total of 2 digit
c) Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.