Exam 7: Dbms Functions

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

A user's ____________________ specify what kind of access the user has to objects in the database.​

PC-based DBMSs offer a data dictionary.​

The catalog is maintained by ____.​

​____________________ occurs when the DBMS exchanges all updated data between the master database and a replica.

Explain how a database is updated using batch processing.​

A DBMS must provide ways to ensure that only authorized users can access the database.

​The technique for identifying the person who is attempting to access the DBMS is known as ____.

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

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

____ a database reverses encryption.​

_________________________ is a property that lets you change the database structure without requiring you to change the programs that access the database.​

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

____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.​

The successful completion of a transaction is known as an after image.​

____ contain information about table relationships,views,indexes,users,privileges,and replicated data.​

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

Each job that a user completes,such as filling an order,is called a user task.

Explain the difference between a procedural language and a nonprocedural language.Give at least one example of each type of language.​

____ denies access by other users to data while the DBMS processes one user's updates to the database.​