Data Types

Question 1

CHAR(N)

Answer 1

String data type. Have (N) amount of characters e.g CHAR(4) “Fred” or “1234”

Question 2

TEXT

Answer 2

String data type. May have variable number of characters e.g “hello” or “123456” or “ Sam”

Question 3

ENUM

Answer 3

String data type. Values are constrained to be one of a list of permitted values

Question 4

INT

Answer 4

Numeric data type. Can store whole numbers. May be positive or negative.

Question 5

REAL

Answer 5

Numeric data type. Can store numbers with decimal places. E.g 1.23, 1.45 , 0.56 -3.43235

Question 6

DATE

Answer 6

Data type that can store dates. E.g 1/24/2017 or 12 Sep 2002

Question 7

TIME

Answer 7

Data type that can store time values. E.g 03:15:00 (quarter past 3 am)

Question 8

BOOLE

Answer 8

Data type that can store the values TRUE and FALSE