FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Behind the Scenes: Databases and Information Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

Matching

Review LaterAdd Note

Review Later

Match the following data checks to their definition:

Premises

Responses

completeness

confirms that only numbers are entered into a field

numeric

ensures data entered into the database fall within a certain set of values

consistency

ensures that all required fields have data entered into them

alphabetic

confirms that only textual characters are entered into a field

range

compares values in two or more fields to see whether the values are reasonable

Premises

completeness

numeric

consistency

alphabetic

range

Responses

confirms that only numbers are entered into a field

ensures data entered into the database fall within a certain set of values

ensures that all required fields have data entered into them

confirms that only textual characters are entered into a field

compares values in two or more fields to see whether the values are reasonable

Show Answer

Correct Answer

Premises

Responses

completeness

numeric

consistency

alphabetic

range

Premises

completeness

numeric

consistency

alphabetic

range

Responses

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.

A) validation rule
B) field constraint
C) enquiry
D) query

E) B) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 63

Multiple Choice

Review LaterAdd Note

In a database, a text field capable of holding complete paragraphs has a ________ data type.

The information in a data mart spans an entire enterprise.

A large-scale collection of data that consolidates data from various operational systems is known as a(n) ________.

Primary keys must be numbers that already represent something (like a telephone number.)

A business that updates its records all at once at the end of the business day uses ________ processing.

________ is the process of ensuring that the data entered into a field meets specified guidelines.

A(n) ________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS.

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

________ systems are used mostly at the executive level to improve business decision making with databases and other fact-based support systems.

In large organizations, a database administrator is responsible for designing, constructing, and maintaining the company's databases.

Small slices of a data mart are called data warehouses.

A street address field is an example of a field that should have a default value.

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

In Microsoft Access, when you have the field name FirstName display as First Name, you are changing what field property?

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

Match each of the following terms to its definition:

________ is used to analyze large amounts of data and identify unseen patterns or trends.