Exam 7: Dbms Functions

____________________ is the prevention of unauthorized access,either intentional or accidental.

In two-phase locking,the second phase is the shrinking phase.

The catalog is maintained by ____.

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

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

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

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

Discuss the advantages and disadvantages of timestamping.

A(n) ____ is a snapshot of certain data in a database at a given moment in time.

The DBMS accomplishes ____ by reading the log for the problem transactions and applying the before images to undo their updates.

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

What is two-phase locking?

The DBA usually creates groups of users called ____.

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

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

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.

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

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

____________________ involves maintaining a log of all updates to the database.

A(n) ____________________ is a set of steps completed by a DBMS to accomplish a single user task.