Exam 11: Databases

____ refers to the number of associations that can exist between two record types.

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.

If a single data management tool can be used to maintain many different files and databases,it must support data ____.

The term ____________________ refers to software that is designed to manage data stored in a database.

From a user perspective,the data ____________________ determines the way that data can be manipulated.

A record that contains data is referred to as a record ____.

Thieves who gain access to a(n) encrypteddatabase cannot make sense of the data._________________________

____ is the SQL command used to introduce a brand-new database or table.

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

The following is NOT a guideline for creating a template for reports: ____

A(n)____ copies data out of a software package,such as spreadsheet software,and into a database.

In some business environments, the database designer also enters the data into the database. In Kate’s large banking firm, however, the actual database entries are not made by the database designers. After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number. -Kate would also like to request that the database developer ensure that the data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields.What should she ask be applied to those fields?

In the broadest definition,a(n)____ is a collection of information.

-In the query illustrated in the accompanying figure,the SELECT command specifies the fields that should appear._________________________

In a(n) relational database,relationships are specified by joining common data stored in the fields of records in different tables._________________________

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Much like an accordion,expanding to fit the data being entered

The hyperlink data type is used to store data that can have one of two values.

A(n)____________________ limits access to systems such as computer databases.

In some business environments, the database designer also enters the data into the database. In Kate’s large banking firm, however, the actual database entries are not made by the database designers. After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number. -To prevent inconsistent formatting,Kate needs to ask the database designer to make the database automatically reject any entry that was typed in the wrong format.What should Kate request be applied to the telephone number field to solve this problem?