Managing Multiuser Databases – True or False

6. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

A. True
B. False

Correct Answer:  B. False
Advertisement

7. The size of a lock is referred to as lock sizing.

A. True
B. False

Correct Answer:  B. False
Advertisement

8. When two transactions are being processed against the database at the same time they are termed concurrent transactions.

A. True
B. False

Correct Answer:  A. True
Advertisement

9. Locks placed by the DBMS are explicit locks.

A. True
B. False

Correct Answer:  B. False
Advertisement

10. In optimistic locking, the assumption is made that conflict will occur.

A. True
B. False

Correct Answer:  B. False
Advertisement

Leave A Comment?