Exam 7: Dbms Functions

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

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

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

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

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

The DBA usually creates groups of users called ____.​

One guideline for writing programs for concurrent updates in a PC-based DBMS states that if an update transaction must lock more than one row in the same table,the whole table must be locked.​

Smart cards have built-in circuits containing processing logic to identify the cardholder.​

Discuss the advantages and disadvantages of timestamping.​

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

The more important it is to avoid redoing work,the more often you should make backups.​

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

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

In a PC-based DBMS,as long as one program has a row or table locked,no other program may access that row or table.​

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

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

If two or more users are waiting for the other user to release a lock before they can proceed,this is known as a ____.​

Encrypted data can be read by a word processor program.​

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

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