Process-Scheduling
October 3, 2023Operating-Systems
October 3, 2023Database-Management-System
| Question 26 |
Which level of locking provides the highest degree of concurrency in a relational database?
| Page | |
| Table | |
| Row | |
| Page, table and row level locking allow the same degree of concurrency |
Question 26 Explanation:
In page level locking, it will lock whole page i.e., all rows are highly restrictive.
Table locking can be used for concurrency control with DDL operations.
In row share table is less restrictive but it consists of highest degree of concurrency compared to page and table.
Table locking can be used for concurrency control with DDL operations.
In row share table is less restrictive but it consists of highest degree of concurrency compared to page and table.
Correct Answer: C
Question 26 Explanation:
In page level locking, it will lock whole page i.e., all rows are highly restrictive.
Table locking can be used for concurrency control with DDL operations.
In row share table is less restrictive but it consists of highest degree of concurrency compared to page and table.
Table locking can be used for concurrency control with DDL operations.
In row share table is less restrictive but it consists of highest degree of concurrency compared to page and table.