Data types

Question 1

VARCHAR

Answer 1

string of various length (example – person’s name)

Question 2

TEXT

Answer 2

long text strings, no length specification needed (example – product
description)

Question 3

BLOB

Answer 3

binary large object, stores data like audio, video, images, files (example – product image)

Question 4

CHAR

Answer 4

string of fixed length, adds spaces to the end of string to make it the
correct length

Question 5

BINARY

Answer 5

Fixed-length binary string

Question 6

VARBINARY

Answer 6

Variable-length binary string

Question 7

ENUM

Answer 7

A list of predefined values where one can be entered. If adding a value not in the list, you get an empty string (example – clothing sizes

Question 8

SET

Answer 8

A list of predefined values where zero or many can be entered (example – clothing sales seasons)

Question 9

INT

Answer 9

A standard integer, no decimals/fractions (signed – zero and positive
numbers; unsigned – zero, positive, and negative numbers)

Question 10

FLOAT

Answer 10

Storing an approximate decimal value with 6-9 significant figures

Question 11

DOUBLE

Answer 11

Storing an approximate decimal value, more precise version of a
float with 15-17 significant figures

Question 12

DECIMAL

Answer 12

specify maximum number of digits and the number of decimals.
Good for accuracy with 28-29 significant figures

Question 13

BIT

Answer 13

binary values, either 0s or 1s, up to a certain length

Question 14

DATE

Answer 14

date value in CCYY-MM-DD format

Question 15

TIME

Answer 15

time value in hh:mm:ss format

Question 16

YEAR

Answer 16

year value in CCYY or YY format

Question 17

DATETIME

Answer 17

date and time value in CCYY-MM-DD hh:mm:ss format (no
timezone information)

Question 18

TIMESTAMP

Answer 18

timestamp value in CCYY-MM-DD hh:mm:ss format