Question 1

A(n)________ organizes data in 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 2

To analyze unstructured data,such as memos and legal cases,you would use text mining tools.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

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 6

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 7

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. 
E) a DBMS. 
A) a data access language. 
B) a data manipulation language. 
C) structured query language. 
D) a data definition language. 
E) a DBMS.

Question 8

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

A) True 
 B)False

Question 9

When the same attribute in related data files has different values,this is called data

Accepted Answer

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

Question 10

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) entity-relationship diagram. 
D) data definition diagram. 
E) data analysis table. 
A) data dictionary. 
B) intersection relationship diagram. 
C) entity-relationship diagram. 
D) data definition diagram. 
E) data analysis table.

A(n)________ organizes data in two-dimensional tables.

To analyze unstructured data,such as memos and legal cases,you would use text mining tools.

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

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

The join operation

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

OLAP is unable to manage and handle queries with very large sets of data.

When the same attribute in related data files has different values,this is called data

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

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(n)________ organizes data in two-dimensional tables.

To analyze unstructured data,such as memos and legal cases,you would use text mining tools.

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

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

The join operation

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

OLAP is unable to manage and handle queries with very large sets of data.

When the same attribute in related data files has different values,this is called data

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

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