Question 1

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

Accepted Answer

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

Question 2

Describe the role and purpose of a database management system.

Accepted Answer

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

Question 3

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) All of the above
F) C) and D)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Accepted Answer

The answer of The _________ view of information deals with...

Question 7

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

Accepted Answer

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

Question 8

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)   To create a database.
B)   To create physical relationships.
C)   To create logical relationships.
D)   All of these.E) B) and D)
F) None of the above

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   Relational integrity constraint
B)   Business-critical integrity constraint
C)   Information-critical integrity constraint
D)   None of theseE) A) and B)
F) B) and D)

Question 11

What is an integration?

Accepted Answer

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

Question 12

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

Question 13

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) None of the above

Question 14

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 15

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

Accepted Answer

A)   Customer-driven website
B)   Data-driven website
C)   Customer-driven database
D)   Data-driven databaseE) A) and D)
F) A) and C)

Question 16

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 17

Evaluate the advantages of the relational database model.

Accepted Answer

Database advantages from a business perspective include increased flexibility,increased scalability and performance,reduced information redundancy,increased information integrity (quality),and increased information security.

Question 18

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

Accepted Answer

A)   Entity
B)   Logical view
C)   Attribute
D)   Physical viewE) A) and B)
F) A) and C)

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

What are characteristics or properties of an entity called?

Accepted Answer

A)   Attributes
B)   Fields
C)   Columns
D)   All of theseE) A) and D)
F) A) and C)

Exam 7: Storing Organizational Information-Databases

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

Correct AnswerverifiedD

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 is not an advantage of building a data-driven website?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is an integration?

Correct AnswerverifiedA

Which of the following is incorrect in reference to 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

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

Correct AnswerverifiedShow Answer

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

Evaluate the advantages of the relational database model.

Correct AnswerverifiedDatabase advantages from a business perspective include increased flexibility,increased scalability and performance,reduced information redundancy,increased information integrity (quality),and increased information security.

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are characteristics or properties of an entity called?

Correct AnswerverifiedShow Answer

Correct Answer
verified
D

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
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Database advantages from a business perspective include increased flexibility,increased scalability and performance,reduced information redundancy,increased information integrity (quality),and increased information security.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified