Question 1

All of the following are advantages of database-stored information except:

Accepted Answer

Database-stored information reduces information redundancy.

Question 2

Which of the following database structures offers a flexible way of representing objects and their relationships?

Accepted Answer

This is the definition of a network database model.

Question 3

In the relational database model,what is a person,place,thing,transaction,or event about which information is stored?

Accepted Answer

This is the definition of entity.

Question 4

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

Accepted Answer

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

Question 5

What is the physical view of information?

Accepted Answer

This is the definition of physical view.

Question 6

What is the primary problem with redundant information?

Accepted Answer

All of these are problems with redundant information.

Question 7

Which of the following database structures stores information in a treelike structure that allows repeating information using parent/child relationships,in such a way that it cannot have too many relationships?

Accepted Answer

This is the definition of a hierarchical database.

Question 8

What is information redundancy?

Accepted Answer

Redundancy is all of these.

Question 9

What refers to how well a system can adapt to increased demands?

Accepted Answer

This is the definition of scalability.

Question 10

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

Accepted Answer

This is the definition of integrity constraints.

Question 11

Why do relational databases use primary keys and foreign keys?

Accepted Answer

Keys are used to create logical relationships.

Question 12

In the relational database model,what is a characteristic or property of an entity?

Accepted Answer

This is the definition of attribute.

Question 13

What are characteristics or properties of an entity called?

Accepted Answer

Attributes are also called fields or columns.

Question 14

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

Accepted Answer

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

Question 15

What is a primary key?

Accepted Answer

This is the definition of primary key.

Question 16

Which of the following types of information can be found in a database?

Accepted Answer

A database maintains information on inventory, transactions, and employees.

Question 17

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

Accepted Answer

A database can support many logical views.

Question 18

Which of the following measures how quickly a system performs a certain process or transaction?

Accepted Answer

This is the definition of performance.

Question 19

What is a foreign key?

Accepted Answer

This is the definition of foreign key.

Question 20

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

Accepted Answer

This is the definition of relational integrity constraints.

Quiz 7: Storing Organizational Information Databases