Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

What are the similarities and differences between a data warehouse and a data mart?

Accepted Answer

A data warehouse stores current and hist

Question 3

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 4

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 5

Implementing a web interface for a database requires changes to the database itself.

Accepted Answer

A) True 
 B)False

Question 6

Data mining is a tool for allowing users to:

Accepted Answer

A)  quickly compare transaction data gathered over many years. 
B)  perform multidimensional data analysis. 
C)  obtain online answers to ad hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  find hidden relationships in data. 
A)  quickly compare transaction data gathered over many years. 
B)  perform multidimensional data analysis. 
C)  obtain online answers to ad hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  find hidden relationships in data.

Question 7

OLAP is a tool that enables users to:

Accepted Answer

A)  obtain online answers to ad hoc questions in a rapid amount of time. 
B)  view both logical and physical views of data. 
C)  quickly diagram data relationships. 
D)  normalize data. 
E)  find hidden patterns in large databases. 
A)  obtain online answers to ad hoc questions in a rapid amount of time. 
B)  view both logical and physical views of data. 
C)  quickly diagram data relationships. 
D)  normalize data. 
E)  find hidden patterns in large databases.

Question 8

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

Accepted Answer

A)  batch processing 
B)  data redundancy 
C)  data independence 
D)  online processing 
E)  data freedom 
A)  batch processing 
B)  data redundancy 
C)  data independence 
D)  online processing 
E)  data freedom

Question 9

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

Accepted Answer

A)  in two short marks. 
B)  in one short mark. 
C)  with a crow's foot. 
D)  with a crow's foot preceded by a short mark. 
E)  in three short marks. 
A)  in two short marks. 
B)  in one short mark. 
C)  with a crow's foot. 
D)  with a crow's foot preceded by a short mark. 
E)  in three short marks.

Question 10

Which of the following enables users to view the same data in different ways using multiple dimensions?

Accepted Answer

A)  Hadoop 
B)  SQL 
C)  Big data 
D)  Data mining 
E)  OLAP 
A)  Hadoop 
B)  SQL 
C)  Big data 
D)  Data mining 
E)  OLAP

Question 11

Web mining is the discovery of useful patterns on the web.

Accepted Answer

A) True 
 B)False

Question 12

List at least two ways that a business's data can become redundant or inconsistent.

Accepted Answer

Data redundancy and inconsistency can oc

Question 13

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 14

A foreign key is a field that links to a separate table.

Accepted Answer

A) True 
 B)False

Question 15

In linking databases to the web, the role of the application server is to host the DBMS.

Accepted Answer

A) True 
 B)False

Question 16

Common Gateway Interface is a specification for processing data on a web server.

Accepted Answer

A) True 
 B)False

Question 17

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships:

Question 18

Which of the following allows users to add, change, delete, or retrieve data in a database?

Accepted Answer

A)  Attribute generation 
B)  Report generation tools 
C)  Data dictionary 
D)  Query wizard tool 
E)  Data manipulation language 
A)  Attribute generation 
B)  Report generation tools 
C)  Data dictionary 
D)  Query wizard tool 
E)  Data manipulation language

Question 19

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

A) True 
 B)False

Question 20

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.

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

What are the similarities and differences between a data warehouse and a data mart?

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?

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

Implementing a web interface for a database requires changes to the database itself.

Data mining is a tool for allowing users to:

OLAP is a tool that enables users to:

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

Which of the following enables users to view the same data in different ways using multiple dimensions?

Web mining is the discovery of useful patterns on the web.

List at least two ways that a business's data can become redundant or inconsistent.

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?

A foreign key is a field that links to a separate table.

In linking databases to the web, the role of the application server is to host the DBMS.

Common Gateway Interface is a specification for processing data on a web server.

What types of relationships are possible in a relational database? Describe and give an example of each.

Which of the following allows users to add, change, delete, or retrieve data in a database?

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

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

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:

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

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

What are the similarities and differences between a data warehouse and a data mart?

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?

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

Implementing a web interface for a database requires changes to the database itself.

Data mining is a tool for allowing users to:

OLAP is a tool that enables users to:

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

Which of the following enables users to view the same data in different ways using multiple dimensions?

Web mining is the discovery of useful patterns on the web.

List at least two ways that a business's data can become redundant or inconsistent.

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?

A foreign key is a field that links to a separate table.

In linking databases to the web, the role of the application server is to host the DBMS.

Common Gateway Interface is a specification for processing data on a web server.

What types of relationships are possible in a relational database? Describe and give an example of each.

Which of the following allows users to add, change, delete, or retrieve data in a database?

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

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

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:

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters