Question 1

Discuss the advantages and disadvantages of timestamping.

Accepted Answer

The answer of Discuss the advantages and disadvantages of timestamping....

Question 2

A DBMS provides a number of ____________________ services that assist in the general maintenance of the database.

Accepted Answer

The answer of A DBMS provides a number of ____________________...

Question 3

____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.

Accepted Answer

The answer of ____________________ key constraints are governed by entity...

Question 4

Explain how a DBMS breaks a deadlock.

Accepted Answer

The answer of Explain how a DBMS breaks a deadlock....

Question 5

_________________________ allows users at different sites to use and modify copies of a database and then share their changes with the other users.

Accepted Answer

The answer of _________________________ allows users at different sites to...

Question 6

____________________ constraints are rules that the DBMS must be follow in order to update data accurately and consistently.

Accepted Answer

The answer of ____________________ constraints are rules that the DBMS...

Question 7

Discuss the four ways in which integrity constraints can be handled.

Accepted Answer

The answer of Discuss the four ways in which integrity...

Question 8

Explain how a database is updated using batch processing.

Accepted Answer

The answer of Explain how a database is updated using...

Question 9

____________________ integrity constraints consist of primary key constraints and foreign key constraints.

Accepted Answer

The answer of ____________________ integrity constraints consist of primary key...

Question 10

What is data replication? Describe how replication can lead to more efficient database processing.

Accepted Answer

The answer of What is data replication? Describe how replication...

Quiz 7: Dbms Functions

Discuss the advantages and disadvantages of timestamping.