Which type of lock allows other transactions to have read-only access to locked resource?
a) exclusive lock
b) shared lock
c) two-phased lock
d) explicit lock
Which of the following is not true about two-phased lock?
a) make transactions serializable
b) uses only share lock
c) has growing phase
d) has shrinking phase
The situation that occurs when two users are waiting for a resource that other person has locked?
a) lost update problem
b) deadlock
c) inconsistent read problem
d) inconsistent write problem
Requiring all application programs to lock resources in same order prevents what problem?
a) concurrent update
b) lost update
c) deadlock
d) exclusive locks
Locks that are placed assuming that a conflict will occur are called…….
a) dynamic lock
b) explicit lock
c) implicit lock
d) pessimistic lock
Once processing rights have been defined may be implemented at any level EXCEPT
a) network
b) operating system
c) data
d) DBMS
