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

CREATES, ALTERS, and DROPS tables

Question 15

DQL (Data Query Language)

Answer 15

SELECTS data from table

Question 16

(DML) Data Manipulation Language

Answer 16

INSERTS, UPDATES, and DELETES data in a table.

Question 17

DCL (Data Control Language)

Answer 17

grants and revokes permissions to and from users.

Question 18

DTL (manages database transactions)

Answer 18

commits data to a database, ROLLS BACK from a database, and creates savepoints.

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.

Question 32

Data Definition Language (DDL)

Answer 32

CREATES, ALTERS, and DROP tables

Question 33

Data Query Language (DQL)

Answer 33

SELECTS data from the database

Question 34

Data Manipulation Language (DML)

Answer 34

INSERTS, UPDATES and DELETES data in a table

Question 35

Data Control Language (DCL)

Answer 35

grants and revokes permissions to and from users.

Question 36

DTL

Answer 36

commits data to a database, ROLLS BACK data from a database and creates savepoints.