Question

A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

(a) Database-level lock

(b) Table-level lock

(c) Page-level lock

(d) Row-level lock

I got this question during an interview.

This interesting question is from Multiversion Schemes in section Concurrency Control of Database Management

Answer 1

Right answer is (a) Database-level lock

To explain: Data base-level lock prevents the use of any tables in the data base from one transaction while another transaction is being processed.