Deck 7: Storing Organizational Information-Databases

Question 1

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

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

Answer 1

C
Explanation: This is the definition of attribute.

Question 2

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.

Answer 2

C
Explanation: A database accesses information by logical structure and stores information by physical structure.

Question 3

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.

Answer 3

C
Explanation: A database can support many logical views.

Question 4

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 5

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

Question 6

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

A) Relational-critical integrity constraint
B) Business integrity constraint
C) Critical constraint
D) Business-critical integrity constraint

Question 7

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 8

What is a primary key?

A) A field (or group of fields) that uniquely identifies a given record 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 9

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

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

Question 10

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 11

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 12

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 13

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 14

What are characteristics or properties of an entity called?

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

Question 15

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 16

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 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) None of these

Question 18

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

Question 19

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

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

Question 20

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

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

Question 21

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 22

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

Question 23

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 24

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

Question 25

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

Question 26

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

Question 27

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 28

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

Question 29

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 30

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

Question 31

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

Question 32

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

Question 33

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 34

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 35

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 36

Ideally,an organization wants to build only forward integrations.

Question 37

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 38

What type of website is best to build for a 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 39

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

Question 40

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

Question 41

Describe the role and purpose of a database management system.

Question 42

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

Question 43

Compare relational integrity constraints and business-critical integrity constraints.

Question 44

_________ integrity is a measure of the quality of information.

Question 45

Evaluate the advantages of the relational database model.