Top 20 MCQ Questions On MySQL Data Types

Here are the collections of top 20 MCQ questions on MySQL data types includes multiple-choice questions on the fundamentals of MySQL data types and their attributes. It includes MCQ questions on different data types of MySQL data types such as date and time data types, numeric data types and string data types, and the different attributes of MySQL data types.

1) Which of the following is the standard format the MySQL displays DATE values.
A. YYYY-MM-DD
B. DD-MM-YYYY
C. YY-MM-DD
D. MM-DD-YYYY

2) The … data type is responsible for sorting a combination of date and time information.
A. DATE
B. TIME
C. DATETIME
D. TIMESTAMP

3) The … data type in MySQL supports a signed range of -128 to 127 and an unsigned range of 0 to 255.
A. INT
B. SMALLINT
C. MEDIUMINT
D. TINYINT

4) Which of the following is/are the types of string data types for representing string data.
i. LONGBLOB ii. BLOB
iii. TEXT iv. TINYBLOB
A. i, ii and iii only
B. ii, iii and iv only
C. i, iii and iv only
D. All i, ii, iii and iv

5) When the… attribute is specified in the MySQL data type, ensures the column uses the default character set.
A. DEFAULT
B. INDEX
C. NATIONAL
D. NULL

6) The … attribute in the MySQL data type has the ability to assign unique integer identifiers to the newly inserted rows.
A. INCREMENT
B. AUTO_INCREMENT
C. UNIQUE
D. UNIQUE_INTEGER

7) MySQL requires that the … attribute be used in conjunction with column designated as the primary key.
A. COLUMN_KEY
B. AUTO_INCREMENT
C. PRIMARY_KEY
D. UNIQUE_KEY

8) State whether the following statements about the attributes of MySQL data types are TRUE or FALSE.
i. The BINARY attribute is only used in conjunction with CHAR and VARCHAR values.
ii. The NULL attribute indicates that no value can exist for the given field.
iii. The DEFAULT attribute can be used in conjunction with BLOB or TEXT fields.
A. i-True, ii-True, iii-False
B. i-True, ii-False, iii-False
C. i-False, ii-True, iii-False
D. i-False, ii-True, iii-True

9) The … attribute used in MySQL data type is offered as an aid in the database compatibility.
A. DEFAULT
B. INDEX
C. NATIONAL
D. NULL

10) A column assigned the … attribute will ensure that all values possess distinct values, except that NULL values are repeatable.
A. UNIQUE
B. UNIQUE KEY
C. KEY
D. PRIMARY KEY

11) The … attribute is available to any of the numeric types and will result in the replacement of all remaining field space with zeroes.
A. NULL
B. ZEROFILL
C. ZEROES
D. ZERO FIELD

12) The … attribute of MySQL data type is used to guarantee uniqueness for a given row.
A. UNIQUE
B. UNIQUE KEY
C. KEY
D. PRIMARY KEY

13) The … data type provides a means for storing a maximum of one member chosen from a predefined group consisting of a maximum of 65,535 distinct members.
A. ENUM
B. SET
C. STORE
D. SET MAX

14) The … data type provides a means for specifying zero or more values are chosen from a predefined group consisting of a maximum of 64 members.
A. ENUM
B. SET
C. STORE
D. SET MAX

15) The … is the data type of MySQL that supports a maximum length of 255 characters.
A. TEXT
B. TINYTEXT
C. CHAR
D. TINYCHAR

16) State whether the following statements about string data types in MySQL are TRUE or FALSE.
i. The BLOB data type in MySQL supports a maximum length of 65,535 characters.
ii. The TINYBLOB data type in MySQL is the binary string representation, supporting a maximum length of 255 characters.
A. i-True, ii-True
B. i-True, ii-False
C. i-False, ii-True
D. i-False, ii-False

17. The YEAR data type in MySQL supports which of the following types of values.
i. Two-digit number.
ii. Four-digit number.
iii. Four-digit string
A. i and ii only
B. ii and iii only
C. i and iii only
D. All i, ii and iii

18) For all date and time data types, MySQL will accept any type of … delimiter to separate the various date and time values.
A. numeric
B. alphanumeric
C. nonalphanumeric
D. nonnumeric

19) The … data type offers MySQL’s fixed-length string representation, supporting a maximum length of 255 characters.
A. TEXT
B. CHAR
C. FIXEDCHAR
D. TINYCHAR

20) State whether the following statements about MySQL data type are TRUE or FALSE.
i. The TIMESTAMP data type differs from DATETIME in that MySQL’s default behavior is to automatically update it to the current date and time.
ii. In CHAR data type, if an inserted string does not occupy all of the length spaces, the remaining space will be padded by blank spaces.
A. i-True, ii-True
B. i-True, ii-False
C. i-False, ii-True
D. i-False, ii-False

Answers: