Question 1

Which of the following is true in regards to the elimination of redundant information?

Accepted Answer

A) Uses additional hard disk space. 
B) Makes performing information updates harder. 
C) Improves information quality. 
D) All of these. 
A) Uses additional hard disk space. 
B) Makes performing information updates harder. 
C) Improves information quality. 
D) All of these.

Question 2

What type of keys do you need to use to create a relational database model?

Accepted Answer

A) Primary keys and secondary keys. 
B) Primary keys and foreign keys. 
C) Entity keys and attribute keys. 
D) Relational keys and DBMS keys. 
A) Primary keys and secondary keys. 
B) Primary keys and foreign keys. 
C) Entity keys and attribute keys. 
D) Relational keys and DBMS keys.

Question 3

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A) To create an entity. 
B) To create physical relationships. 
C) To create logical relationships. 
D) To create an attribute. 
A) To create an entity. 
B) To create physical relationships. 
C) To create logical relationships. 
D) To create an attribute.

Question 4

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database.What does the elimination of information redundancy do for a database?

Accepted Answer

A) Reduces disk space requirements. 
B) Makes updating information easier. 
C) Improves information quality. 
D) All of these. 
A) Reduces disk space requirements. 
B) Makes updating information easier. 
C) Improves information quality. 
D) All of these.

Question 5

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following represents the different information formats?

Accepted Answer

A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) Executives, managers, operational employees 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) Executives, managers, operational employees

Question 7

What compiles all of the metadata about the data elements in the data model?

Accepted Answer

A) Data entity 
B) Data element 
C) Data attribute 
D) Data dictionary 
A) Data entity 
B) Data element 
C) Data attribute 
D) Data dictionary

Question 8

A content editor is the person responsible for updating and maintaining website content.

Accepted Answer

A) True 
 B)False

Question 9

What are information integrity issues?

Accepted Answer

A) Occurs when the same data element has different values. 
B) Occurs when a system produces incorrect, inconsistent, or duplicate data. 
C) Refers to the overall management of the availability, usability, integrity, and security of company data. 
D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems. 
A) Occurs when the same data element has different values. 
B) Occurs when a system produces incorrect, inconsistent, or duplicate data. 
C) Refers to the overall management of the availability, usability, integrity, and security of company data. 
D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Question 10

A database maintains information on ___________.

Accepted Answer

A) Inventory 
B) Transactions 
C) Employees 
D) All of these 
A) Inventory 
B) Transactions 
C) Employees 
D) All of these

Question 11

What occurs when the same data element has different values?

Accepted Answer

A) Information inconsistency 
B) Information integrity issues 
C) Data governance 
D) Master data management 
A) Information inconsistency 
B) Information integrity issues 
C) Data governance 
D) Master data management

Question 12

Which of the following is a disadvantage of database-stored information?

Accepted Answer

A) Increased flexibility 
B) Increased performance 
C) Increased information redundancy 
D) Increased information integrity 
A) Increased flexibility 
B) Increased performance 
C) Increased information redundancy 
D) Increased information integrity

Question 13

What is a data steward responsible for?

Accepted Answer

A) Acting as a liaison between the MIS department and the business. 
B) Ensuring policies and procedures are implemented across the organization. 
C) Both A and 
B)  
D) None of these. 
A) Acting as a liaison between the MIS department and the business. 
B) Ensuring policies and procedures are implemented across the organization. 
C) Both A and 
B)  
D) None of these.

Question 14

The logical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 15

What is the role of a foreign key?

Accepted Answer

A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. 
B) It is a unique way to identify each record. 
C) It is a field that uniquely identifies a given record in a table. 
D) All of these. 
A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. 
B) It is a unique way to identify each record. 
C) It is a field that uniquely identifies a given record in a table. 
D) All of these.

Question 16

Which of the following does not describe Zappos database?

Accepted Answer

A) Zappos database was high scalable. 
B) Zappos database was highly flexible. 
C) Zappos database was highly secure. 
D) Zappos database was highly redundant. 
A) Zappos database was high scalable. 
B) Zappos database was highly flexible. 
C) Zappos database was highly secure. 
D) Zappos database was highly redundant.

Question 17

Which of the following offers an advantage of using a data-driven website?

Accepted Answer

A) Easy to eliminate human errors. 
B) Easy to manage content. 
C) Easy to store large amounts of data. 
D) All of these. 
A) Easy to eliminate human errors. 
B) Easy to manage content. 
C) Easy to store large amounts of data. 
D) All of these.

Question 18

Timely information asks if each transaction and event is represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 19

Attributes (also called columns or fields) are the data elements associated with an entity.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A) Information inconsistency issue 
B) Information integrity issue 
C) Data control issue 
D) Data mining issue 
A) Information inconsistency issue 
B) Information integrity issue 
C) Data control issue 
D) Data mining issue

Exam 6: Valuing and Storing Organizational Information Databases

Which of the following is true in regards to the elimination of redundant information?

What type of keys do you need to use to create a relational database model?

Why do relational databases use primary keys and foreign keys?

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database.What does the elimination of information redundancy do for a database?

One of the advantages found in a relational database is increased information redundancy.

Which of the following represents the different information formats?

What compiles all of the metadata about the data elements in the data model?

A content editor is the person responsible for updating and maintaining website content.

What are information integrity issues?

A database maintains information on ___________.

What occurs when the same data element has different values?

Which of the following is a disadvantage of database-stored information?

What is a data steward responsible for?

The logical view of information deals with the physical storage of information on a storage device.

What is the role of a foreign key?

Which of the following does not describe Zappos database?

Which of the following offers an advantage of using a data-driven website?

Timely information asks if each transaction and event is represented only once in the information.

Attributes (also called columns or fields) are the data elements associated with an entity.

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Accessing Organizational Information Data Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End to End Enterprise Resource Planning

Creating Innovative Organizations

E-business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters