1.5 Data Types

Question 1

data type

Answer 1

A data type is a named set of values from which column values are drawn.

Question 2

Integer

Answer 2

INT
Integer data types represent positive and negative integers.

Question 3

Decimal

Answer 3

DECIMAL(M,D)
FLOAT (4 Bytes)
DOUBLE (8 Bytes)

Decimal data types represent numbers with fractional values.

Question 4

Character

Answer 4

CHAR(N) - fixed length
VARCHAR(N) - variable lengh
TEXT

Character data types represent textual characters.

Question 5

Date and time

Answer 5

DATE
TIME
DATETIME

Date and time data types represent date, time, or both. Some date and time data types include a time zone or specify a time interval.

Question 6

Binary

Answer 6

Binary data types store data exactly as the data appears in memory or computer files, bit for bit.

Question 7

Spatial

Answer 7

Spatial data types store geometric information, such as lines, polygons, and map coordinates.

Question 8

Document

Answer 8

Document data types contain textual data in a structured format such as XML or JSON.

Question 9

signed

Answer 9

includes a - sign
A signed number may be negative.

Question 10

unsigned

Answer 10

An uNsigned number canNot be Negative.

Question 11

enum

Answer 11

Each value in the ENUM list is stored as a number internally, but it’s displayed as text. This is efficient for small, predefined lists, making it ideal for cases like days of the week, months, or product statuses.

If an attempt is made to insert a value outside of this set, the database will reject it.

CREATE TABLE Colors (
Color ENUM(‘Red’, ‘Green’, ‘Blue’)
);