Question 1

In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n) :

Accepted Answer

A)   attribute
B)   entity
C)   primary key
D)   object
E)   relationF) All of the above
G) B) and C)

Question 2

Place the following members of the data hierarchy in the correct order:

Accepted Answer

A)   bit - byte - field - record - database - file
B)   bit - field - byte - record - file - database
C)   byte - bit - record - field - database
D)   bit - byte - field - record - file - database
E)   bit - record - field - byte - file - databaseF) C) and D)
G) A) and B)

Question 3

Normalization is a method for eliminating redundant data elements.

Accepted Answer

A) True 
 B)False

Question 4

Explicit knowledge has which of the following characteristics?

Accepted Answer

A)   objective
B)   personal
C)   slow
D)   costly to transfer
E)   ambiguousF) D) and E)
G) B) and C)

Question 5

Which of the following is an example of explicit knowledge?

Accepted Answer

A)   experiences
B)   insights
C)   procedural guides
D)   expertise
E)   skill setsF) B) and D)
G) All of the above

Question 6

The most important benefit of knowledge management systems is:

Accepted Answer

A)   improved customer service.
B)   they make best practices available to employees.
C)   retention of scarce knowledge if employees retire.
D)   improved morale.
E)   more efficient product development.F) D) and E)
G) C) and D) B

Question 7

A(n)  _____ is a logical grouping of related fields.

Accepted Answer

A)   byte
B)   field
C)   record
D)   file
E)   databaseF) All of the above
G) A) and D) C

Question 8

In a database, the primary key field is used to _____.

Accepted Answer

A)   specify an entity
B)   create linked lists
C)   identify duplicated data
D)   uniquely identify a record
E)   uniquely identify an attributeF) B) and E)
G) None of the above

Question 9

It is very difficult to manage data for which of the following reasons?

Accepted Answer

A)   The amount of data stays about the same over time.
B)   Data are scattered throughout organizations.
C)   The decreasing amount of external data needs to be considered.
D)   Data security is easy to maintain.
E)   Data are stored in the same format throughout organizations.F) A) and D)
G) D) and E)

Question 10

The primary key is a field that uniquely and completely identifies a record.

Accepted Answer

A) True 
 B)False

Question 11

The data in a data warehouse have which of the following characteristics?

Accepted Answer

A)   They are organized by subject.
B)   They are coded in different formats.
C)   They are updated in real time.
D)   They are typically retained for a defined, but limited, period of time.
E)   They are organized in a hierarchical structure.F) C) and D)
G) D) and E)

Question 12

Compared to data warehouses, data marts have which one of the following characteristics?

Accepted Answer

A)   cost less
B)   have longer lead time for implementation
C)   have central rather than local control
D)   contain more information
E)   are harder to navigateF) A) and B)
G) C) and D)

Question 13

When various copies of the data agree, this is an example of data integrity.

Accepted Answer

A) True 
 B)False  False

Question 14

_____ is a method for analyzing and reducing a relational database to its most streamlined form.

Accepted Answer

A)   Structured query
B)   Normalization
C)   Query by example
D)   Joining
E)   Relational analysisF) A) and B)
G) C) and E)

Question 15

The amount of data is increasing exponentially over time.

Accepted Answer

A) True 
 B)False

Question 16

A standardized language used to manipulate data is _____.

Accepted Answer

A)   MS-Access
B)   Oracle
C)   query-by-example language
D)   structured query language
E)   data manipulation languageF) A) and C)
G) D) and E)

Question 17

When customers access a Web site and make purchases, they generate _____.

Accepted Answer

A)   tracking cookies
B)   information
C)   clickstream data
D)   Web data
E)   hyperlink dataF) B) and C)
G) A) and E)

Question 18

Data dictionaries perform all of the following functions except:

Accepted Answer

A)   Providing information on each record
B)   Providing information on why attributes are needed in the database
C)   Defining the format necessary to enter data into the database
D)   Providing information on name of attributes
E)   Providing information on how often attributes should be updatedF) B) and E)
G) All of the above

Question 19

Transferring data from the organization's operational databases into its data warehouse is called data reconciliation.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are ways for companies to leverage big data to gain value? (check all that apply)

Accepted Answer

A)   Creating transparencies
B)   Reducing spending on technical initiatives
C)   Segmenting a population to customize actions
D)   Analyzing less data
E)   Providing automated algorithms to support decision makingF) All of the above
G) B) and E)

Exam 5: Data and Knowledge Management

In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n) :

Correct AnswerverifiedShow Answer

Place the following members of the data hierarchy in the correct order:

Correct AnswerverifiedShow Answer

Normalization is a method for eliminating redundant data elements.

Correct AnswerverifiedShow Answer

Explicit knowledge has which of the following characteristics?

Correct AnswerverifiedShow Answer

Which of the following is an example of explicit knowledge?

Correct AnswerverifiedShow Answer

The most important benefit of knowledge management systems is:

Correct AnswerverifiedB

A(n) _____ is a logical grouping of related fields.

Correct AnswerverifiedC

In a database, the primary key field is used to _____.

Correct AnswerverifiedShow Answer

It is very difficult to manage data for which of the following reasons?

Correct AnswerverifiedShow Answer

The primary key is a field that uniquely and completely identifies a record.

Correct AnswerverifiedShow Answer

The data in a data warehouse have which of the following characteristics?

Correct AnswerverifiedShow Answer

Compared to data warehouses, data marts have which one of the following characteristics?

Correct AnswerverifiedShow Answer

When various copies of the data agree, this is an example of data integrity.

Correct AnswerverifiedFalse

_____ is a method for analyzing and reducing a relational database to its most streamlined form.

Correct AnswerverifiedShow Answer

The amount of data is increasing exponentially over time.

Correct AnswerverifiedShow Answer

A standardized language used to manipulate data is _____.

Correct AnswerverifiedShow Answer

When customers access a Web site and make purchases, they generate _____.

Correct AnswerverifiedShow Answer

Data dictionaries perform all of the following functions except:

Correct AnswerverifiedShow Answer

Transferring data from the organization's operational databases into its data warehouse is called data reconciliation.

Correct AnswerverifiedShow Answer

Which of the following are ways for companies to leverage big data to gain value? (check all that apply)

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified