Question 1

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.E) A) and D)
F) None of the above

Question 2

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 3

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 securityE) None of the above
F) All of the above

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.E) A) and B)
F) B) and C)

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.E) A) and B)
F) C) and D)

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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)   HadoopE) B) and C)
F) A) and B)

Question 10

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.E) B) and D)
F) A) and B)

Question 11

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.E) A) and B)
F) A) and C)

Question 12

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.E) A) and B)
F) A) and C)

Question 13

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

Question 14

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 15

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

Accepted Answer

referentia...

Question 16

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.E) None of the above
F) A) and D)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 inconsistencyE) B) and D)
F) None of the above

Question 19

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) .E) B) and D)
F) A) and D)

Question 20

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

Exam 6: Databases and Information Management

A data warehouse is composed of

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedreferentia...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The data dictionary serves as an important data management tool by

Correct AnswerverifiedShow Answer

A DBMS makes the

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Big data does not refer to

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The select operation

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A DBMS reduces data redundancy and inconsistency by

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
referentia...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified