Exam 11: Databases

Sorted tables typically produce slower queries and updates than unsorted tables.

Which of the following designates that records meet one criterion or the other, but not both?

XForms, an alternative to HTML forms, offer more flexibility and interface with XML documents.

A database ____ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.

What is a computed field?

How can a database designer prevent people from entering inaccurate data?

If a name field contains an entire name, it is difficult to individually manipulate the first name, last name, and middle initial.

What makes a good database interface?

Database tables should be indexed by any field or fields that are commonly used as search fields.

A technique called ____ Web publishing is a simple way to display the data in a database by converting a database report into an HTML document, which can be displayed as a Web page by a browser.

The ____________________ data type stores URLs used to link directly from a database to a Web page.

Critical Thinking questions (Multiple Choice) Where would you store the phone number 617-555-1818 in a database?

The ____________________ data type is used to store dates in a format that allows them to be manipulated.

A field ____ is a picture of how the data is supposed to look when it is entered.

A(n) ____ routine copies data into a database.

Critical Thinking questions (Multiple Choice) You are using the database of a store to search for all store locations outside of New York City. You use the ____ operator in an SQL query.

Which of the following is NOT a Boolean operator?

The relationship shown in the second row of the above figure is a one-to-one relationship.

In database jargon, a(n) relationship is an association between data that is stored in different record types.