70 CP102 Chapter 11Quiz Questions
When using SQL, a(n) ________ query is used to extract data from two
or more tables - ✔ ✔ Join
The data in a data warehouse is ________, meaning it does not all
pertain to one period in time - ✔ ✔ Time variant
________ data is information about how users of a company's website
move through the web pages - ✔ ✔ Clickstream
When creating a data warehouse, ________ is the process that extracts
data from source databases, reformats the data, and stores them in the
warehouse - ✔ ✔ Data staging
A(n) ________ is created from a large data business warehouse to
analyze a single component of the business - ✔ ✔ Data mart
A business that updates its records all at once at the end of the
business day uses ________ processing - ✔ ✔ Batch
A(n) ________ report provides a consolidated picture of detailed data
and usually includes some calculation or visual displays of information
and is generated by a MIS - ✔ ✔ Summary
A(n) ________ tries to replicate the decision-making processes of
human experts to solve specific problems - ✔ ✔ Expert system
________ is used to analyze large amounts of data and identify unseen
patterns or trends - ✔ ✔ Data mining
, T/F: Data redundancy ensures that the data contained in the database
is accurate and reliable - ✔ ✔ False
T/F: Small slices of a data mart are called data warehouses - ✔ ✔
False
T/F: A group of related records is called a table - ✔ ✔ True
T/F: 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 - ✔ ✔ True
T/F: When using Access, the text of the Declaration of Independence
would be stored in a short text field - ✔ ✔ False
T/F: Employees' last names would usually make an appropriate primary
key field - ✔ ✔ False
T/F: Normalization means that there are no data entry errors in a
database - ✔ ✔ False
A ________ is a collection of related data that can be stored, sorted,
organized, and queried.
A) database
B) spreadsheet
C) memo
D) macro - ✔ ✔ A) Database
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 ________.
When using SQL, a(n) ________ query is used to extract data from two
or more tables - ✔ ✔ Join
The data in a data warehouse is ________, meaning it does not all
pertain to one period in time - ✔ ✔ Time variant
________ data is information about how users of a company's website
move through the web pages - ✔ ✔ Clickstream
When creating a data warehouse, ________ is the process that extracts
data from source databases, reformats the data, and stores them in the
warehouse - ✔ ✔ Data staging
A(n) ________ is created from a large data business warehouse to
analyze a single component of the business - ✔ ✔ Data mart
A business that updates its records all at once at the end of the
business day uses ________ processing - ✔ ✔ Batch
A(n) ________ report provides a consolidated picture of detailed data
and usually includes some calculation or visual displays of information
and is generated by a MIS - ✔ ✔ Summary
A(n) ________ tries to replicate the decision-making processes of
human experts to solve specific problems - ✔ ✔ Expert system
________ is used to analyze large amounts of data and identify unseen
patterns or trends - ✔ ✔ Data mining
, T/F: Data redundancy ensures that the data contained in the database
is accurate and reliable - ✔ ✔ False
T/F: Small slices of a data mart are called data warehouses - ✔ ✔
False
T/F: A group of related records is called a table - ✔ ✔ True
T/F: 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 - ✔ ✔ True
T/F: When using Access, the text of the Declaration of Independence
would be stored in a short text field - ✔ ✔ False
T/F: Employees' last names would usually make an appropriate primary
key field - ✔ ✔ False
T/F: Normalization means that there are no data entry errors in a
database - ✔ ✔ False
A ________ is a collection of related data that can be stored, sorted,
organized, and queried.
A) database
B) spreadsheet
C) memo
D) macro - ✔ ✔ A) Database
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 ________.
