Deck 5: Data and Knowledge Management

Question 1

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

A) byte
B) field
C) record
D) file
E) database

Answer 1

C

Question 2

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

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.

Answer 2

A

Question 3

Explicit knowledge has which of the following characteristics?

A) objective
B) personal
C) slow
D) costly to transfer
E) ambiguous

Answer 3

A

Question 4

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

Question 5

Normalization is a method for eliminating redundant data elements.

Question 6

A standardized language used to manipulate data is _____.

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

Question 7

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

A) attribute
B) entity
C) primary key
D) object
E) relation

Question 8

The amount of data is increasing exponentially over time.

Question 9

Which of the following are ways for companies to leverage big data to gain value? (check all that apply)
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 making

Question 10

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

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 - database

Question 11

Data dictionaries perform all of the following functions except:

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 updated

Question 12

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

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 navigate

Question 13

The data dictionary defines the format necessary to enter data into a database.

Question 14

Which of the following is an example of explicit knowledge?

A) experiences
B) insights
C) procedural guides
D) expertise
E) skill sets

Question 15

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

Question 16

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

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.

Question 17

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

A) specify an entity
B) create linked lists
C) identify duplicated data
D) uniquely identify a record
E) uniquely identify an attribute

Question 18

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

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

Question 19

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

A) Structured query
B) Normalization
C) Query by example
D) Joining
E) Relational analysis

Question 20

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

Question 21

The most important benefit of knowledge management systems is:

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.