How many problems those occur due to concurrency?
a) one
b) two
c) three
d) four
Explanation: lost update problem, uncommitted dependency problem, inconsistent analysis problem
Which problem occur when two or more transactions update the same data concurrently?
a) uncommitted dependency problem
b) lost update problem
c) resource locking
d) concurrency
Which problem occur when two or more transactions update the same data concurrently?
a) uncommitted dependency problem
b) lost update problem
c) resource locking
d) concurrency
When a transaction reads several values from the database but another transaction update some of them is called?
a) uncommitted dependency problem
b) lost update problem
c) inconsistent analysis problem
d) concurrency
How many types of resource locking?
a) three
b) four
c) five
d) six
Explanation: implicit lock, explicit lock, exclusive lock, shared lock, lock granularity
Which of the following lock placed automatically by DBMS?
a) implicit lock
b) explicit lock
c) exclusive lock
d) shared lock
