Deck 7: Storing Organizational Information Databases

Question 1

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

A) Increased flexibility
B) Increased performance
C) Increased information redundancy
D) Increased information integrity

Answer 1

C
Explanation: Database-stored information reduces information redundancy.

Question 2

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

A) Hierarchical database
B) Network database
C) Relational database model
D) All of these

Answer 2

B
Explanation: 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?

A) Entity
B) Logical view
C) Attribute
D) Physical view

Answer 3

A
Explanation: This is the definition of entity.

Question 4

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

A) Can be relational or network.
B) Information is accessed by logical structure.
C) Information is accessed by physical structure.
D) Users can access different views of information.

Question 5

What is the physical view of information?

A) Deals with the physical storage of information on a storage device such as a hard disk.
B) Deals with the logical storage of information on a storage device such as a hard disk.
C) Focuses on how users logically access information to meet their particular business needs.
D) Focuses on how users physically access information to meet their particular business needs.

Question 6

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.

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?

A) Hierarchical database
B) Network database
C) Relational database model
D) All of these

Question 8

What is information redundancy?

A) Duplication of information.
B) Storing the same information in multiple places.
C) Storing duplicate information in multiple places.
D) All of these.

Question 9

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

A) Scalability
B) Performance
C) Redundancy
D) Information integrity

Question 10

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

Question 11

Why do relational databases use primary keys and foreign keys?

A) To create a database.
B) To create physical relationships.
C) To create logical relationships.
D) All of these.

Question 12

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

A) Entity
B) Logical view
C) Attribute
D) Physical view

Question 13

What are characteristics or properties of an entity called?

A) Attributes
B) Fields
C) Columns
D) All of these

Question 14

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

A) Uses additional hard disk space.
B) Makes performing information updates harder.
C) Improves information quality.
D) All of these.

Question 15

What is a primary key?

A) A field (or group of fields) that uniquely identifies a given entity in a table.
B) 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.
C) Characteristics or properties of an entity.
D) A field (or group of fields) that uniquely identifies a given attribute in a table.

Question 16

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

A) Inventory
B) Transactions
C) Employees
D) All of these

Question 17

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

A) A database can support only one logical view.
B) A database can support many physical views.
C) A database can support many logical views.
D) A database can support up to three logical views.

Question 18

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

A) Scalability
B) Performance
C) Redundancy
D) Information integrity

Question 19

What is a foreign key?

A) A field (or group of fields) that uniquely identifies a given entity in a table.
B) 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.
C) Characteristics or properties of an entity.
D) A field (or group of fields) that uniquely identifies a given attribute in a table.

Question 20

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

A) Information integrity
B) Integrity constraint
C) Business-critical integrity constraint
D) Relational integrity constraint

Question 21

What is an integration?

A) Allows separate systems to communicate directly with each other.
B) Takes information entered into a given system and sends it to the database.
C) Takes information entered into a given system and sends it to other processes.
D) Takes information entered into a given system and sends it to the DBMS.

Question 22

What type of website is best to build for a website with continually changing information,including press releases,new product information,and updated pricing?

A) Data-driven website
B) Static website
C) Relational website
D) All of these

Question 23

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Question 24

What is a backward integration?

A) Takes information entered into a given system and sends it to the application-generation component.
B) Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C) Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D) Takes information entered into a given system and sends it to the DBMS.

Question 25

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

Question 26

One of the advantages found in a relational database is increased information redundancy.

Question 27

Ideally,an organization wants to build only forward integrations.

Question 28

What type of website is best to build for a general informational website with static information?

A) Data-driven website
B) Static website
C) Relational website
D) All of these

Question 29

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

A) The system will not allow an entry for an order for a nonexistent customer.
B) The system will not allow returns of fresh produce after 15 days past delivery.
C) The system will not allow shipping a product to a customer who does not have a valid address.
D) The system will not allow shipping a nonexistent product to a customer.

Question 30

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Question 31

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

Question 32

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Question 33

What is a forward integration?

A) Takes information entered into a given system and sends it to the application-generation component.
B) Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C) Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D) Takes information entered into a given system and sends it to the DBMS.

Question 34

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

A) Customer-driven website
B) Data-driven website
C) Customer-driven database
D) Data-driven database

Question 35

Customer ID,Customer Name,Contact Name,and Customer Phone are all types of ____________.

Question 36

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

Question 37

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

A) Minimizes human error.
B) Cuts production and update costs.
C) Improves or maximizes stability.
D) Minimizes or reduces efficiency.

Question 38

Which of the following uses a DBMS to interact with a database?

A) Users of accounting programs
B) Users of human resource programs
C) Users of marketing programs
D) All of these

Question 39

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

Question 40

A _______________ key is a field that uniquely identifies a given entity in a table.

Question 41

Describe the role and purpose of a database management system.

Question 42

______________ integrity constraints are rules that enforce business rules vital to an organization's success.

Question 43

_________ integrity is a measure of the quality of information.

Question 44

The _________ view of information deals with the physical storage of information on a storage device such as a hard disk.

Question 45

Evaluate the advantages of the relational database model.

Question 46

Compare relational integrity constraints and business-critical integrity constraints.

Question 47

______________ is the duplication of information,or storing the same information in multiple places.

Question 48

The ________ view of information focuses on how users logically access information to meet their particular business needs.