Chapter 11 TIA

24 July 2022
4.7 (114 reviews)
46 test answers

Unlock all answers in this set

Unlock answers (42)
question
A ________ is a collection of related data that can be stored, sorted, organized, and queried.
answer
database
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
Data ________ means 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
In a database, the term ________ is synonymous with a category of information.
answer
field
question
In a database, a group of related records is referred to as a(n) ________.
answer
table
question
In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
answer
long text
question
You can set a ________, which is automatically displayed in a field unless the user enters something different.
answer
default value
question
Which of the following is a likely primary key in a student information record?
answer
student id number
question
________ is used to ensure that data is organized most efficiently in a database.
answer
normalization
question
________ databases are the most commonly used electronic databases.
answer
relational
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
________ 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
Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.
answer
unstructured
question
Data in a multidimensional database is organized in a ________ format.
answer
cube
question
A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.
answer
range
question
A(n) ________ check determines whether a required field such as LastName was filled in.
answer
completeness
question
A ________ check compares the values of data in two or more fields to see whether those values are reasonable.
answer
consistency
question
You would use a ________ in a database to temporarily display records of residents for the city of Boston.
answer
filter
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 ________ displays a subset of data from a table (or tables) based on the specified criteria.
answer
select query
question
SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.
answer
relational algebra
question
________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.
answer
Exporting
question
A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.
answer
warehouse
question
Data staging consists of all of the following steps, EXCEPT ________.
answer
mining the data
question
Big data analytics is usually associated with ________ services.
answer
data warehouse
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
Siri, the personal assistant application on Apple's iPhone is an example of a ________.
answer
natural language processing (NLP) system
question
________ is the branch of computer science that attempts to create computers that think like humans.
answer
Artificial intelligence
question
Data redundancy ensures that the data contained in the database is accurate and reliable.
answer
F
question
Small slices of a data mart are called data warehouses.
answer
F
question
A group of related records is called a table.
answer
T
question
In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.
answer
T
question
When using Access, the text of the Declaration of Independence would be stored in a short text field.
answer
F
question
Employees' last names would usually make an appropriate primary key field.
answer
F
question
Normalization means that there are no data entry errors in a database.
answer
F
question
In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.
answer
F
question
A database schema defines the name, data type, and length of each field in the database.
answer
T
question
A last name field is an example of a field that should have a default value.
answer
F
question
Most databases can import electronic data from other software applications.
answer
T
question
A filter is limited to extracting data from a single table.
answer
T
question
The information in a data mart spans an entire enterprise.
answer
F
question
Real-time processing means that transactions are updated when they occur.
answer
T
question
A summary report generated by a MIS provides a list of the transactions that occurred during a specified time period.
answer
F
question
Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.
answer
T