Question 1

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 2

A data warehouse is typically comprised of several smaller data marts.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

referentia

Question 5

Information is __________when it is available to decision makers when it is needed.

Accepted Answer

The answer of Information is __________when it is available to...

Question 6

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Accepted Answer

A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop 
A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop

Question 7

The select operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria.

Question 8

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

A) True 
 B)False

Question 9

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Accepted Answer

A)  data normalization 
B)  data accuracy 
C)  data redundancy 
D)  data inconsistency 
A)  data normalization 
B)  data accuracy 
C)  data redundancy 
D)  data inconsistency

Question 10

A DBMS makes the

Accepted Answer

A)  physical database available for different logical views. 
B)  logical database available for different analytical views. 
C)  physical database available for different analytical views. 
D)  logical database available for different physical views. 
A)  physical database available for different logical views. 
B)  logical database available for different analytical views. 
C)  physical database available for different analytical views. 
D)  logical database available for different physical views.

Question 11

Big data does not refer to

Accepted Answer

A)  datasets with fewer than a billion records. 
B)  datasets with unstructured data. 
C)  machine-generated data (i.e. from sensors). 
D)  data created by social media (i.e. tweets, Facebook Likes). 
A)  datasets with fewer than a billion records. 
B)  datasets with unstructured data. 
C)  machine-generated data (i.e. from sensors). 
D)  data created by social media (i.e. tweets, Facebook Likes).

Question 12

A __________________is a subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users.

Accepted Answer

The answer of A __________________is a subset of a data...

Question 13

The data dictionary serves as an important data management tool by

Accepted Answer

A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form. 
A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form.

Question 14

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

Accepted Answer

The answer of In ________,a data mining tool discovers different...

Question 15

Which of the following is not one of the main problems with a traditional file environment?

Accepted Answer

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

Question 16

A data warehouse is composed of

Accepted Answer

A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data. 
A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data.

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

With in-memory computing,a computer's primary memory (RAM)is used for processing.

Accepted Answer

A) True 
 B)False

Question 20

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

A DBMS reduces data redundancy and inconsistency by

A data warehouse is typically comprised of several smaller data marts.

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

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

Information is __________when it is available to decision makers when it is needed.

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

The select operation

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

A DBMS makes the

Big data does not refer to

A __________________is a subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users.

The data dictionary serves as an important data management tool by

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

Which of the following is not one of the main problems with a traditional file environment?

A data warehouse is composed of

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

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

With in-memory computing,a computer's primary memory (RAM)is used for processing.

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

Information Systems in Business Today

How Businesses Use Information Systems

Information Systems organizations and Strategy

Social ethical and Legal Issues in the Digital Firm

It Infrastructure and Emerging Technologies

Telecommunications the Internet and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management business Value and Managing Change

Managing Global Systems

Filters

Exam 6: Databases and Information Management

A DBMS reduces data redundancy and inconsistency by

A data warehouse is typically comprised of several smaller data marts.

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

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

Information is __________when it is available to decision makers when it is needed.

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

The select operation

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

A DBMS makes the

Big data does not refer to

A __________________is a subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users.

The data dictionary serves as an important data management tool by

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

Which of the following is not one of the main problems with a traditional file environment?

A data warehouse is composed of

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

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

With in-memory computing,a computer's primary memory (RAM)is used for processing.

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

Information Systems in Business Today

How Businesses Use Information Systems

Information Systems organizations and Strategy

Social ethical and Legal Issues in the Digital Firm

It Infrastructure and Emerging Technologies

Telecommunications the Internet and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management business Value and Managing Change

Managing Global Systems

Filters