Question 1

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 2

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 3

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 4

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 these

Accepted Answer

This is an example of relational integrity constraints.

Question 5

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 6

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 7

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 8

What is the primary difference between an entity and an attribute?
A)An attribute is a table; an entity is a column from the attribute table.
B)An entity is specific; as an attribute is not data at all but brainstorming ideas that take place before the entity is created.
C)An attribute refers to applications; an entity refers to executives.
D)An entity is a table that stores information about people, places, or events; an attribute is a column or specific field of the data elements associated with an entity.

Accepted Answer

These are the definition distinctions between entities and attributes.

Question 9

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 10

What is the role of a foreign key?
A)It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
B)It is a unique way to identify each record.
C)Is a field that uniquely identifies a give record in a table.
D)All of these.

Accepted Answer

This is the definition of a foreign key.

Question 11

Which of the following is true with regard 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 these

Accepted Answer

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

Question 12

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 increased flexibility advantage.

Question 13

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

Accepted Answer

All of these are problems with redundant information.

Question 14

What type of keys do you need to use to create a relational database model?
A)Primary keys and secondary keys
B)Primary keys and foreign keys
C)Entity keys and attribute keys
D)Relational keys and DBMS keys

Accepted Answer

In order to effectively manage and organize various entities within the relational database model, you need to use primary keys and foreign keys to create logical relationships.

Question 15

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 these

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 it improves information quality.

Question 16

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 17

What is a field that uniquely identifies a given record in a table?
A)Foreign key
B)Primary key
C)Data mining key
D)DBMS key

Accepted Answer

This is the definition of a primary key.

Question 18

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 these

Accepted Answer

Data redundancy is all of these.

Question 19

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?
A)Entity
B)Extraction
C)Attribute
D)Foreign key

Accepted Answer

This is the definition of an entity.

Question 20

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.

Quiz 6: Data: Business Intelligence

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

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

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

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

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 focuses on how individual users logically access information to meet their own particular business needs?

What is the primary difference between an entity and an attribute?

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

What is the role of a foreign key?

Which of the following is true with regard to the elimination of redundant data?

What is the primary problem with redundant data?

What type of keys do you need to use to create a relational database model?

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?

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?

What is a field that uniquely identifies a given record in a table?

What is data redundancy?

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

What are rules that help ensure the quality of information?