Question 1

_______________ uses drag-and-drop features to search a database.

Accepted Answer

A) DBMS 
B) QBE 
C) SQL 
D) DDF 
A) DBMS 
B) QBE 
C) SQL 
D) DDF

Question 2

Which of the following is NOT a problem with Big Data?

Accepted Answer

A) Gathering data 
B) Privacy 
C) Security 
D) Decision-making 
A) Gathering data 
B) Privacy 
C) Security 
D) Decision-making

Question 3

A database management system is primarily a(n)_____.

Accepted Answer

A) File-handling program 
B) Data-modeling program 
C) Interface between applications and a database 
D) Interface between data and a database 
E) Interface between queries and a database 
A) File-handling program 
B) Data-modeling program 
C) Interface between applications and a database 
D) Interface between data and a database 
E) Interface between queries and a database

Question 4

Knowledge is information in action.

Accepted Answer

A) True 
 B)False

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 data warehouses and data marts, data are stored in a multidimensional structure and visually represented as a data cube.Figure 3.12 is an example of a data cube of sales with the dimensions of product, geographic area, and time period (year).These are called business dimensions. What would the business dimensions be for Walmart's sales with its many sales transactions for many products in many stores that would allow them to do weekly analysis?

Accepted Answer

A) Customer, product, and month 
B) Customer, product, store 
C) Customer, product, store, and month 
D) Customer, product, store, and week 
E) Product, store, and week 
A) Customer, product, and month 
B) Customer, product, store 
C) Customer, product, store, and month 
D) Customer, product, store, and week 
E) Product, store, and week

Question 7

The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

Accepted Answer

A) True 
 B)False

Question 8

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way.They are sharing their tacit knowledge.

Accepted Answer

A) True 
 B)False

Question 9

The growing mounds of data have given rise to a new type of professional, the data scientist.

Accepted Answer

A) True 
 B)False

Question 10

__________________ allows users to perform complicated searches by using relatively simple statements or keywords.

Accepted Answer

A) DBMS 
B) QBE 
C) SQL 
D) SSK 
A) DBMS 
B) QBE 
C) SQL 
D) SSK

Question 11

The Isle of Capri Casinos developed a data warehouse to ________________.

Accepted Answer

A) Enhance its knowledge of its customers 
B) Target its promotions more precisely 
C) Adjust the floor in each casino to optimize revenue and profit 
D) All of the above 
A) Enhance its knowledge of its customers 
B) Target its promotions more precisely 
C) Adjust the floor in each casino to optimize revenue and profit 
D) All of the above

Question 12

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

Accepted Answer

A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many 
E) Some-to-many 
A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many 
E) Some-to-many

Question 13

In the relational database model, related tables can be joined when they contain common _____.

Accepted Answer

A) Primary keys 
B) Rows 
C) Records 
D) Columns 
E) Files 
A) Primary keys 
B) Rows 
C) Records 
D) Columns 
E) Files

Question 14

When you start a job, you are given an employee handbook which contains the company's tacit knowledge.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not a reason why managing data is difficult over time?

Accepted Answer

A) New systems are developed. 
B) The media the data are stored on becomes problematic. 
C) New sources of data are created. 
D) The amount of data increases exponentially. 
E) All of these are reasons why managing data is difficult over time. 
A) New systems are developed. 
B) The media the data are stored on becomes problematic. 
C) New sources of data are created. 
D) The amount of data increases exponentially. 
E) All of these are reasons why managing data is difficult over time.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not a source for external data?

Accepted Answer

A) Commercial databases 
B) Corporate databases 
C) Sensors 
D) Satellites 
E) Government reports 
A) Commercial databases 
B) Corporate databases 
C) Sensors 
D) Satellites 
E) Government reports

Question 18

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

Accepted Answer

A) Primary key in Student entity 
B) Primary key in Course entity 
C) Its own primary key. 
D) Primary key made up of the primary keys in Student entity and Course entity 
E) It doesn't need a primary key. 
A) Primary key in Student entity 
B) Primary key in Course entity 
C) Its own primary key. 
D) Primary key made up of the primary keys in Student entity and Course entity 
E) It doesn't need a primary key.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________.

Accepted Answer

A) Data degradation 
B) Data rot 
C) Data security 
D) Scattered data 
A) Data degradation 
B) Data rot 
C) Data security 
D) Scattered data

_______________ uses drag-and-drop features to search a database.

Which of the following is NOT a problem with Big Data?

A database management system is primarily a(n)_____.

Knowledge is information in action.

_____ occurs when various copies of the data agree.

The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way.They are sharing their tacit knowledge.

The growing mounds of data have given rise to a new type of professional, the data scientist.

__________________ allows users to perform complicated searches by using relatively simple statements or keywords.

The Isle of Capri Casinos developed a data warehouse to ________________.

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

In the relational database model, related tables can be joined when they contain common _____.

When you start a job, you are given an employee handbook which contains the company's tacit knowledge.

Which of the following is not a reason why managing data is difficult over time?

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

Which of the following is not a source for external data?

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

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

It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________.

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Networks

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Web 2.0 and Social Networks

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Ethics and Privacy

Information Security

Tech Guide 1: Hardware

Tech Guide 2: Software

Tech Guide 3: Emerging types of enterprise computing

Tech Guide 4: Intelligent Systems

Tech Guide 5: Protecting your information assets

Filters

Exam 3: Data and Knowledge Management

_______________ uses drag-and-drop features to search a database.

Which of the following is NOT a problem with Big Data?

A database management system is primarily a(n)_____.

Knowledge is information in action.

_____ occurs when various copies of the data agree.

The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way.They are sharing their tacit knowledge.

The growing mounds of data have given rise to a new type of professional, the data scientist.

__________________ allows users to perform complicated searches by using relatively simple statements or keywords.

The Isle of Capri Casinos developed a data warehouse to ________________.

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

In the relational database model, related tables can be joined when they contain common _____.

When you start a job, you are given an employee handbook which contains the company's tacit knowledge.

Which of the following is not a reason why managing data is difficult over time?

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

Which of the following is not a source for external data?

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

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

It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________.

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Networks

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Web 2.0 and Social Networks

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Ethics and Privacy

Information Security

Tech Guide 1: Hardware

Tech Guide 2: Software

Tech Guide 3: Emerging types of enterprise computing

Tech Guide 4: Intelligent Systems

Tech Guide 5: Protecting your information assets

Filters