Question 1

Up until about five years ago,most data collected by organizations consisted of transaction data that could easily fit into rows and columns of relational database management systems.

Accepted Answer

A) True 
 B)False

Question 2

An automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security is the

Accepted Answer

A)  data dictionary. 
B)  data definition diagram. 
C)  entity-relationship diagram. 
D)  relationship dictionary.

Question 3

A data mart is a database that stores current and historical data of potential interest to decision makers throughout the company.

Accepted Answer

A) True 
 B)False

Question 4

High-speed ________ use both relational and non-relational tools to analyze large datasets.

Accepted Answer

The answer of High-speed ________ use both relational and non-relational...

Question 5

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

Accepted Answer

The answer of List at least three conditions that contribute...

Question 6

A field identified in a record as holding the unique identifier for that record is called the

Accepted Answer

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

Question 7

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use data mining software that is capable of

Accepted Answer

A)  identifying associations. 
B)  identifying clusters. 
C)  identifying sequences. 
D)  classification.

Question 8

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.

Question 9

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

Accepted Answer

A) True 
 B)False

Question 10

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Accepted Answer

A)  address 
B)  city 
C)  airport code 
D)  state

Question 11

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

Accepted Answer

The answer of Identify and describe three basic operations used...

Question 12

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the rational DBMS.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ view shows data as it is actually organized and structured on the data storage media.

Accepted Answer

The answer of A(n)________ view shows data as it is...

Question 14

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.

Question 15

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.

Question 16

Information is _______________ when it is useful and appropriate for the types of work and decisions that require it.

Accepted Answer

The answer of Information is _______________ when it is useful...

Question 17

Databases record information about general categories of information referred to as ________.

Accepted Answer

The answer of Databases record information about general categories of...

Question 18

A ________________________ is a database that stores current and historical data of potential interest to decision makers throughout the company.

Accepted Answer

A)  data warehouse 
B)  in-memory computing 
C)  analytic platforms 
D)  Data mining

Question 19

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

The answer of List and describe three main capabilities or...

Question 20

A data warehouse may be updated by a legacy system.

Accepted Answer

A) True 
 B)False

Exam 6: Databases and Information Management

Up until about five years ago,most data collected by organizations consisted of transaction data that could easily fit into rows and columns of relational database management systems.

An automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security is the

A data mart is a database that stores current and historical data of potential interest to decision makers throughout the company.

High-speed ________ use both relational and non-relational tools to analyze large datasets.

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

A field identified in a record as holding the unique identifier for that record is called the

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use data mining software that is capable of

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

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

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

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the rational DBMS.

A(n)________ view shows data as it is actually organized and structured on the data storage media.

OLAP is a tool for enabling

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

Information is _______________ when it is useful and appropriate for the types of work and decisions that require it.

Databases record information about general categories of information referred to as ________.

A ________________________ is a database that stores current and historical data of potential interest to decision makers throughout the company.

List and describe three main capabilities or tools of a DBMS.

A data warehouse may be updated by a legacy system.