Question 1

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 the above

Accepted Answer

All are advantages of a data-driven website.

Question 2

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 3

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 the above

Accepted Answer

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

Question 4

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 5

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 6

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 the above

Accepted Answer

All of the above are problems with redundant information.

Question 7

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 the above

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.

Question 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 cannot 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 16

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 constraint will not allow a return of fresh produce after 15 days. A and C represent relational integrity constraints.

Question 17

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 18

What is information redundancy?
A)Duplication of data
B)Storing the same data in multiple places
C)Storing duplicate data in multiple places
D)All of the above

Accepted Answer

Information redundancy is all of the above.

Question 19

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 20

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.

Quiz 6: Data: Business Intelligence

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

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?

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

What is identity management?

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?

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?

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?

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

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

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

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

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

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

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

Which of the following is a business-critical 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?

What is information redundancy?

What are rules that help ensure the quality of information?

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