When two transactions are processed against database at the same time is called
a) concurrent transaction
b) usually interleaved
c) resulting in a last update
d) both a & b
The situation that occurs when one user change to the database is
lost by a second user change to the database is known as
a) concurrent update problem
b) deadly embrace problem
c) inconsistent read problem
d) inconsistent write problem
One remedy for the inconsistencies caused by concurrent process is called…
a) lost update
b) check pointing
c) rollback
d) resource locking
A lock placed by automatically by DBMS is called…….
a) exclusive
b) explicit
c) granular
d) implicit
Which of the following is not true about lock?
a) are easier for database
b) cause more conflicts
c) produce fewer details
d) table level granularity
Which type of lock prevents all type of access to locked resources?
a) exclusive lock
b) shared lock
c) two-phased lock
d) explicit lock
