MariaDB Data Types Quiz

What is the range of a TINYINT in MariaDB?

• -32768 to 32767

• 0 to 255

• -2147483648 to 2147483647

• -128 to 127

Answer explanation

The range of a TINYINT in MariaDB is -128 to 127, allowing for values from -128 to 127 to be stored in this data type.

Which of the following is a synonym for INT in MariaDB?

• INTEGER

• MEDIUMINT

• SMALLINT

• BIGINT

Answer explanation

The correct synonym for INT in MariaDB is INTEGER. Therefore, the correct choice is INTEGER.

What does the DECIMAL data type in MariaDB represent?

• A floating-point number

• An integer

• A packed "exact" fixed-point number

• A binary large object

Answer explanation

The DECIMAL data type in MariaDB represents a packed 'exact' fixed-point number, not a floating-point number, integer, or binary large object.

Which data type is used for storing IPv4 addresses in MariaDB?

• VARCHAR

• BLOB

• ENUM

• INET4

Answer explanation

The correct data type for storing IPv4 addresses in MariaDB is INET4, specifically designed for this purpose.

What is the maximum length of a VARCHAR in MariaDB?

• 255 characters

• 4,294,967,295 characters

• 16,777,215 characters

• 65,535 characters

Answer explanation

The maximum length of a VARCHAR in MariaDB is 65,535 characters, making it the correct choice among the options provided.

Which of the following is NOT a numeric data type in MariaDB?

• FLOAT

• DOUBLE

• ENUM

• DECIMAL

Answer explanation

The data type ENUM is not a numeric data type in MariaDB, making it the correct choice as it does not belong to the numeric data types category.

What is the synonym for DECIMAL in Oracle mode within MariaDB?

• NUMERIC

• FIXED

• NUMBER

• INT

Answer explanation

The correct synonym for DECIMAL in Oracle mode within MariaDB is NUMBER.

Which data type would you use to store a binary large object up to 4GB in size?

• LONGBLOB

• MEDIUMBLOB

• TINYBLOB

• BLOB

Answer explanation

The correct data type to store a binary large object up to 4GB in size is LONGBLOB, as it can hold larger amounts of data compared to other options like BLOB, TINYBLOB, and MEDIUMBLOB.

What is the storage requirement for a DATE data type in MariaDB?

• 5 bytes

• 4 bytes

• 8 bytes

• 3 bytes

Answer explanation

The storage requirement for a DATE data type in MariaDB is 4 bytes, making the correct answer choice 4 bytes.

Which of the following data types is intended for the storage of UUID data?

• UUID

• BINARY

• VARCHAR

• CHAR

Answer explanation

The correct data type intended for the storage of UUID data is UUID. This data type is specifically designed to store UUID values efficiently.