Managing Multiuser Databases - Study Mode
[#1] Locks placed by command are called ________ .
Correct Answer
(B) explicit locks
[#2] Which of the following locks the item from change but not from read?
Correct Answer
(D) Shared lock
[#3] Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Correct Answer
(B) Phantom read
[#4] A transaction for which all committed changes are permanent is called:
Correct Answer
(D) durable.
[#5] In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Correct Answer
(A) Read committed