Question 1

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

Accepted Answer

A) True 
 B)False

Question 2

Which procedure will prevent two end users from accessing the same data element at the same time?

Accepted Answer

A)  data redundancy
B)  data replication
C)  data lockout
D)  none of the above

Question 3

A deadlock is a phenomenon that prevents the processing of transactions.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which statement is not correct? A query language like SQL

Accepted Answer

A)  is written in a fourth-generation language
B)  requires user familiarity with COBOL
C)  allows users to retrieve and modify data
D)  reduces reliance on programmers

Question 6

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs...

Question 7

In the database method of data management,access authority is maintained by systems programming.

Accepted Answer

A) True 
 B)False

Question 8

Which statement is correct?

Accepted Answer

A)  In a normalized database, data about vendors occur in several locations.
B)  The accountant is responsible for database normalization.
C)  In a normalized database, deletion of a key record could result in the destruction of the audit trail.
D)  Connections between M:M tables are provided by a link table.

Question 9

Which duty is not the responsibility of the database administrator?

Accepted Answer

A)  to develop and maintain the data dictionary
B)  to implement security controls
C)  to design application programs
D)  to design the subschema

Question 10

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or ...

Question 11

A table is in third 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 deletion anomalies

Question 12

A description of the physical arrangement of records in the database is

Accepted Answer

A)  the internal view
B)  the conceptual view
C)  the subschema
D)  the external view

Question 13

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 14

An example of a distributed database is

Accepted Answer

A)  partitioned database
B)  centralized database
C)  networked database
D)  all are examples of distributed databases

Question 15

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 language

Question 16

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 17

Timestamping is a control that is used to ensure database partitioning.

Accepted Answer

A) True 
 B)False

Question 18

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER)diagram is t...

Question 19

Task-data dependency is

Accepted Answer

A)  failure to update the files of all users affected by a change
B)  another term for data redundancy
C)  user's inability to obtain additional information as needs change
D)  none of the above

Question 20

What are the three data management problems caused by data redundancy?

Accepted Answer

data storage,date up...

Exam 9: Database Management Systems

What is a partial dependency?

Correct AnswerverifiedA partial dependency occurs when one or ...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

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

Correct AnswerverifiedShow Answer

Which statement is correct?

Correct AnswerverifiedShow Answer

Which statement is not correct? A query language like SQL

Correct AnswerverifiedShow Answer

A deadlock is a phenomenon that prevents the processing of transactions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Task-data dependency is

Correct AnswerverifiedShow Answer

A table is in third normal form when it is

Correct AnswerverifiedShow Answer

A description of the physical arrangement of records in the database is

Correct AnswerverifiedShow Answer

In the database method of data management,access authority is maintained by systems programming.

Correct AnswerverifiedShow Answer

An example of a distributed database is

Correct AnswerverifiedShow Answer

Which procedure will prevent two end users from accessing the same data element at the same time?

Correct AnswerverifiedShow Answer

Explain the purpose of an ER diagram in database design.

Correct AnswerverifiedThe entity relationship (ER)diagram is t...View AnswerShow Answer

Timestamping is a control that is used to ensure database partitioning.

Correct AnswerverifiedShow Answer

The physical database is an abstract representation of the database.

Correct AnswerverifiedShow Answer

What are the three data management problems caused by data redundancy?

Correct Answerverifieddata storage,date up...View AnswerShow Answer

Which duty is not the responsibility of the database administrator?

Correct AnswerverifiedShow Answer

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

Correct AnswerverifiedShow Answer

What is a transitive dependency?

Correct AnswerverifiedA transitive dependency occurs...View AnswerShow Answer

Correct Answer
verified
A partial dependency occurs when one or ...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The entity relationship (ER)diagram is t...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
data storage,date up...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A transitive dependency occurs...
View Answer