Question 1

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Accepted Answer

A)  it typically focuses on a single subject area or line of business. 
B)  all the information is historical. 
C)  it uses a web interface. 
D)  all of the information belongs to a single company. 
E)  it is open-source. 
A)  it typically focuses on a single subject area or line of business. 
B)  all the information is historical. 
C)  it uses a web interface. 
D)  all of the information belongs to a single company. 
E)  it is open-source.

Question 2

A data ________ stores current and historical data of potential interest to decision makers throughout the company.

Accepted Answer

A)  warehouse 
B)  mart 
C)  archive 
D)  mine 
E)  center 
A)  warehouse 
B)  mart 
C)  archive 
D)  mine 
E)  center

Question 3

A grouping of characters into a word, a group of words, or a complete number is called a tuple

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security?

Accepted Answer

A)  Referential integrity module 
B)  Data definition diagram 
C)  Entity-relationship diagram 
D)  Relationship dictionary 
E)  Data dictionary 
A)  Referential integrity module 
B)  Data definition diagram 
C)  Entity-relationship diagram 
D)  Relationship dictionary 
E)  Data dictionary

Question 5

As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources.

Accepted Answer

A)  database management system 
B)  relational database 
C)  data warehouse 
D)  data model 
E)  fan management system 
A)  database management system 
B)  relational database 
C)  data warehouse 
D)  data model 
E)  fan management system

Question 6

A schematic of the entire database that describes the relationships in a database is called a(n):

Accepted Answer

A)  data dictionary. 
B)  intersection relationship diagram. 
C)  field key diagram. 
D)  data definition diagram. 
E)  entity-relationship diagram. 
A)  data dictionary. 
B)  intersection relationship diagram. 
C)  field key diagram. 
D)  data definition diagram. 
E)  entity-relationship diagram.

Question 7

Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites?

Accepted Answer

A)  Web usage mining 
B)  Web server mining 
C)  Web structure mining 
D)  Web content mining 
E)  Web protocol mining 
A)  Web usage mining 
B)  Web server mining 
C)  Web structure mining 
D)  Web content mining 
E)  Web protocol mining

Question 8

Links coming out of an online document are a sign of:

Accepted Answer

A)  richness or variety of topics covered. 
B)  popularity. 
C)  data quality. 
D)  data usage. 
E)  marketing. 
A)  richness or variety of topics covered. 
B)  popularity. 
C)  data quality. 
D)  data usage. 
E)  marketing.

Question 9

Data mining is more ________ than OLAP.

Accepted Answer

A)  data-focused 
B)  multidimensional 
C)  query oriented 
D)  discovery driven 
E)  streamlined 
A)  data-focused 
B)  multidimensional 
C)  query oriented 
D)  discovery driven 
E)  streamlined

Question 10

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

Accepted Answer

A)  Two-tiered DBMS 
B)  Pre-digital DBMS 
C)  Open source DBMS 
D)  Hierarchical DBMS 
E)  Relational DBMS 
A)  Two-tiered DBMS 
B)  Pre-digital DBMS 
C)  Open source DBMS 
D)  Hierarchical DBMS 
E)  Relational DBMS

Question 11

In a table for customers, the information about a single customer would reside in a single:

Accepted Answer

A)  field. 
B)  entity. 
C)  column. 
D)  table. 
E)  row. 
A)  field. 
B)  entity. 
C)  column. 
D)  table. 
E)  row.

Question 12

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A)  The entity CUSTOMER with the attribute PRODUCT 
B)  The entity CUSTOMER with the attribute ADDRESS 
C)  The entity PRODUCT with the attribute PURCHASE 
D)  The entity PRODUCT with the attribute CUSTOMER 
E)  The entity ADDRESS with the attribute CUSTOMER 
A)  The entity CUSTOMER with the attribute PRODUCT 
B)  The entity CUSTOMER with the attribute ADDRESS 
C)  The entity PRODUCT with the attribute PURCHASE 
D)  The entity PRODUCT with the attribute CUSTOMER 
E)  The entity ADDRESS with the attribute CUSTOMER

Question 13

In a relational database, the three basic operations used to develop useful sets of data are:

Accepted Answer

A)  select, project, and where. 
B)  select, join, and where. 
C)  select, project, and join. 
D)  select, from, and join. 
E)  who, what, and where. 
A)  select, project, and where. 
B)  select, join, and where. 
C)  select, project, and join. 
D)  select, from, and join. 
E)  who, what, and where.

Question 14

OLAP enables users to view data from different perspectives.

Accepted Answer

A) True 
 B)False

Question 15

Two key services of Hadoop are HDFS and HBase non-relational database.

Accepted Answer

A) True 
 B)False

Question 16

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

Accepted Answer

A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization. 
E)  data repair. 
A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization. 
E)  data repair.

Question 17

Every record in a file must contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 18

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is referred to as:

Accepted Answer

A)  data cleansing. 
B)  data mining. 
C)  an information policy. 
D)  logical database design. 
E)  a data quality audit. 
A)  data cleansing. 
B)  data mining. 
C)  an information policy. 
D)  logical database design. 
E)  a data quality audit.

Question 19

The most basic business database is comprised of:

Accepted Answer

A)  three tables: for suppliers, parts, and sales. 
B)  four tables: for customers, suppliers, parts, and sales. 
C)  four tables: for customers, suppliers, sales, and employees. 
D)  five tables: for customers, employees, suppliers, parts, and sales. 
E)  attributes instead of tables. 
A)  three tables: for suppliers, parts, and sales. 
B)  four tables: for customers, suppliers, parts, and sales. 
C)  four tables: for customers, suppliers, sales, and employees. 
D)  five tables: for customers, employees, suppliers, parts, and sales. 
E)  attributes instead of tables.

Question 20

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Accepted Answer

A) True 
 B)False

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

A data ________ stores current and historical data of potential interest to decision makers throughout the company.

A grouping of characters into a word, a group of words, or a complete number is called a tuple

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security?

As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources.

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites?

Links coming out of an online document are a sign of:

Data mining is more ________ than OLAP.

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

In a table for customers, the information about a single customer would reside in a single:

Which of the following best illustrates the relationship between entities and attributes?

In a relational database, the three basic operations used to develop useful sets of data are:

OLAP enables users to view data from different perspectives.

Two key services of Hadoop are HDFS and HBase non-relational database.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

Every record in a file must contain at least one key field.

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is referred to as:

The most basic business database is comprised of:

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

A data ________ stores current and historical data of potential interest to decision makers throughout the company.

A grouping of characters into a word, a group of words, or a complete number is called a tuple

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security?

As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources.

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites?

Links coming out of an online document are a sign of:

Data mining is more ________ than OLAP.

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

In a table for customers, the information about a single customer would reside in a single:

Which of the following best illustrates the relationship between entities and attributes?

In a relational database, the three basic operations used to develop useful sets of data are:

OLAP enables users to view data from different perspectives.

Two key services of Hadoop are HDFS and HBase non-relational database.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

Every record in a file must contain at least one key field.

Rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is referred to as:

The most basic business database is comprised of:

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters