MySQL - Data Types MCQ

MySQL – Data Types MCQ

1 / 22

1. What is the purpose of MySQL data types?

Specify the table structure

Set the primary key

Define the database name

Describe the column's data

2 / 22

2. Which category of MySQL data types is used to store numbers?

Date and Time Types

Numeric Types

Binary Types

String Types

3 / 22

3. Which data type is suitable for storing a person’s age in years?

VARCHAR

DATE

CHAR

INT

4 / 22

4. Which data type is used for storing floating-point numbers in MySQL?

VARCHAR

ENUM

DECIMAL

FLOAT

5 / 22

5. What is the primary use of VARCHAR data type in MySQL?

Storing variable-length text

Storing fixed-length text

Storing integers

Storing binary data

6 / 22

6. Which data type is used to store binary data like images or files?

BLOB

VARCHAR

TEXT

VARBINARY

7 / 22

7. What data type is commonly used to store date values in MySQL?

BLOB

CHAR

DATETIME

BOOLEAN

8 / 22

8. Which data type can store both date and time information in MySQL?

TIME

DATETIME

DATE

VARCHAR

9 / 22

9. What is the primary use of ENUM data type in MySQL?

Storing geographic data

Storing JSON documents

Storing a list of values

Storing binary data

10 / 22

10. Which data type can be used to efficiently store JSON documents in MySQL?

JSON

TEXT

DATE

FLOAT

11 / 22

11. Which data type is suitable for storing binary data like images or files?

VARCHAR

BLOB

TEXT

VARBINARY

12 / 22

12. What is the purpose of data type selection when defining a table in MySQL?

To specify the table name

To set foreign keys

To define the column's data

To declare primary keys

13 / 22

13. Which data type is typically used to store a person’s name in MySQL?

DATE

DECIMAL

BOOLEAN

CHAR

14 / 22

14. What is the primary difference between CHAR and VARCHAR data types?

CHAR stores fixed-length text while VARCHAR stores variable-length text

CHAR is used for binary data while VARCHAR is used for text

CHAR stores variable-length text while VARCHAR stores fixed-length text

CHAR is used for numeric values while VARCHAR is used for strings

15 / 22

15. Which data type is commonly used to store email addresses in MySQL?

DATE

INT

JSON

VARCHAR

16 / 22

16. When would you use a BLOB data type in MySQL?

To store binary data

To store date values

To store text data

To store floating-point numbers

17 / 22

17. Which data type is used for storing date and time values in MySQL?

CHAR

BLOB

DATETIME

ENUM

18 / 22

18. What is the primary purpose of the JSON data type in MySQL?

Storing JSON documents

Storing images and files

Storing date and time values

Storing numeric data

19 / 22

19. Which data type would you choose to store a list of country names in MySQL?

BINARY

TEXT

ENUM

DATETIME

20 / 22

20. What is the primary use of the SET data type in MySQL?

Storing JSON documents

Storing a list of values

Storing binary data

Storing geographic data

21 / 22

21. Which data type is appropriate for storing geographic coordinates in MySQL?

JSON

INT

GEOMETRY

VARCHAR

22 / 22

22. In which category of MySQL data types would you find the TINYINT data type?

Spatial Types

Date and Time Types

Numeric Types

String Types

Your score is

0%