Question 1

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 2

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 of a data-driven website.

Question 3

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 4

What is the primary problem with redundant data?
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 5

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 6

What is data 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

Data redundancy is All of the above.

Question 7

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 8

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)None of the above

Accepted Answer

This is an example of relational integrity constraints.

Question 9

Which of the below does not describe Zappos database?
A)Zappos database was high scalable
B)Zappos database was highly flexible
C)Zappos database was highly secure
D)Zappos 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 secure database.

Question 10

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 11

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 12

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 13

All of the following are business-critical integrity constraints,except
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 14

One of the primary goals of a database is to eliminate data redundancy by recording each piece of data in only one place in the database.What does the elimination of data 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 15

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 16

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 17

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 18

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 19

Which of the following is not an advantage to a data-driven website?
A)Development
B)Minimizing human error
C)Increasing update costs
D)More efficient

Accepted Answer

A data-driven website cuts production and update costs.

Question 20

Which of the following is true in regards to the elimination of redundant data?
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.

Quiz 6: Data: Business Intelligence

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?

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

What is the primary problem with redundant data?

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

What is data redundancy?

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

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

Which of the below does not describe Zappos 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 below statements means the same as easy to manage content?

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

All of the following are business-critical integrity constraints,except

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

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

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 rules that enforce basic and fundamental information-based constraints?

What are rules that help ensure the quality of information?

Which of the following is not an advantage to a data-driven website?

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