Question 1

What are rules that help ensure the quality of information?
A) Information integrity
B) Integrity constraints
C) Information quality
D) Information ethics

Accepted Answer

This is the definition of integrity constraints.

Question 2

Which of the following is not an example of an advantage to using the Web to access organizational databases?
A) Web browsers are much easier to use than a computer based database.
B) The Web interface requires few or no changes to the database model.
C) It is cleaner and virus-free.
D) It costs less.

Accepted Answer

There are a number of advantages to using the Web to access company databases including 1)Web browsers are much easier to use than a computer based database,2)the Web interface requires few or no changes to the database model,and 3)it costs less.

Question 3

Which of the following focuses on how individual users logically access information to meet their own particular business needs?
A) Physical view
B) Logical view
C) Data mart view
D) Data view

Accepted Answer

This is the definition of logical view.

Question 4

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
A) Data-driven website
B) Interactive website
C) Database performing website
D) Data processing website

Accepted Answer

This is the definition a data-driven website.

Question 5

What is identity management?
A) Enforces business rules vital to an organization's success
B) The practice of gathering data and ensuring that it is uniform,accurate,consistent,and complete
C) A broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system
D) When a company examines its data to determine if it can meet business expectations,while identifying possible data gaps

Accepted Answer

Identity management is a broad administrative area that deals with identifying individuals in a system (such as a country,a network,or an enterprise)and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Question 6

Which of the following offers an advantage of using a data-driven website?
A) Easy to eliminate human errors
B) Easy to manage content
C) Easy to store large amounts of data
D) All of these choices

Accepted Answer

All of these choices are advantages of a data-driven website.

Question 7

Which of the below statements means the same as easy to manage content?
A) Website owners can make changes only with the aid of MIS professionals.
B) The website can't organize customer data.
C) Users can update data-driven website with little or no training.
D) Users with extensive training can update data-driven websites.

Accepted Answer

Easy to manage content advantage means that website owners can make changes without relying on MIS professionals and users can update data-driven website with little or no training.

Question 8

Which of the following is a valid type of integrity constraint?
A) Relational-critical integrity constraint
B) Business integrity constraint
C) Relational integrity constraint
D) Business-critical integrity constraint

Accepted Answer

Business-critical integrity constraint is valid.

Question 9

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?
A) Identity management
B) Master data management
C) Data validation
D) Data latency

Accepted Answer

Identity management is a broad administrative area that deals with identifying individuals in a system (such as a country,a network,or an enterprise)and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Question 10

Which of the following is true in regards to the elimination of redundant information?
A) Uses additional hard disk space
B) Makes performing information updates harder
C) Improves information quality
D) All of these choices

Accepted Answer

Eliminating redundant information improves the quality of the information,uses less hard disk space,and makes performing updates easier.

Question 11

What are rules that enforce basic and fundamental information-based constraints?
A) Information integrity
B) Integrity constraint
C) Business-critical integrity constraint
D) Relational integrity constraint

Accepted Answer

This is the definition of relational integrity constraints.

Question 12

What are the rules that enforce basic and fundamental information-based constraints?
A) Responsibly integrity constraints
B) Quality constraints
C) Web integrity constraints
D) Relational integrity constraints

Accepted Answer

This is the definition of relational integrity constraints.

Question 13

Which of the following is a business-critical integrity constraint?
A) System will not allow an entry for an order for a nonexistent customer.
B) System will not allow returns of fresh produce after 15 days past delivery.
C) System will not allow shipping a product to a customer who does not have a valid address.
D) Systems will not allow shipping of a nonexistent product to a customer.

Accepted Answer

Business-critical integrity constraints will not allow a return of fresh produce after 15 days.

Question 14

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
A) Relational integrity constraint
B) Business-critical integrity constraint
C) Information-critical integrity constraint
D) Mission-critical integrity constraint

Accepted Answer

This is an example of relational integrity constraints.

Question 15

What is the primary problem with redundant information?
A) It is difficult to determine which values are the most current.
B) It is often inconsistent.
C) It is difficult to determine which values are the most accurate.
D) All of these choices

Accepted Answer

All of these are problems with redundant information.

Question 16

Which of the below does not describe Zappos's database?
A) Zappos's database was high scalable
B) Zappos's database was highly flexible
C) Zappos's database was highly secure
D) Zappos's database was highly redundant

Accepted Answer

Zappos.com is a great example of a data-driven website and was ranked as the most available Internet retailer because it is scalable,highly flexible,and has a secure database.

Question 17

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?
A) Quality business constraints
B) Critical Web constraints
C) Business critical integrity constraints
D) Web integrity constraints

Accepted Answer

This is the definition of business critical integrity constraints.

Question 18

What are the rules that help ensure the quality of information?
A) Information integrity
B) Integrity constraints
C) Relational integrity constraints
D) Business-critical integrity constraints

Accepted Answer

This is the definition of integrity constraints.

Question 19

The example the book gave of www.EllisIsland.org,which generates more than 2.5 billion hits,is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?
A) Increased scalability and performance
B) Increased information security
C) Reduced information redundancy
D) Increased flexibility

Accepted Answer

The Ellis Island website is an example of increased scalability and performance.

Question 20

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?
A) Reduces disk space requirements
B) Makes updating information easier
C) Improves information quality
D) All of these choices

Accepted Answer

One primary goal of a database is to eliminate information redundancy by recording each piece of information in only one place in the database,because it saves disk space,information updates are easier,and improves information quality.

Quiz 6: Data: Business Intelligence

What are rules that help ensure the quality of information?

Which of the following is not an example of an advantage to using the Web to access organizational databases?

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

What is identity management?

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

Which of the below statements means the same as easy to manage content?

Which of the following is a valid type of integrity constraint?

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

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

What are rules that enforce basic and fundamental information-based constraints?

What are the rules that enforce basic and fundamental information-based constraints?

Which of the following is a business-critical integrity constraint?

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

What is the primary problem with redundant information?

Which of the below does not describe Zappos's database?

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

What are the rules that help ensure the quality of information?

The example the book gave of www.EllisIsland.org,which generates more than 2.5 billion hits,is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

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?