IT - Week 13

Data ______ helps to ensure data integrity by maintaining information in only one place.

• flexibility

• redundancy

• mapping

• centralization

______ is used to ensure that data is organized most efficiently in a database.

• Consistency checking

• Validation

• Normalization

• Range checking

______ databases are the most commonly used electronic databases.

• Relational

• Flat-file

• Multidimensional

• Object-oriented

In a database, the term ______ is synonymous with a category of data.

• field

• record

• row

• table

In a database, a group of related records is referred to as a(n) ______.

• memo

• field

• OLE object

• table

A(n) ______ check determines whether a required field such as LastName was filled in.

• completeness

• range

• consistency

• alphabetic

A ______ check compares the values of data in two or more fields to see whether those values are reasonable.

• correctness

• range

• consistency

• numeric

You would use a ______ in an Access database to temporarily display records of residents for the city of Montego Bay.

• sieve

• filter

• validation rule

• field constraint

A ______ displays a subset of data from a table (or tables) based on specified criteria.

• table query

• join query

• select query

• criteria query

SQL uses ______ to extract records from a database by using English-like expressions that have variables and operations.

• Boolean algebra

• relational algebra

• primary keys

• foreign keys