Section 1

Question 1

What are the 3 parts of a database model?

Answer 1

1. Data structures that prescribe how data is organized.
2. Operations that manipulate data structures.
3. Rules that govern valid data.

Question 2

What data base model is used in SQL?

Answer 2

Relational Model: A model based on tabular data structure.

Question 3

Set

Answer 3

An unordered collection of elements enclosed in braces.

Question 4

Tuple

Answer 4

An ORDERED collection of elements enclosed in parentheses.

Question 5

What does a table consist of?

Answer 5

A name, a fixed tuple of columns, and a varying set of rows.

Question 6

A column has what?

Answer 6

A name and a data type.

Question 7

Row

Answer 7

is an unnamed tuple of values. Each value corresponds to a column and belongs to the column’s data type.

Question 8

Data type

Answer 8

is a named set of values from which column values are drawn

Question 9

What is another name for Table in mathematics and Files?

Answer 9

Relation and File

Question 10

What is another name for column?

Answer 10

Attribute and Field

Question 11

What is anothr name for row?

Answer 11

Tuple and Record

Question 12

What is another name for Data Type?

Answer 12

Domain and Data Type (Files)

Question 13

What are the relational rules?

Answer 13

-Unique primary key
-Unique column names
- No duplicate rows

Question 14

DDL (Data Definition Language

Answer 14

Defines the structure of the database.

Question 15

DQL (Data Query Language)

Answer 15

Retrieves data from the database.

Question 16

(DML) Data Manipulation Language

Answer 16

manipulates data stored in a database.

Question 17

DCL (Data Control Language)

Answer 17

controls database user access.

Question 18

DTL (manages database transactions)

Answer 18

manages database transactions.

Question 19

Row

Answer 19

unnamed sequence of values

Question 20

Cell

Answer 20

a single column of a single row.

Question 21

Tables must follow these relational rules:

Answer 21

1. Exactly one value per cell.
2. No duplicate column names.
3. No duplicate rows
4. No row order.

Question 22

TINYINT

Answer 22

-1 byte
- Signed range: -128 to 127
- Unsigned range: 0 to 255

Question 23

SMALLINT

Answer 23

• 2 bytes
  -Signed range: -32768 to 32767
  -Unsigned range: 0 to 65535

Question 24

MEDIUMINT

Answer 24

3 bytes

Question 25

INT

Answer 25

4 bytes

Question 26

BIGINT

Answer 26

8 bytes

Question 27

DECIMAL (M,D)

Answer 27

Exact decimal number where M = number of significant digits, D = number of digits after decimal point

Question 28

FLOAT

Answer 28

4 Bytes

Question 29

DOUBLE

Answer 29

8 Bytes

Question 30

join

Answer 30

A SELECT statement that combines data from 2 tables, known as the LEFT Table and RIGHT table, into a single result.

Question 31

TINYINT UNSIGNED

Answer 31

Integer value between 0 and 100.