Question 1

___________________ is a language, which supports complete database creation, maintenance and usage, and is the DDL and DML of most relational databases.

Accepted Answer

The answer of ___________________ is a language, which supports complete...

Question 2

SQL allows you to __________________ two or more tables across a common field (a primary and a foreign key).

Accepted Answer

The answer of SQL allows you to __________________ two or...

Question 3

________________________________ are programs embedded within a table that are automatically invoked by updates to another table.

Accepted Answer

The answer of ________________________________ are programs embedded within a table...

Question 4

________________________________ are programs embedded within a table that can be called from an application program.

Accepted Answer

The answer of ________________________________ are programs embedded within a table...

Question 5

Both triggers and stored procedures are reusable because they are stored with the tables themselves as_____________________.

Accepted Answer

The answer of Both triggers and stored procedures are reusable...

Question 6

A good data model is_______________________. As a general rule, the data attributes that describe an entity should describe only that entity.

Accepted Answer

The answer of A good data model is_______________________. As a...

Question 7

A good data model is essentially___________________________. This means that each data attribute, other than foreign keys, describes at most one entity.

Accepted Answer

The answer of A good data model is essentially___________________________. This...

Question 8

___________ restrict the portion of the database that may be used or accessed by different users and programs.

Accepted Answer

The answer of ___________ restrict the portion of the database...

Quiz 14: Database Design