Exam 9: Managing Multiuser Databases

Measures that are taken to prevent one user's work from inappropriately influencing another user's work are called ________.

Recovering a database via reprocessing involves ________.

Which type of lock still allows other transactions to have read-only access to the locked resource?

Which of the following is not true about locks?

One remedy for the inconsistencies caused by concurrent processing is ________.

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called ________.

Which of the following would a DBA typically NOT do in managing the DBMS?

Recovering a database via rollforward involves ________.

Resource locking must be carefully planned because most DBMS products cannot detect a deadlock condition.

The security provided by the DBMS often has to be augmented by additional security features within the application program.

According to ANSI SQL,the serializable isolation level will not allow phantom reads,dirty reads,and nonrepeatable reads.

In general,optimistic locking is the preferred technique for Internet databases.

Resource locking is one remedy to the lost update problem.

To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.

Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.

Two-phased locking has a growing phase and a shrinking phase.

In two-phase locking,all locks are released during the contracting phase.

Which of the following is not a database administration responsibility of a DBA?

In regard to database security,neither the DBMS nor the database applications can enforce processing responsibilities.

The database is most vulnerable to failure after a change to its structure.