Exam 3: Tables and Queries in Relational Databases

Match the following Comparison Operators expression with their example: I. =25 II. >25 III. <25 IV. <>25 V. >=25 A. Less than 25 B. Equals 25 C. Does not equal 25 D. Greater than or equal to 25 E. Greater than 25

Which of the following would make a good primary key?

If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator.

Checking the Cascade Delete Related Records checkbox assures that ________.

What is the suggested data type for a street address?

What field property insures that all phone numbers have a consistent look?

What is not one of the six guidelines for designing tables?

When you run a query, it displays in what view?

Storing duplicate data in more than one table is called data ________.

Enforcing referential integrity assures that ________.

The primary key can only be a single field.

"lastName" is an example of ________.

Which logical operator would return the fewest records?

You cannot create a relationship between two tables unless there is at least one ________ key.

The ________ relationship is used when joining two primary keys.

Access requires that common fields be named exactly the same.

To have your table perform mathematical functions automatically you would use a ________ field.

Which option would this wildcard, "H[!oe]" not display?

Although you can link to external data, it is not recommended.

Use the ________ data type if you need to store a True or False value.