Question 1

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 employeesE) B) and D)
F) C) and D)

Question 2

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.E) None of the above
F) All of the above

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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.E) A) and B)
F) B) and D)

Question 5

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.E) B) and D)
F) A) and D)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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.E) A) and B)
F) B) and C)

Question 8

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.E) None of the above
F) C) and D)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.E) None of the above
F) A) and C)

Question 11

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.E) None of the above
F) B) and C)

Question 12

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 issueE) A) and B)
F) A) and D)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A database maintains information on ___________.

Accepted Answer

A)  Inventory
B)  Transactions
C)  Employees
D)  All of theseE) A) and C)
F) A) and B)

Question 15

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.E) B) and C)
F) A) and D)

Question 16

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 integrityE) C) and D)
F) None of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 dictionaryE) A) and D)
F) A) and C)

Question 19

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 managementE) A) and B)
F) None of the above

Question 20

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.E) C) and D)
F) B) and D)

Exam 6: Valuing and Storing Organizational Information Databases

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A database maintains information on ___________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What occurs when the same data element has different values?

Correct AnswerverifiedShow Answer

Which of the following does not describe Zappos database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

What is a data steward responsible for?

Correct AnswerverifiedShow Answer

What are information integrity issues?

Correct AnswerverifiedShow Answer

What is the role of a foreign key?

Correct AnswerverifiedShow Answer

Which of the following represents the different information formats?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified