CIS 204 Chapter 11 Quiz – Flashcards
31 test answers
Unlock all answers in this set
Unlock answers 31question
A gas purchase made with a credit card at the pump would be entered into which type of database system?
answer
Transaction-processing system
Unlock the answer
question
In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ___ processing
answer
real-time
Unlock the answer
question
A data ____ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place
answer
warehouse
Unlock the answer
question
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ____ field
answer
long text
Unlock the answer
question
Which of the following database systems uses artificial intelligence?
answer
knowledge-based system
Unlock the answer
question
A ___ check would be used to restrict the fines for speeding violations from $50 to $250
answer
range
Unlock the answer
question
In a database, the term ____ is synonymous with a category of information
answer
field
Unlock the answer
question
___ databases are the most frequently used electronic databases
answer
relational
Unlock the answer
question
a ___ displays a subset of data from a table (or tables) based on the specified criteria
answer
select query
Unlock the answer
question
a ____ relationship indicates that for each record in a table, there is only a single corresponding record in a related table
answer
one-to-one
Unlock the answer
question
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ____ data
answer
unstructured
Unlock the answer
question
A(n) ____ is designed to improve communications and help employees complete their routine tasks
answer
office support system (OSS)
Unlock the answer
question
You can set a _____, which is automatically displayed in a field unless the user enters something different
answer
default value
Unlock the answer
question
Management information systems (MIS) provide reports called ____ reports, which show conditions that are unusual or need attention from users of the system
answer
exception
Unlock the answer
question
Which of the following is NOT considered a step in data staging?
answer
inputting data not stored in source databases
Unlock the answer
question
Which is NOT a component of a database that describes how data is stored?
answer
Report
Unlock the answer
question
A(n) ___ check determines whether a required field such as LastName was filled in
answer
completeness
Unlock the answer
question
A(n) ___ is a way of retrieving information from one or more tables that defines a particular subset of data
answer
query
Unlock the answer
question
A ____ is a group of related data that can be stored, sorted, organized, and queried
answer
database
Unlock the answer
question
____ involves putting data into an electronic file in a format that another application can recognize
answer
Exporting
Unlock the answer
question
When is it sufficient to use a list to organize data?
answer
When the data is simple and can be organized in one table
Unlock the answer
question
The type of database that is best for organizing unstructured data such as video and audio is
answer
object-oriented
Unlock the answer
question
____ is used to ensure that data is organized most efficiently
answer
Normalization
Unlock the answer
question
_____ is the branch of computer science that attempts to create computers that think like humans
answer
Artificial Intelligence
Unlock the answer
question
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 ____
answer
redundancy
Unlock the answer
question
In a database, a group of related records is referred to as a(n) ___
answer
table
Unlock the answer
question
You would use a ____ to temporarily display records of residents of the city of Boston
answer
filter
Unlock the answer
