Quiz 1-4 Questions

Linking

If two tables have a many-to-many relationship, you need to define a/an ____________________ table that relates their records.

that doesn't include a value for that column is added to the table

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

One-to-Many

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

each non-key column must depend only on the primary key

To be in the third normal form,

return an error instead of deleting any rows AND delete a row in a primary key table and all related rows in a foreign key table

To enforce referential integrity for a delete operation, an Oracle database can

Table

To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.

Foreign Key

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

third

Typically, most database designers consider a database structure normalized if it's in the ________________________ normal form.

Primary Key

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

Type

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