Question 1

The data dictionary describes all of the data elements in the database.

Accepted Answer

A) True 
 B)False

Question 2

A table is in first normal form when it is

Accepted Answer

A)   free of repeating group data
B)   free of transitive dependencies
C)   free of partial dependencies
D)   free of update anomalies
E)   none of the aboveF) A) and B)
G) C) and E)

Question 3

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

Accepted Answer

The most apparent difference between the...

Question 4

Data normalization groups data attributes into tables in accordance with specific design objectives.

Accepted Answer

A) True 
 B)False

Question 5

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

Accepted Answer

Where a true 1:1 association exists betw...

Question 6

Which characteristic is associated with the database approach to data management?

Accepted Answer

A)   data sharing
B)   multiple storage procedures
C)   data redundancy
D)   excessive storage costsE) B) and C)
F) A) and C)

Question 7

What are the four elements of the database approach? Explain the role of each.

Accepted Answer

Users are the individuals in the organiz...

Question 8

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Accepted Answer

A) True 
 B)False

Question 9

Entities are

Accepted Answer

A)   nouns that are depicted by rectangles on an entity relationship diagram
B)   data that describe the characteristics of properties of resources
C)   associations among elements
D)   sets of data needed to make a decisionE) A) and B)
F) A) and C)

Question 10

Explain the three views of a database.

Accepted Answer

The unique internal view of the database...

Question 11

To the user,data processing procedures for routine transactions,such as entering sales orders,appear to be identical in the database environment and in the traditional environment.

Accepted Answer

A) True 
 B)False

Question 12

The advantages of a partitioned database include all of the following except

Accepted Answer

A)   user control is enhanced
B)   data transmission volume is increased
C)   response time is improved
D)   risk of destruction of entire database is reducedE) None of the above
F) B) and C)

Question 13

The most serious problem with unnormalized databases is the

Accepted Answer

A)   update anomaly
B)   insertion anomaly
C)   deletion anomaly
D)   none of the aboveE) A) and B)
F) B) and D)

Question 14

What are two types of distributed databases?

Accepted Answer

Partitione...

Question 15

Which characteristic is not associated with the database approach to data management?

Accepted Answer

A)   the ability to process data without the help of a programmer
B)   the ability to control access to the data
C)   constant production of backups
D)   the inability to determine what data is availableE) A) and B)
F) None of the above

Question 16

Discuss the key factors to consider in determining how to partition a corporate database.

Accepted Answer

The partitioned approach works best for ...

Question 17

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are elements of the DBMS which facilitate user access to the database except

Accepted Answer

A)   query language
B)   data access language
C)   data manipulation language
D)   data definition languageE) A) and C)
F) None of the above

Question 19

Which statement is false?

Accepted Answer

A)   The DBMS is special software that is programmed to know which data elements each user is authorized to access.
B)   User programs send requests for data to the DBMS.
C)   During processing,the DBMS periodically makes backup copies of the physical database.
D)   The DBMS does not control access to the database.E) A) and D)
F) A) and C)

Question 20

Which of the following may provide many distinct views of the database?

Accepted Answer

A)   the schema
B)   the internal view
C)   the user view
D)   the conceptual viewE) All of the above
F) A) and B)

Exam 9: Database Management Systems

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

Correct AnswerverifiedThe most apparent difference between the...View AnswerShow Answer

The data dictionary describes all of the data elements in the database.

Correct AnswerverifiedShow Answer

Data normalization groups data attributes into tables in accordance with specific design objectives.

Correct AnswerverifiedShow Answer

Which characteristic is not associated with the database approach to data management?

Correct AnswerverifiedShow Answer

What are the four elements of the database approach? Explain the role of each.

Correct AnswerverifiedUsers are the individuals in the organiz...View AnswerShow Answer

Discuss the key factors to consider in determining how to partition a corporate database.

Correct AnswerverifiedThe partitioned approach works best for ...View AnswerShow Answer

An entity is any physical thing about which the organization wishes to capture data.

Correct AnswerverifiedShow Answer

Explain the three views of a database.

Correct AnswerverifiedThe unique internal view of the database...View AnswerShow Answer

What are two types of distributed databases?

Correct AnswerverifiedPartitione...View AnswerShow Answer

The most serious problem with unnormalized databases is the

Correct AnswerverifiedShow Answer

To the user,data processing procedures for routine transactions,such as entering sales orders,appear to be identical in the database environment and in the traditional environment.

Correct AnswerverifiedShow Answer

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

Correct AnswerverifiedWhere a true 1:1 association exists betw...View AnswerShow Answer

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Correct AnswerverifiedShow Answer

A table is in first normal form when it is

Correct AnswerverifiedShow Answer

The advantages of a partitioned database include all of the following except

Correct AnswerverifiedShow Answer

Which statement is false?

Correct AnswerverifiedShow Answer

Entities are

Correct AnswerverifiedShow Answer

Which characteristic is associated with the database approach to data management?

Correct AnswerverifiedShow Answer

Which of the following may provide many distinct views of the database?

Correct AnswerverifiedShow Answer

All of the following are elements of the DBMS which facilitate user access to the database except

Correct AnswerverifiedShow Answer

Correct Answer
verified
The most apparent difference between the...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Users are the individuals in the organiz...
View Answer

Correct Answer
verified
The partitioned approach works best for ...
View Answer

Correct Answer
verified

Correct Answer
verified
The unique internal view of the database...
View Answer

Correct Answer
verified
Partitione...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Where a true 1:1 association exists betw...
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