CIS 204 Chapter 11 Quiz – Flashcards
Unlock all answers in this set
Unlock answersquestion
Data staging consists of all of the following steps, EXCEPT
answer
mining the data
question
Data ____ ensures that the data contained in a database is accurate and reliable
answer
integrity
question
Which of the following is NOT a likely primary key?
answer
Date of birth
question
____ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table
answer
Referential Integrity
question
A gas purchase made with a credit card at the pump would be entered into which type of database system?
answer
Transaction-processing system
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
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
question
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ____ field
answer
long text
question
Which of the following database systems uses artificial intelligence?
answer
knowledge-based system
question
A ___ check would be used to restrict the fines for speeding violations from $50 to $250
answer
range
question
In a database, the term ____ is synonymous with a category of information
answer
field
question
___ databases are the most frequently used electronic databases
answer
relational
question
a ___ displays a subset of data from a table (or tables) based on the specified criteria
answer
select query
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
question
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ____ data
answer
unstructured
question
A(n) ____ is designed to improve communications and help employees complete their routine tasks
answer
office support system (OSS)
question
You can set a _____, which is automatically displayed in a field unless the user enters something different
answer
default value
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
question
Which of the following is NOT considered a step in data staging?
answer
inputting data not stored in source databases
question
Which is NOT a component of a database that describes how data is stored?
answer
Report
question
A(n) ___ check determines whether a required field such as LastName was filled in
answer
completeness
question
A(n) ___ is a way of retrieving information from one or more tables that defines a particular subset of data
answer
query
question
A ____ is a group of related data that can be stored, sorted, organized, and queried
answer
database
question
____ involves putting data into an electronic file in a format that another application can recognize
answer
Exporting
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
question
The type of database that is best for organizing unstructured data such as video and audio is
answer
object-oriented
question
____ is used to ensure that data is organized most efficiently
answer
Normalization
question
_____ is the branch of computer science that attempts to create computers that think like humans
answer
Artificial Intelligence
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
question
In a database, a group of related records is referred to as a(n) ___
answer
table
question
You would use a ____ to temporarily display records of residents of the city of Boston
answer
filter
