Question 1

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

Accepted Answer

The answer of A(n)___________ key in the relational database model...

Question 2

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

Accepted Answer

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.E) B) and C)
F) A) and D)

Question 3

Ideally,an organization wants to build only forward integrations.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The ________ view of information focuses on...

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A)   Inventory
B)   Transactions
C)   Employees
D)   All of theseE) B) and D)
F) B) and C)

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)   Information integrity
B)   Integrity constraint
C)   Business-critical integrity constraint
D)   Relational integrity constraintE) All of the above
F) A) and C)

Question 9

What is a foreign key?

Accepted Answer

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.E) A) and B)
F) All of the above

Question 10

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

Accepted Answer

A)   Scalability
B)   Performance
C)   Redundancy
D)   Information integrityE) A) and B)
F) B) and D)

Question 11

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

Accepted Answer

A)   Relational-critical integrity constraint
B)   Business integrity constraint
C)   Relational integrity constraint
D)   Business-critical integrity constraintE) B) and C)
F) A) and D)

Question 12

What is a forward integration?

Accepted Answer

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.E) A) and B)
F) A) and C)

Question 13

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

Accepted Answer

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.E) A) and D)
F) None of the above

Question 14

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

Accepted Answer

A)   Uses additional hard disk space.
B)   Makes performing information updates harder.
C)   Improves information quality.
D)   All of these.E) None of the above
F) A) and B)

Question 15

Describe the role and purpose of a database management system.

Accepted Answer

A database management system (DBMS)is so...

Question 16

What is a backward integration?

Accepted Answer

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.E) A) and D)
F) A) and C)

Question 17

What is information redundancy?

Accepted Answer

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

Question 18

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

Accepted Answer

The answer of A _______________ key is a field that...

Question 19

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

Accepted Answer

A)   Increased flexibility
B)   Increased performance
C)   Increased information redundancy
D)   Increased information integrityE) B) and D)
F) A) and B)

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 7: Storing Organizational Information Databases

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a backward integration?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a forward integration?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Describe the role and purpose of a database management system.

Correct AnswerverifiedA database management system (DBMS)is so...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is information redundancy?

Correct AnswerverifiedShow Answer

Ideally,an organization wants to build only forward integrations.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database management system (DBMS)is so...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified