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

The answer of What are rules that help ensure the...

Question 2

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

Relational integrity constraints enforce basic and fundamental information-based constraints in a database management system. They ensure that the data stored in a database is accurate, consistent, and reliable by enforcing rules such as primary key constraints, foreign key constraints, and entity integrity constraints. Responsibly integrity constraints, quality constraints, and web integrity constraints may also be important in certain contexts, but they do not specifically relate to enforcing fundamental information-based constraints in a database.

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

Business critical integrity constraints are designed specifically to enforce the business rules that are fundamental to an organization's success. These constraints often require a deeper understanding of the business processes and practices than traditional relational integrity constraints. Quality business constraints are not a commonly used term, and critical web and web integrity constraints are focused on web development rather than business rules.

Question 4

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

The answer of What are rules that enforce basic and...

Question 5

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 6

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

A data-driven website is designed to gather and store customer data in a database and use it to constantly update and personalize the website's content to meet the needs of the customers. This type of website is highly interactive, as it allows customers to engage with the website and its personalized features. A data-driven website can help businesses better understand their customers and provide them with a better user experience.

Question 7

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 refers to the duplication or storing of the same data in multiple places, resulting in increased storage requirements and potential inconsistencies between copies. Therefore, all of the above options (A, B, and C) are correct.

Question 8

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" implies that users can easily update the website without needing extensive technical knowledge or support. Choice C is the only statement that reflects this. The other options suggest that managing the website requires professional support or limits the website's capabilities.

Question 9

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

Eliminating data redundancy helps in reducing disk space requirements, making updating information easier, and improving information quality. This is because there is only one instance of each piece of data in the database, which reduces the storage needs and makes it easier to update data without having to make changes in multiple places. It also improves information quality by ensuring that there are no conflicting or inconsistent data values in the database.

Question 10

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

A data-driven website offers easy elimination of human errors, easy management of content, and easy storage of large amounts of data.

Question 11

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

The logical view focuses on how individual users logically access information to meet their own particular business needs. The physical view relates to how data is physically stored and accessed by the system, the data mart view is a subset of the overall data warehouse focused on a specific business function, and the data view relates to how data is presented to users.

Question 12

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 data improves information quality by ensuring that there is only one place to update information, reducing the risk of errors and inconsistencies. It can also free up storage space by removing unnecessary duplicates, and shouldn't affect the ability to update information as long as a reliable system for managing updates is in place.

Question 13

Your textbook discussed a record store example where one user could perform a query to determine which recordings had a track length of four minutes or more,and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories.What database advantage is this an example of?
A)Increased scalability and performance
B)Increased information security
C)Reduced information redundancy
D)Increased flexibility

Accepted Answer

This is an example of increased flexibility, as different users are able to perform different types of queries and analyses on the same database.

Question 14

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 example of www.ellisisland.org is an example of increased scalability and performance because the website offers a database that can easily handle huge volumes of data to serve its users.

Question 15

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

The answer of Which of the following is a valid...

Question 16

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

While all of the options presented are important integrity constraints, option B is not business-critical. While it is important to limit returns on fresh produce to maintain quality, it is not critical for the overall functioning of the business. The other options, however, are essential for ensuring that orders are placed correctly, products are shipped accurately, and valid addresses are used.

Question 17

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

Accepted Answer

The answer of Which of the below does not describe...

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

The answer of What are the rules that help ensure...

Question 19

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

Redundant data poses all the problems listed - it can be difficult to determine which values are the most current, accurate or consistent. Having multiple copies of the same data also wastes space and can lead to confusion and errors when updating or deleting information.

Question 20

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 constraint is known as a referential integrity constraint because it ensures that the data in one table relies on the data in another table. In this case, the order table should reference the customer table properly. If a nonexistent customer is entered when creating an order, it would violate referential integrity.

Quiz 6: Data: Business Intelligence

What are rules that help ensure the quality of information?

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?

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

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

What is data redundancy?

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

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?

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?

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

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 valid type of integrity constraint?

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

Which of the below does not describe Zappos database?

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

What is the primary problem with redundant data?

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