CS 11

25 July 2022
4.7 (114 reviews)
25 test answers

Unlock all answers in this set

Unlock answers (21)
question
A ________ check compares the values of data in two or more fields to see whether those values are reasonable.
answer
Consistnecy
question
A ________ check would be used to restrict the fines for speeding violations from $50 to $250.
answer
Range
question
A ________ displays a subset of data from a table (or tables) based on the specified criteria
answer
Select Query
question
A ________ is a group of related data that can be stored, sorted, organized, and queried.
answer
Database
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
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
A(n) ________ check determines whether a required field such as LastName was filled in.
answer
Completeness
question
(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.
answer
Query
question
Data ________ ensures that the data contained in a database is accurate and reliable.
answer
integrity
question
Data ________ helps to ensure data integrity by maintaining information in only one place.
answer
Centralization
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 Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
answer
long text
question
In a database, a group of related records is referred to as a(n) ________.
answer
table
question
In a database, the term ________ is synonymous with a category of information.
answer
field
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
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
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.
answer
unconstructed
question
SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations
answer
relational algebra
question
The Siri personal assistant application on Apple's iPhone 5s is an example of a ________.
answer
natural language processing NLP
question
Which of the following is NOT a likely primary key?
answer
Date of birth
question
You would use a ________ to temporarily display records of residents of the city of Boston.
answer
Filter
question
________ databases are the most frequently used electronic databases.
answer
Relational
question
________ involves putting data into an electronic file in a format that another application can recognize.
answer
Exporting
question
________ is the branch of computer science that attempts to create computers that think like humans.
answer
Artificial intelligence
question
________ is used to ensure that data is organized most efficiently.
answer
Normalization