Question 1

The biggest problem today is gathering data and then using it properly.

Accepted Answer

A) True 
 B)False  False

Question 2

__________ involves the analysis of accumulated data and involves a __________.

Accepted Answer

A) OLAP, database 
B) OLAP, data warehouse 
C) OLTP, database 
D) OLTP, data warehouse 
A) OLAP, database 
B) OLAP, data warehouse 
C) OLTP, database 
D) OLTP, data warehouse B

Question 3

Secondary keys have some identifying information but do not identify a file with complete accuracy.

Accepted Answer

A) True 
 B)False  True

Question 4

Data ___________ ensures applications cannot access data associated with other applications.

Accepted Answer

A) Hermitting 
B) Inconsistency 
C) Isolation 
D) Redundancy 
A) Hermitting 
B) Inconsistency 
C) Isolation 
D) Redundancy

Question 5

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

Accepted Answer

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

Question 6

In a data warehouse, existing data are constantly purged as new data come in.

Accepted Answer

A) True 
 B)False

Question 7

A relational database is one big table that contains all the company's records.

Accepted Answer

A) True 
 B)False

Question 8

Sarbanes-Oxley legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

Accepted Answer

A) IT policies 
B) HR rules 
C) financial controls 
D) sales goals 
A) IT policies 
B) HR rules 
C) financial controls 
D) sales goals

Question 9

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip).A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

Accepted Answer

The answer of In a jewelry store, a customer places...

Question 10

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

Accepted Answer

A) They cost less. 
B) They have longer lead times for implementation. 
C) They provide for central rather than local control. 
D) They contain more information. 
E) They are more difficult to navigate. 
A) They cost less. 
B) They have longer lead times for implementation. 
C) They provide for central rather than local control. 
D) They contain more information. 
E) They are more difficult to navigate.

Question 11

The data in a data warehouse:

Accepted Answer

A) Are updated constantly in real time. 
B) Are updated in batch mode, approximately once per day. 
C) Are not updated. 
D) Are purged constantly as new data enter. 
E) Are available for MIS analysts, but not users. 
A) Are updated constantly in real time. 
B) Are updated in batch mode, approximately once per day. 
C) Are not updated. 
D) Are purged constantly as new data enter. 
E) Are available for MIS analysts, but not users.

Question 12

The amount of data we collect is ____________ over time, making it ________ difficult to manage data.

Accepted Answer

A) Decreasing, less 
B) Decreasing, more 
C) Increasing, less 
D) Increasing, more 
A) Decreasing, less 
B) Decreasing, more 
C) Increasing, less 
D) Increasing, more

Question 13

A(n)_____ represents a single character, such as a letter, number, or symbol.

Accepted Answer

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

Question 14

_____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization's memory and typically reside inside the organization in an unstructured manner.

Accepted Answer

A) Discovery 
B) Knowledge management 
C) Decision support 
D) Online analytical processing 
E) Data mining 
A) Discovery 
B) Knowledge management 
C) Decision support 
D) Online analytical processing 
E) Data mining

Question 15

An attribute is any characteristic or quality that describes a particular entity.

Accepted Answer

A) True 
 B)False

Question 16

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 17

A _______ is eight ________.

Accepted Answer

A) bit, digits 
B) Byte, characters 
C) Bit, bytes 
D) Byte, bits 
A) bit, digits 
B) Byte, characters 
C) Bit, bytes 
D) Byte, bits

Question 18

For the following entity-relationship diagram, the Student entity would have the foreign key.

Accepted Answer

A) True 
 B)False

Question 19

_____________ reduces a relational database to its most streamlined form.

Accepted Answer

A) A data dictionary 
B) A database management system 
C) Normalization 
D) Streamlining 
A) A data dictionary 
B) A database management system 
C) Normalization 
D) Streamlining

Question 20

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) Both "They enable faster program development." and "They make it easier to modify data and information." 
E) All of these 
A) They reduce data inconsistency. 
B) They enable faster program development. 
C) They make it easier to modify data and information. 
D) Both "They enable faster program development." and "They make it easier to modify data and information." 
E) All of these

The biggest problem today is gathering data and then using it properly.

involves the analysis of accumulated data and involves a .

Secondary keys have some identifying information but do not identify a file with complete accuracy.

Data ___________ ensures applications cannot access data associated with other applications.

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

In a data warehouse, existing data are constantly purged as new data come in.

A relational database is one big table that contains all the company's records.

Sarbanes-Oxley legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip).A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

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

The data in a data warehouse:

The amount of data we collect is ____ over time, making it difficult to manage data.

A(n)_____ represents a single character, such as a letter, number, or symbol.

_____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization's memory and typically reside inside the organization in an unstructured manner.

An attribute is any characteristic or quality that describes a particular entity.

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

A _ is eight __.

For the following entity-relationship diagram, the Student entity would have the foreign key.

_____________ reduces a relational database to its most streamlined form.

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

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

The biggest problem today is gathering data and then using it properly.

__________ involves the analysis of accumulated data and involves a __________.

Secondary keys have some identifying information but do not identify a file with complete accuracy.

Data ___________ ensures applications cannot access data associated with other applications.

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

In a data warehouse, existing data are constantly purged as new data come in.

A relational database is one big table that contains all the company's records.

Sarbanes-Oxley legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip).A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

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

The data in a data warehouse:

The amount of data we collect is ____________ over time, making it ________ difficult to manage data.

A(n)_____ represents a single character, such as a letter, number, or symbol.

_____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization's memory and typically reside inside the organization in an unstructured manner.

An attribute is any characteristic or quality that describes a particular entity.

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

A _______ is eight ________.

For the following entity-relationship diagram, the Student entity would have the foreign key.

_____________ reduces a relational database to its most streamlined form.

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

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

involves the analysis of accumulated data and involves a .

The amount of data we collect is ____ over time, making it difficult to manage data.

A _ is eight __.