File Chap 6 Part 2

Question 1

Unique identifier in each table, Transaction_ID in Transaction Table; CustomerID in Customer Table

Answer 1

Primary Keys

Question 2

Exist to create relationships or links between two

are not required in every table
BUT – if they are present they must match their related Primary Keys. (referential integrity)

Answer 2

Foreign Keys

Question 3

Changes a characteristic of an existing table, such as adding a new column.

DDL

Answer 3

ALTER

Question 4

Adds a new, empty table to the database.

DDL

Answer 4

CREATE

Question 5

Deletes an existing table and all records it contains.

DDL

Answer 5

DROP

Question 6

Deletes all the records contained in an existing table but does not delete the table

DDL

Answer 6

TRUNCATE

Question 7

Adds a new record of data to table.

DML

Answer 7

INSERT

Question 8

Changes the value of an existing field.

DML

Answer 8

UPDATE

Question 9

Removes one or more records from a table.

DML

Answer 9

DELETE

Question 10

The only DQL command. The beginning of all queries written to retrieve data for viewing, copying, or updating

DQL

Answer 10

SELECT