Question 1

Most back-end databases are able to interpret HTML commands.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

A one-to-one 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 topped by a short mark. 
A) in two short marks. 
B) in one short mark. 
C) with a crow's foot. 
D) with a crow's foot topped by a short mark.

Question 4

The select operation:

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meet stated criteria. 
A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meet stated criteria.

Question 5

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A) intersection relations 
B) referential integrity rules 
C) entity-relationship diagrams 
D) foreign keys 
A) intersection relations 
B) referential integrity rules 
C) entity-relationship diagrams 
D) foreign keys

Question 6

Data mining is more ________ than OLAP.

Accepted Answer

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

Question 7

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. 
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.

Question 8

The logical view of a database:

Accepted Answer

A) shows how data are organized and structured on the storage media. 
B) presents an entry screen to the user. 
C) allows the creation of supplementary reports. 
D) presents data as they would be perceived by end users. 
A) shows how data are organized and structured on the storage media. 
B) presents an entry screen to the user. 
C) allows the creation of supplementary reports. 
D) presents data as they would be perceived by end users.

Question 9

Which of the following is not a typical feature of DBMS?

Accepted Answer

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

Question 10

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 
A) warehouse 
B) mart 
C) archive 
D) mine

Question 11

All of the following are tools or technologies for extracting information from unstructured data sets except:

Accepted Answer

A) sentiment analysis software. 
B) SQL queries. 
C) Hadoop. 
D) Non-relational DBMS. 
A) sentiment analysis software. 
B) SQL queries. 
C) Hadoop. 
D) Non-relational DBMS.

Question 12

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 13

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

Accepted Answer

A) DSS. 
B) business intelligence. 
C) OLAP. 
D) data mining. 
A) DSS. 
B) business intelligence. 
C) OLAP. 
D) data mining.

Question 14

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. 
A) select, project, and where. 
B) select, join, and where. 
C) select, project, and join. 
D) select, from, and join.

Question 15

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

Accepted Answer

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

Question 16

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

Accepted Answer

Data accuracy when the new data is input

Question 17

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. 
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.

Question 18

A characteristic or quality describing an entity is called a(n):

Accepted Answer

A) field. 
B) tuple. 
C) key field. 
D) attribute. 
A) field. 
B) tuple. 
C) key field. 
D) attribute.

Question 19

A physical view shows data as it is organized on the storage media.

Accepted Answer

A) True 
 B)False

Question 20

What is the first step you should take in managing data for a firm?

Accepted Answer

A) Identify the data needed to run the business 
B) Cleanse the data before importing it to any database 
C) Normalize the data before importing to a database 
D) Audit your data quality 
A) Identify the data needed to run the business 
B) Cleanse the data before importing it to any database 
C) Normalize the data before importing to a database 
D) Audit your data quality

Most back-end databases are able to interpret HTML commands.

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

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

The select operation:

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Data mining is more ________ than OLAP.

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

The logical view of a database:

Which of the following is not a typical feature of DBMS?

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

All of the following are tools or technologies for extracting information from unstructured data sets except:

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

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

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

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

The most basic business database is comprised of:

A characteristic or quality describing an entity is called a(n):

A physical view shows data as it is organized on the storage media.

What is the first step you should take in managing data for a firm?

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

Most back-end databases are able to interpret HTML commands.

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

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

The select operation:

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Data mining is more ________ than OLAP.

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

The logical view of a database:

Which of the following is not a typical feature of DBMS?

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

All of the following are tools or technologies for extracting information from unstructured data sets except:

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

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

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

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

The most basic business database is comprised of:

A characteristic or quality describing an entity is called a(n):

A physical view shows data as it is organized on the storage media.

What is the first step you should take in managing data for a firm?

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