Question 1

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs...

Question 6

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 7

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 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

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or ...

Question 13

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 14

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 15

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 16

Explain the purpose of an ER diagram in database design.

Accepted Answer

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

Question 17

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 18

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

Accepted Answer

data storage,date up...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 9: Database Management Systems

Task-data dependency is

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the purpose of an ER diagram in database design.

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

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

Correct AnswerverifiedShow Answer

A table is in third normal form when it is

Correct AnswerverifiedShow 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

Which statement is correct?

Correct AnswerverifiedShow Answer

Which statement is not correct? A query language like SQL

Correct AnswerverifiedShow Answer

The physical database is an abstract representation of the database.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a partial dependency?

Correct AnswerverifiedA partial dependency occurs when one or ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Which duty is not the responsibility of the database administrator?

Correct AnswerverifiedShow Answer

An example of a distributed database is

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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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
A transitive dependency occurs...
View Answer

Correct Answer
verified