Exam 7: Dbms Functions

Which of the following is descriptive information about the data in a database?

What strategy can programs employ to minimize the occurrence of deadlocks?

Which of the following is NOT one of the nine functions of a DBMS?

What can be described as a snapshot of certain data in a database at a given moment in time?

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.

When the DBMS locks more rows and releases none of the locks, this is called the contracting phase.

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

A backward recovery is also called a(n) ____________________.

What type of database update occurs when multiple users make updates to the same database at the same time?

Explain how a DBMS breaks a deadlock.

What do key integrity constraints consist of?

In order to accomplish serial processing of updates, what technique do many DBMSs use?

You can minimize the occurrence of deadlocks by making sure all programs lock records in random order whenever possible.

DBMSs must manage multiple copies of the same data at multiple locations.

Which of the following contains information about table relationships, views, indexes, users, privileges, and replicated data?

Authentication refers to techniques for decrypting data when it accessed by authorized users.

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

A commit is a record of what the data in a row looked like before an update.

Discuss the advantages and disadvantages of timestamping.

One of the nine functions of a DBMS is to provide disk management services.