Question 1

Data cleansing not only corrects errors but also

Accepted Answer

A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  enforces consistency among different sets of data. 
A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  enforces consistency among different sets of data.

Question 2

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

referentia

Question 3

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. 
A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization.

Question 4

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

Data redundancy occurs when different di

Question 5

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

Accepted Answer

A one-to-one relationship occurs when ea

Question 6

Many applications today require databases that can store and retrieve multimedia.

Accepted Answer

A) True 
 B)False

Question 7

An alternative to using application server software for interfacing between a Web server and back-end databases is

Accepted Answer

A)  CGI. 
B)  HTML. 
C)  Java. 
D)  SQL. 
A)  CGI. 
B)  HTML. 
C)  Java. 
D)  SQL.

Question 8

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

Accepted Answer

A) True 
 B)False

Question 9

A DBMS reduces data redundancy and inconsistency by

Accepted Answer

A)  enforcing referential integrity. 
B)  uncoupling program and data. 
C)  utilizing a data dictionary. 
D)  minimizing isolated files with repeated data. 
A)  enforcing referential integrity. 
B)  uncoupling program and data. 
C)  utilizing a data dictionary. 
D)  minimizing isolated files with repeated data.

Question 10

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

Accepted Answer

A)  OODBMS. 
B)  pre-digital DBMS. 
C)  relational DBMS. 
D)  hierarchical DBMS. 
A)  OODBMS. 
B)  pre-digital DBMS. 
C)  relational DBMS. 
D)  hierarchical DBMS.

Question 11

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Accepted Answer

Student answers will vary, but should in

Question 12

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

Accepted Answer

A)  OLAP 
B)  Text mining 
C)  Web mining 
D)  Web content mining 
A)  OLAP 
B)  Text mining 
C)  Web mining 
D)  Web content mining

Question 13

DBMSs typically include report-generating tools in order to

Accepted Answer

A)  retrieve and display data. 
B)  display data in an easier-to-read format. 
C)  display data in graphs. 
D)  perform predictive analysis. 
A)  retrieve and display data. 
B)  display data in an easier-to-read format. 
C)  display data in graphs. 
D)  perform predictive analysis.

Question 14

The specialized language programmers use to add and change data in the database is called

Accepted Answer

A)  a data access language. 
B)  a data manipulation language. 
C)  Structured Query Language. 
D)  a data definition language. 
A)  a data access language. 
B)  a data manipulation language. 
C)  Structured Query Language. 
D)  a data definition language.

Question 15

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

Accepted Answer

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

Question 16

Tools for analyzing data to help users find patterns, relationships, and insights and 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 17

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

Accepted Answer

Product databases could be made availabl

Question 18

OLAP is a key tool of BI.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is NOT a method for performing a data quality audit?

Accepted Answer

A)  surveying entire data files 
B)  surveying samples from data files 
C)  surveying data definition and query files 
D)  surveying end users about their perceptions of data quality 
A)  surveying entire data files 
B)  surveying samples from data files 
C)  surveying data definition and query files 
D)  surveying end users about their perceptions of data quality

Question 20

The join operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments.

Data cleansing not only corrects errors but also

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

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

List at least three conditions that contribute to data redundancy and inconsistency.

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

Many applications today require databases that can store and retrieve multimedia.

An alternative to using application server software for interfacing between a Web server and back-end databases is

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

A DBMS reduces data redundancy and inconsistency by

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

DBMSs typically include report-generating tools in order to

The specialized language programmers use to add and change data in the database is called

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

Tools for analyzing data to help users find patterns, relationships, and insights and make better business decisions are known as

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

OLAP is a key tool of BI.

Which of the following is NOT a method for performing a data quality audit?

The join operation

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

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

Data cleansing not only corrects errors but also

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

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

List at least three conditions that contribute to data redundancy and inconsistency.

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

Many applications today require databases that can store and retrieve multimedia.

An alternative to using application server software for interfacing between a Web server and back-end databases is

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

A DBMS reduces data redundancy and inconsistency by

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

DBMSs typically include report-generating tools in order to

The specialized language programmers use to add and change data in the database is called

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

Tools for analyzing data to help users find patterns, relationships, and insights and make better business decisions are known as

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

OLAP is a key tool of BI.

Which of the following is NOT a method for performing a data quality audit?

The join operation

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters