Integer types (TINYINT, INT, BIGINT) in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a column that stores very small integers.

MySQL

CREATE TABLE example (age [1]);

Drag options to blanks, or click blank then click option'

ATINYINT

BVARCHAR(10)

CTEXT

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using VARCHAR or TEXT for numbers causes storage inefficiency.

Using DATE type for numbers is incorrect.

The TINYINT type stores very small integers, using 1 byte.

2fill in blank

medium

Complete the code to create a column that stores standard integers.

MySQL

CREATE TABLE example (score [1]);

Drag options to blanks, or click blank then click option'

ACHAR(5)

BFLOAT

CBOOLEAN

DINT

Attempts:

3 left

💡 Hint

Common Mistakes

Using FLOAT stores decimal numbers, not integers.

CHAR and BOOLEAN are not integer types.

The INT type stores standard integers, using 4 bytes.

3fill in blank

hard

Fix the error in the code to create a column for very large integers.

MySQL

CREATE TABLE example (population [1]);

Drag options to blanks, or click blank then click option'

AINT

BBIGINT

CTEXT

DVARCHAR(20)

Attempts:

3 left

💡 Hint

Common Mistakes

Using INT for very large numbers can cause overflow.

VARCHAR and TEXT are for strings, not numbers.

BIGINT stores very large integers, using 8 bytes.

4fill in blank

hard

Fill both blanks to create a table with a small and a large integer column.

MySQL

CREATE TABLE data (small_num [1], large_num [2]);

Drag options to blanks, or click blank then click option'

ATINYINT

BVARCHAR(10)

CBIGINT

DTEXT

Attempts:

3 left

💡 Hint

Common Mistakes

Using VARCHAR or TEXT for numbers.

Mixing up the sizes of integer types.

TINYINT is for small integers, and BIGINT is for large integers.

5fill in blank

hard

Fill all three blanks to create a table with three integer columns of increasing size.

MySQL

CREATE TABLE numbers (small [1], medium [2], large [3]);

Drag options to blanks, or click blank then click option'

ATINYINT

BINT

CBIGINT

DVARCHAR(5)

Attempts:

3 left

💡 Hint

Common Mistakes

Using VARCHAR for integer columns.

Confusing the order of integer sizes.

TINYINT is the smallest integer type, INT is medium, and BIGINT is the largest.