Exam 7: Dbms Functions

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

The most common security features used by DBMSs are locking,journaling,and timestamping.

After a DBMS detects a deadlock,the ____ should break the deadlock.

____ refers to the right of individuals to have certain information about them kept confidential.

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

____ rules specify which users have what type of access to which data in the database.

Data about the data in a database is known as ____.

Legal values is a type of key integrity constraint.

____ integrity implies that the value entered for any field should be consistent with the data type for that field.

____ integrity constraints help to ensure the accuracy and consistency of individual field values.

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.

Additional disk and memory space are not required to store timestamp values.

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

Each user transaction requires only one lock.

PC-based DBMSs offer both a data dictionary and a catalog.

In some database systems,such as Microsoft Access,users can access and update metadata about fields,tables,relationships,and indexes.

A string of characters assigned by the DBA to a database that the user must enter to access the database is known as a database ____.

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

Concentric update occurs when multiple users make updates to the same database at the same time.

In order to accomplish serial processing of updates,many DBMSs use ____.