Derek Banas - Data Types Intro

Question 1

Numeric Data Types

Answer 1

1. TINYINT
2. SMALLINT
3. MEDIUMINT
4. INT
5. BIGIN
6. BOOL
7. FLOAT
8. DECIMAL

Question 2

Date and Time Data Types

Answer 2

1. DATE
2. DATETIME
3. TIMESTAMP
4. TIME
5. YEAR

Question 3

String Data Types

Answer 3

1. VARCHAR
2. BLOB
3. MEDIUMBLOB
4. LONGBLOB
5. ENUM
6. SET

Question 4

Limits of TINYINT

Answer 4

From: -127

To: 127

Storage: 1 byte

Question 5

Limits of SMALLINT

Answer 5

From: -2^15 (-32,768)

To: 2^15 - 1 (32,767)

Storage: 2 bytes

Question 6

Limits of MEDIUMINT

Answer 6

From: -2^23 (-8,388,608)

To: 2^23 - 1 (8,388,607)

Storage: 3 bytes

Question 7

Limits of INT

Answer 7

From: -2^31 (-2,147,483,648)

To: 2^31 - 1 (2,147,483,647)

Storage: 4 bytes

Question 8

Limits of BIGINT

Answer 8

From: -2^63 (-9,223,372,036,854,775,808)

To: 2^63 - 1 (9,223,372,036,854,775,807)

Storage: 8 bytes

Question 9

Limits of BOOL

Answer 9

0 OR 1

Question 10

Definition of FLOAT(size, d)

Answer 10

A floating point number (has a decimal point). The total number of digits is specified in size. The number of digits after the decimal point is specified in the d parameter.

Question 11

Definition of DECIMAL(size, d)

Answer 11

An exact fixed-point number. The total number of digits is specified in size. The number of digits after the decimal point is specified in the d parameter. The maximum number for size is 65. The maximum number for d is 30. The default value for size is 10. The default value for d is 0.

Question 12

Limit of TIME

Answer 12

Max 838:59:59.000000

Question 13

Limit of YEAR

Answer 13

1901 - 2155

Question 14

Definition of BLOB

Answer 14

For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data.

Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob. Database support for blobs is not universal.

Question 15

Definition of ENUM

Answer 15

A string object that can have only one value, chosen from a list of possible values. You can list up to 65535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted. The values are sorted in the order you enter them

Question 16

Definition of SET

Answer 16

A string object that can have 0 or more values, chosen from a list of possible values. You can list up to 64 values in a SET list

Question 17

Data Constraints

Answer 17

1. NOT NULL
2. DEFAULT
3. UNSIGNED
4. PRIMARY KEY
5. AUTO_INCREMENT

Question 18

Definition of NOT NULL

Answer 18

Must have a value, can’t have a value of NULL

Question 19

Definition of DEFAULT

Answer 19

Designate a value when ever a row is created without data

Question 20

Definition of UNSIGNED

Answer 20

Can’t use negative values

Question 21

Defitintion of PRIMARY KEY

Answer 21

Identified as unique values assigned to a raw

Question 22

Definition of AUTO_INCREMENT

Answer 22

Each time a row of data is created you would mark anything that is set to auto increment to NULL, and the database would automatically increemnt that value. Can only use auto increment to one column per table– column must be primary or unique key.

Question 23

1 table should represent 1…

Answer 23

real world object

Question 24

Columns store

Answer 24

1 piece of information

Question 25

Normalizing databases means:

Answer 25

reducing redundant data

Question 26

Primary keys are……………, while foreign keys are………………….. .

Answer 26

Primary keys are unique identifiers, while foreign keys are primary keys in another talbe.

Question 27

Conditional Operator: Not Equal to

Answer 27

<>

OR
!=