SQL - Ch. 1, Pretest/Quiz

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

Collaborative-Health Promotion and Maintenance

View Set

Saunders Psychiatric Medications

View Set

Type of Insurance Policies (xcel solutions)

View Set

Molecular Symmetry and Molecular Orbital Theory

View Set

Toddler NCLEX, Toddler, Preschool-passp

View Set

The three main types of rocks and how they are formed

View Set