Question 1

Which of the following is incorrect in reference to a database?
A)A database can be relational or network.
B)Database information is accessed by logical structure.
C)Database information is accessed by physical structure.
D)Database users can have different views of information.

Accepted Answer

A database accesses information by logical structure and stores information by physical structure.

Question 2

Which of the following is a disadvantage of database-stored information?
A)increased flexibility
B)increased performance
C)increased information redundancy
D)increased information integrity

Accepted Answer

Database-stored information reduces or decreases information redundancy.

Question 3

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 4

Which of the statements below 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 5

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 these are correct.

Accepted Answer

All of these are examples of information redundancy.

Question 6

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 are correct.

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 7

What are the rules that enforce basic and fundamental information-based constraints?
A)responsible integrity constraints
B)quality constraints
C)web integrity constraints
D)relational integrity constraints

Accepted Answer

This is the definition of relational integrity constraints.

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

Which of the following is not an example of an advantage of using a relational database?
A)increased information quality
B)increased flexibility
C)decreased information redundancy
D)decreased information security

Accepted Answer

All of them are advantages except decreased information security; the advantage is increased information security.

Question 10

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 are correct.

Accepted Answer

All of these are problems with redundant information.

Question 11

Which of the following is true in regard 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 are correct.

Accepted Answer

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

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 these are correct.

Accepted Answer

All are advantages of a data-driven website.

Question 13

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 14

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 15

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 16

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 17

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

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

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)system will not allow shipping of a nonexistent product to a customer.

Accepted Answer

A business-critical integrity constraint will not allow a return of fresh produce after 15 days.

Quiz 6: Data: Business Intelligence

Which of the following is incorrect in reference to a database?

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

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 statements below means the same as easy to manage content?

What is information redundancy?

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?

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

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

Which of the following is not an example of an advantage of using a relational database?

What is the primary problem with redundant information?

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

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

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

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?

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

What are 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?

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