Question 1

A negative value for a student's grade point average is an example of a data integrity problem.

Accepted Answer

A) True 
 B)False  True

Question 2

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

Accepted Answer

A) True 
 B)False  True

Question 3

_____ tell the database management system which records are joined with others in related tables.

Accepted Answer

A)  Primary keys 
B)  Secondary keys 
C)  Common attributes 
D)  Common files 
E)  Common fields 
A)  Primary keys 
B)  Secondary keys 
C)  Common attributes 
D)  Common files 
E)  Common fields A

Question 4

_____ describe the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

Accepted Answer

A)  Transaction data, master data 
B)  Source data, transaction data 
C)  Operational data, master data 
D)  Master data, source data 
E)  Business dimensional data, databases 
A)  Transaction data, master data 
B)  Source data, transaction data 
C)  Operational data, master data 
D)  Master data, source data 
E)  Business dimensional data, databases

Question 5

_____ occurs when various copies of the data agree.

Accepted Answer

A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence 
A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence

Question 6

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 attribute 
A)  specify an entity 
B)  create linked lists 
C)  identify duplicated data 
D)  uniquely identify a record 
E)  uniquely identify an attribute

Question 7

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

Accepted Answer

A) True 
 B)False

Question 8

What are the advantages of a data mart?
Section reference 1: Data Warehousing

Accepted Answer

The answer of What are the advantages of a data...

Question 9

Big Data has three distinct characteristics that distinguish it from traditional data.

Accepted Answer

A) True 
 B)False

Question 10

Organizations are turning to data governance for which of the following reasons?

Accepted Answer

A)  They have too little data. 
B)  They are responding to federal regulations. 
C)  Their data are typically structured. 
D)  Their data are usually located in the organization's databases. 
E)  Data across their organizations are generally consistent. 
A)  They have too little data. 
B)  They are responding to federal regulations. 
C)  Their data are typically structured. 
D)  Their data are usually located in the organization's databases. 
E)  Data across their organizations are generally consistent.

Question 11

_____ occurs when applications cannot access data associated with other applications.

Accepted Answer

A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence 
A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence

Question 12

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Accepted Answer

A) True 
 B)False

Question 13

Refer to IT's About Business 5.4: Hospital Improves Patient Care with Data Warehouse: A single source of all patient data, accessible to multiple hospitals will have the following benefit

Accepted Answer

A)  aid in medical research 
B)  reduce duplicate tests 
C)  eliminate the need for patients to do their own record keeping 
D)  faster transfer of high-volume image data across different locations 
E)  all of the above 
A)  aid in medical research 
B)  reduce duplicate tests 
C)  eliminate the need for patients to do their own record keeping 
D)  faster transfer of high-volume image data across different locations 
E)  all of the above

Question 14

_____ can be exercised to solve a problem, whereas _____ may or may not be able to be exercised to solve a problem.

Accepted Answer

A)  Knowledge, information 
B)  Data, information 
C)  Information, data 
D)  Information, knowledge 
E)  Data, knowledge 
A)  Knowledge, information 
B)  Data, information 
C)  Information, data 
D)  Information, knowledge 
E)  Data, knowledge

Question 15

Describe the relational database model.
Section reference 1: Database Management Systems

Accepted Answer

The answer of Describe the relational database model.
Section reference 1:...

Question 16

_____ provide(s) companies with a single version of the truth for their data.

Accepted Answer

A)  Data warehouses 
B)  Data marts 
C)  Databases 
D)  Master data management 
E)  Enterprise information management 
A)  Data warehouses 
B)  Data marts 
C)  Databases 
D)  Master data management 
E)  Enterprise information management

Question 17

Why is data governance so important for organizations?
Section reference 1: Data Governance

Accepted Answer

The answer of Why is data governance so important for...

Question 18

Data dictionaries provide which of the following advantages to the organization?

Accepted Answer

A)  They reduce data inconsistency. 
B)  They enable faster program development. 
C)  They make it easier to modify data and information. 
D)  Only B and C 
E)  All of the above 
A)  They reduce data inconsistency. 
B)  They enable faster program development. 
C)  They make it easier to modify data and information. 
D)  Only B and C 
E)  All of the above

Question 19

Data rot refers to the quality of the data itself.

Accepted Answer

A) True 
 B)False

Question 20

Discuss the advantages of the database approach.
Section reference 1: The Database Approach

Accepted Answer

The answer of Discuss the advantages of the database approach.
Section...

A negative value for a student's grade point average is an example of a data integrity problem.

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

_____ tell the database management system which records are joined with others in related tables.

_ describe the activities of the business, whereas _ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

_____ occurs when various copies of the data agree.

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

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

What are the advantages of a data mart? Section reference 1: Data Warehousing

Big Data has three distinct characteristics that distinguish it from traditional data.

Organizations are turning to data governance for which of the following reasons?

_____ occurs when applications cannot access data associated with other applications.

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Refer to IT's About Business 5.4: Hospital Improves Patient Care with Data Warehouse: A single source of all patient data, accessible to multiple hospitals will have the following benefit

_ can be exercised to solve a problem, whereas _ may or may not be able to be exercised to solve a problem.

Describe the relational database model. Section reference 1: Database Management Systems

_____ provide(s) companies with a single version of the truth for their data.

Why is data governance so important for organizations? Section reference 1: Data Governance

Data dictionaries provide which of the following advantages to the organization?

Data rot refers to the quality of the data itself.

Discuss the advantages of the database approach. Section reference 1: The Database Approach

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security

Networks

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Enterprise Resource Planning Systems

Customer Relationship Management and Supply Chain Management

Crm and Scm

Business Intelligence

Technology Guide 1 - Hardware

Technology Guide 2 - Software

Technology Guide 3 - Cloud Computing

Technology Guide 4 - Intelligent Systems

Filters

Exam 5: Data and Knowledge Management

A negative value for a student's grade point average is an example of a data integrity problem.

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

_____ tell the database management system which records are joined with others in related tables.

_____ describe the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

_____ occurs when various copies of the data agree.

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

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

What are the advantages of a data mart? Section reference 1: Data Warehousing

Big Data has three distinct characteristics that distinguish it from traditional data.

Organizations are turning to data governance for which of the following reasons?

_____ occurs when applications cannot access data associated with other applications.

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Refer to IT's About Business 5.4: Hospital Improves Patient Care with Data Warehouse: A single source of all patient data, accessible to multiple hospitals will have the following benefit

_____ can be exercised to solve a problem, whereas _____ may or may not be able to be exercised to solve a problem.

Describe the relational database model. Section reference 1: Database Management Systems

_____ provide(s) companies with a single version of the truth for their data.

Why is data governance so important for organizations? Section reference 1: Data Governance

Data dictionaries provide which of the following advantages to the organization?

Data rot refers to the quality of the data itself.

Discuss the advantages of the database approach. Section reference 1: The Database Approach

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security

Networks

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Enterprise Resource Planning Systems

Customer Relationship Management and Supply Chain Management

Crm and Scm

Business Intelligence

Technology Guide 1 - Hardware

Technology Guide 2 - Software

Technology Guide 3 - Cloud Computing

Technology Guide 4 - Intelligent Systems

Filters

_ describe the activities of the business, whereas _ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

_ can be exercised to solve a problem, whereas _ may or may not be able to be exercised to solve a problem.