SQL - Ch. 1, Pretest/Quiz

4. To relate one table to another, a/an _______________________ in one table is used to point to the primary key in another table.

Foreign Key

1. The three main hardware components of a client/server system are the clients, the server, and the

Network

5. The most common type of relationship between two tables is a/an _______________________ relationship.

One to many

10. Which of the following are types of database relationships?

One-to-one One to many Many to many

3. A/An _______________________ uniquely identifies each row in a table.

Primary Key

6. When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.

Type

9. Which of the following recommendations won't improve the readability of your SQL statements?

Avoid comments to describe what each statement does

8. If you define a column with a default value, that value is used whenever a row

Doesn't include value from column is added to the table

7. A/An ____________________________ diagram can be used to show how the tables in a database are defined and related.

E-R

2. A relational database consists of one or more

Tables