MYSQL MCQ and Answers – Part 3

MYSQL MCQs questions with answers to prepare for exams, tests, and certifications. These questions are taken from a real written exam and some parts are taken from an interview. So you will find questions on MySQL Database, SQL query, Data Model, and more. This MCQ will easily prepare anyone to pass their exam.
 

1. Which of the following statements is correct for choosing the non-default character set?

A

Varchar(20) character set utf8;

B

Varchar(20);

C

Varchar(20) character set;

D None of the above

Answer  

2. Which of the following TEXT type has the maximum number of bytes?

A Tiny text

B Text

C Medium text

D Long text

Answer  

3. Which of the following has the maximum number of bytes?

A Varchar

B Char

C Text

D Both Varchar and Char

Answer [st_adsense]  

4. Which statement makes changes to database attributes?

A CHANGE

B ALTER

C ALTERNATE

D UPDATE

Answer  

5. What happen if the data stored in a column of type Text exceeds the maximum size of that type?

A Extra memory will be allocated

B End the process

C Data will be truncated

D Depends on the system

Answer  

6. Which data type is best suited for storing “small texts” in Mysql?

A Char

B Varchar

C Mediumtext

D Longtext

Answer  

7. Which data type is best suited for storing “documents” in Mysql?

A Char

B Varchar

C Mediumtext

D Longtext

Answer [st_adsense]  

8. Numeric types are used to describe ________?

A Integers numbers

B Natural numbers

C Rational numbers

D Integers and natural numbers

Answer  

9. Which numeric type has the largest range?

A Mediumint

B Smallint

C Int

D Tinyint

Answer  

10. What will be the storage form for “float(4,2)” in Mysql?

A Total of four digits, two to the left of the decimal and two to the right of the decimal

B Total of six digits

C Total of four digits, not evenly distributed

D None of the above

Answer