Question 1

A DBMS makes the

Accepted Answer

A)  physical database available for different logical views. 
B)  relational database available for different logical views. 
C)  physical database available for different analytic views. 
D)  relational database available for different analytic views. 
E)  logical database available for different analytic views. 
A)  physical database available for different logical views. 
B)  relational database available for different logical views. 
C)  physical database available for different analytic views. 
D)  relational database available for different analytic views. 
E)  logical database available for different analytic views.

Question 2

________ 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)  In-memory 
D)  Clustering 
E)  Classification 
A)  OLAP 
B)  Text mining 
C)  In-memory 
D)  Clustering 
E)  Classification

Question 3

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

Accepted Answer

A) True 
 B)False

Question 4

The traditional file environment does not typically have a problem with

Accepted Answer

A)  data inconsistency. 
B)  program-data independence. 
C)  lack of flexibility in creating ad-hoc reports. 
D)  poor security. 
E)  data sharing. 
A)  data inconsistency. 
B)  program-data independence. 
C)  lack of flexibility in creating ad-hoc reports. 
D)  poor security. 
E)  data sharing.

Question 5

OLAP is a tool for enabling

Accepted Answer

A)  users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B)  users to view both logical and physical views of data. 
C)  programmers to quickly diagram data relationships. 
D)  programmers to normalize data. 
E)  users to quickly generate summary reports. 
A)  users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B)  users to view both logical and physical views of data. 
C)  programmers to quickly diagram data relationships. 
D)  programmers to normalize data. 
E)  users to quickly generate summary reports.

Question 6

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ________ is a characteristic or quality that describes a database entity.

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 8

You have been hired by a national furniture leasing company to implement its first business intelligence systems and infrastructure. To prepare for your initial report, describe the types of data in their firm they can use to support business intelligence and the systems that you will implement to support both their power users and casual users, and explain how these systems or tools work together.

Accepted Answer

All types of data can be used for their

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

Accepted Answer

A) True 
 B)False

Question 11

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Accepted Answer

A) True 
 B)False

Question 12

In place of application server software to allow a Web server to communicate with a back-end database, you can use

Accepted Answer

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

Question 13

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

Accepted Answer

A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data defining. 
E)  optimization. 
A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data defining. 
E)  optimization.

Question 14

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

Accepted Answer

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

Question 15

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Accepted Answer

A) True 
 B)False

Question 16

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 20

The most prominent data manipulation language today is

Accepted Answer

A)  Access. 
B)  DB2. 
C)  SQL. 
D)  Crystal Reports. 
E)  NoSQL. 
A)  Access. 
B)  DB2. 
C)  SQL. 
D)  Crystal Reports. 
E)  NoSQL.

A DBMS makes the

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

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

The traditional file environment does not typically have a problem with

OLAP is a tool for enabling

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

A(n) ________ is a characteristic or quality that describes a database entity.

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

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

In place of application server software to allow a Web server to communicate with a back-end database, you can use

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

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

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

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

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

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

The most prominent data manipulation language today is

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: Enterprise Applications

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

A DBMS makes the

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

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

The traditional file environment does not typically have a problem with

OLAP is a tool for enabling

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

A(n) ________ is a characteristic or quality that describes a database entity.

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

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

In place of application server software to allow a Web server to communicate with a back-end database, you can use

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

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

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

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

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

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

The most prominent data manipulation language today is

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: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters