Question 1

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

Accepted Answer

A) Attribute. 
B) Entity. 
C) Primary key. 
D) Object. 
E) File. 
A) Attribute. 
B) Entity. 
C) Primary key. 
D) Object. 
E) File.

Question 2

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

Accepted Answer

A) Primary keys 
B) Secondary keys 
C) Duplicate keys 
D) Attribute keys 
E) Record keys 
A) Primary keys 
B) Secondary keys 
C) Duplicate keys 
D) Attribute keys 
E) Record keys

Question 3

_____________ knowledge can be easily documented.

Accepted Answer

A) Complete 
B) Explicit 
C) Tacit 
D) Intellectual 
A) Complete 
B) Explicit 
C) Tacit 
D) Intellectual

Question 4

In the data hierarchy, the smallest element is the _____.

Accepted Answer

A) Record. 
B) Bit. 
C) Byte. 
D) Character. 
E) File. 
A) Record. 
B) Bit. 
C) Byte. 
D) Character. 
E) File.

Question 5

A(n)_____ is a logical grouping of characters into a word, a small group of words, or a complete number.

Accepted Answer

A) Byte 
B) Field 
C) Record 
D) File 
E) Database 
A) Byte 
B) Field 
C) Record 
D) File 
E) Database

Question 6

It is important for applications and data to be dependent on each other.

Accepted Answer

A) True 
 B)False

Question 7

_____ occurs when the same data are stored in many places.

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 8

_____ 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

Question 9

_____ 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 10

_____ 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 11

Which of the following has (have)the broadest impact on an organization?

Accepted Answer

A) Decisions about hardware. 
B) Decisions about software. 
C) Decisions about data. 
D) Both "decisions about hardware" and "decisions about software." 
E) All of these have an equal impact. 
A) Decisions about hardware. 
B) Decisions about software. 
C) Decisions about data. 
D) Both "decisions about hardware" and "decisions about software." 
E) All of these have an equal impact.

Question 12

Data __________ is a problem minimized by databases.

Accepted Answer

A) Independence 
B) Integrity 
C) Isolation 
D) Security 
A) Independence 
B) Integrity 
C) Isolation 
D) Security

Question 13

The Isle of Capri Casinos found its direct mail program was successful in providing a complete view of the customers.

Accepted Answer

A) True 
 B)False

Question 14

Master data are generated and captured by operational systems.

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

Data marts are designed for the end-user needs in a strategic business unit or department.

Accepted Answer

A) True 
 B)False

Question 17

An organization's data warehouse generally maintains its operational data.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a challenge for developing a knowledge management system?

Accepted Answer

A) Employees must be willing to share their explicit knowledge. 
B) It must be continually maintained and updated. 
C) It makes human capital widely accessible. 
D) All of the above are challenges 
A) Employees must be willing to share their explicit knowledge. 
B) It must be continually maintained and updated. 
C) It makes human capital widely accessible. 
D) All of the above are challenges

Question 19

Which of the following statements is TRUE?

Accepted Answer

A) Databases are organized to make queries very easy. 
B) Running queries in a data warehouse does not degrade database performance. 
C) Databases are well-suited for making comparisons between records. 
D) Querying databases is the most effective and efficient way of using data. 
A) Databases are organized to make queries very easy. 
B) Running queries in a data warehouse does not degrade database performance. 
C) Databases are well-suited for making comparisons between records. 
D) Querying databases is the most effective and efficient way of using data.

Question 20

Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

Accepted Answer

A) True 
 B)False

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

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

_____________ knowledge can be easily documented.

In the data hierarchy, the smallest element is the _____.

A(n)_____ is a logical grouping of characters into a word, a small group of words, or a complete number.

It is important for applications and data to be dependent on each other.

_____ occurs when the same data are stored in many places.

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

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

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

Which of the following has (have)the broadest impact on an organization?

Data __________ is a problem minimized by databases.

The Isle of Capri Casinos found its direct mail program was successful in providing a complete view of the customers.

Master data are generated and captured by operational systems.

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

Data marts are designed for the end-user needs in a strategic business unit or department.

An organization's data warehouse generally maintains its operational data.

Which of the following is a challenge for developing a knowledge management system?

Which of the following statements is TRUE?

Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

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

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

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

_____________ knowledge can be easily documented.

In the data hierarchy, the smallest element is the _____.

A(n)_____ is a logical grouping of characters into a word, a small group of words, or a complete number.

It is important for applications and data to be dependent on each other.

_____ occurs when the same data are stored in many places.

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

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

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

Which of the following has (have)the broadest impact on an organization?

Data __________ is a problem minimized by databases.

The Isle of Capri Casinos found its direct mail program was successful in providing a complete view of the customers.

Master data are generated and captured by operational systems.

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

Data marts are designed for the end-user needs in a strategic business unit or department.

An organization's data warehouse generally maintains its operational data.

Which of the following is a challenge for developing a knowledge management system?

Which of the following statements is TRUE?

Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

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