Question 1

A database ________ describes a database entity.

Accepted Answer

A) byte 
B) field 
C) record 
D) value 
E) file 
A) byte 
B) field 
C) record 
D) value 
E) file

Question 2

Which of the following occurs when the same attribute in related data files has different values?

Accepted Answer

A) Data redundancy 
B) Data duplication 
C) Data dependence 
D) Data discrepancy 
E) Data inconsistency 
A) Data redundancy 
B) Data duplication 
C) Data dependence 
D) Data discrepancy 
E) Data inconsistency

Question 3

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

Accepted Answer

A) Data administration 
B) Database administration 
C) Information policy administration 
D) Data auditing 
E) Database management 
A) Data administration 
B) Database administration 
C) Information policy administration 
D) Data auditing 
E) Database management

Question 4

A field identified in a table as holding the unique identifier of the table's records is called the:

Accepted Answer

A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) primary entity. 
A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) primary entity.

Question 5

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

Accepted Answer

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

Question 6

A characteristic or quality that describes a particular database entity is called a(n):

Accepted Answer

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

Question 7

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

Product databases could be made availabl

Question 8

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

Data mining is one of the data analysis

Question 9

You can use OLAP to perform multidimensional data analysis.

Accepted Answer

A) True 
 B)False

Question 10

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Accepted Answer

The select operation creates a subset co

Question 11

In a relational database,a record is referred to in technical terms as a(n):

Accepted Answer

A) tuple. 
B) table. 
C) entity. 
D) field. 
E) key. 
A) tuple. 
B) table. 
C) entity. 
D) field. 
E) key.

Question 12

You can manipulate data on a web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 13

A record is a group of related fields.

Accepted Answer

A) True 
 B)False

Question 14

All of the following are technologies used to analyze and manage big data except:

Accepted Answer

A) cloud computing. 
B) noSQL. 
C) in-memory computing. 
D) analytic platforms. 
E) Hadoop. 
A) cloud computing. 
B) noSQL. 
C) in-memory computing. 
D) analytic platforms. 
E) Hadoop.

Question 15

A(n)________ represent data as two-dimensional tables.

Accepted Answer

A) non-relational DBMS 
B) mobile DBMS 
C) relational DBMS 
D) hierarchical DBMS 
E) object-oriented DBMS 
A) non-relational DBMS 
B) mobile DBMS 
C) relational DBMS 
D) hierarchical DBMS 
E) object-oriented DBMS

Question 16

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

A) True 
 B)False

Question 17

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. 
E) creates a subset consisting of rows in a table. 
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. 
E) creates a subset consisting of rows in a table.

Question 18

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

Accepted Answer

The first step is to perform a data qual

Question 19

List three ways that a business's data can become redundant or inconsistent.

Accepted Answer

Data redundancy and inconsistency can oc

Question 20

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

A) True 
 B)False

A database ________ describes a database entity.

Which of the following occurs when the same attribute in related data files has different values?

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

A field identified in a table as holding the unique identifier of the table's records is called the:

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

A characteristic or quality that describes a particular database entity is called a(n):

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

You can use OLAP to perform multidimensional data analysis.

Identify and describe three basic operations used to extract useful sets of data from a relational database.

In a relational database,a record is referred to in technical terms as a(n):

You can manipulate data on a web server by using a CGI script.

A record is a group of related fields.

All of the following are technologies used to analyze and manage big data except:

A(n)________ represent data as two-dimensional tables.

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

The join operation:

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

List three ways that a business's data can become redundant or inconsistent.

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

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 and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence:

A database ________ describes a database entity.

Which of the following occurs when the same attribute in related data files has different values?

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

A field identified in a table as holding the unique identifier of the table's records is called the:

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

A characteristic or quality that describes a particular database entity is called a(n):

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

You can use OLAP to perform multidimensional data analysis.

Identify and describe three basic operations used to extract useful sets of data from a relational database.

In a relational database,a record is referred to in technical terms as a(n):

You can manipulate data on a web server by using a CGI script.

A record is a group of related fields.

All of the following are technologies used to analyze and manage big data except:

A(n)________ represent data as two-dimensional tables.

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

The join operation:

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

List three ways that a business's data can become redundant or inconsistent.

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

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 and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters