Exam 11: Behind the Scenes: Databases and Information Systems

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags
Match each of the following terms to its definition:
1) field
a group of related fields
5)primary key
a category of information in a database
4)table
a collection of related data that can be stored,sorted,organized,and queried
Correct Answer:
Verified
Premises:
Responses:
1) field
a group of related fields
5)primary key
a category of information in a database
4)table
a collection of related data that can be stored,sorted,organized,and queried
2)database
a group of related records
3)record
a field that has a value unique to each record
Free
(Matching)
4.8/5
(29)
Correct Answer:
Verified

Real-time processing means that transactions are updated when they occur.

Free
(True/False)
4.9/5
(43)
Correct Answer:
Verified

True

A summary report provides a list of the transactions that occurred during a specified time period.

Free
(True/False)
4.8/5
(40)
Correct Answer:
Verified

False

A ________ is a group of related data that can be stored, sorted, organized, and queried.

(Multiple Choice)
4.7/5
(41)

A ________ is created from a large data business warehouse to analyze a single component of the business.

(Short Answer)
4.9/5
(33)

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

(Multiple Choice)
4.7/5
(35)

A group of related records is called a(n) ________.

(Short Answer)
4.8/5
(35)

In a database, the term ________ is synonymous with a category of information.

(Multiple Choice)
4.8/5
(35)

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

(Multiple Choice)
4.7/5
(28)

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.

(Multiple Choice)
4.8/5
(26)

A large data mart might require a database administrator to design, construct, and maintain it.

(True/False)
4.8/5
(32)

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

(Short Answer)
4.9/5
(35)
Match the following data checks to their definition:
3)completeness
ensures data entered into the database fall within a certain set of values
5)range
ensures that all required fields have data entered into them
1)alphabetic
confirms that only numbers are entered into a field
Correct Answer:
Verified
Premises:
Responses:
3)completeness
ensures data entered into the database fall within a certain set of values
5)range
ensures that all required fields have data entered into them
1)alphabetic
confirms that only numbers are entered into a field
4)consistency
confirms that only textual characters are entered into a field
2)numeric
compares values in two or more fields to see whether the values are reasonable
(Matching)
4.9/5
(34)

A(n) ________ is designed to improve communications and help employees complete their routine tasks.

(Multiple Choice)
4.7/5
(36)

A field ________ is a property that must be met before an entry can be accepted into the field.

(Short Answer)
4.9/5
(27)
Match each of the following terms to its definition:
4)real-time processing
organizes data into various tables based on logical groupings
5)data dictionary
large-scale repository of data
3)relational database
transaction data that are processed all at once
Correct Answer:
Verified
Premises:
Responses:
4)real-time processing
organizes data into various tables based on logical groupings
5)data dictionary
large-scale repository of data
3)relational database
transaction data that are processed all at once
2)batch processing
when a database is queried and updated as a transaction is taking place
1)data warehouse
defines the name, data type, and length of each field in a database
(Matching)
4.9/5
(26)

Data that describe other data are called________.

(Short Answer)
4.9/5
(31)

________ databases are the most frequently used electronic databases.

(Multiple Choice)
4.8/5
(37)

Employees' last names would usually make an appropriate primary-key field.

(True/False)
4.7/5
(42)

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.

(Multiple Choice)
4.9/5
(33)
Showing 1 - 20 of 75
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)