Exam 4: The Relational Model 3: Advanced Topics

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

In Access,many macro actions require additional information,called _____ to complete the action.

To create a trigger in MySQL,use the _____ command.

When you create an index whose key has a single field,you have created what is called a primary index.

The CHECK clause can be included in the ____ command.

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.

____________________ is the rule that no field that is part of the primary key may accept null values.

Explain what is meant by a null value. Is a null value the same as a value of zero?

To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.

A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT,UPDATE,or DELETE command.