Process-Scheduling
October 3, 2023Operating-Systems
October 3, 2023Database-Management-System
| Question 1 |
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 1 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 1 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.
Subscribe
Login
0 Comments