MS SQL Server - 51 - Locking MCQ

51 – Locking MCQ

Best of luck!

1 / 25

1. What is the primary purpose of a Shared Lock in SQL Server?

To grant read access to the resource while allowing other shared locks

To prevent other transactions from modifying the resource

To prevent other transactions from reading the resource

To lock a resource exclusively

2 / 25

2. In SQL Server, what type of lock is acquired by a transaction when it wants to modify a resource?

Intent Shared Lock

Exclusive Lock

Intent Exclusive Lock

Shared Lock

3 / 25

3. What is the primary purpose of an Exclusive Lock in SQL Server?

To prevent other transactions from reading the resource

To lock a resource exclusively

To grant read access to the resource while allowing other shared locks

To prevent other transactions from modifying the resource

4 / 25

4. Which type of lock is used when a transaction wants to indicate its intention to read a resource without acquiring an exclusive lock?

Intent Shared Lock

Exclusive Lock

Intent Exclusive Lock

Shared Lock

5 / 25

5. In SQL Server, what is the purpose of Intent Locks?

To lock a resource exclusively

To prevent other transactions from reading the resource

To indicate the intention of a transaction regarding higher-level locks

To grant read access to the resource while allowing other shared locks

6 / 25

6. What is the primary benefit of using Intent Shared Locks in SQL Server?

To lock a resource exclusively

To indicate the intention of a transaction to modify a resource

To prevent other transactions from accessing the resource

To grant read access to the resource while preventing modifications

7 / 25

7. In SQL Server, which type of lock indicates the intention to modify a resource without acquiring an exclusive lock?

Intent Shared Lock

Exclusive Lock

Intent Exclusive Lock

Shared Lock

8 / 25

8. What is the primary purpose of an Intent Exclusive Lock in SQL Server?

To indicate the intention of a transaction to modify a resource without acquiring an exclusive lock

To prevent other transactions from reading the resource

To lock a resource exclusively

To grant read access to the resource while allowing other shared locks

9 / 25

9. In SQL Server, what is the purpose of Shared Locks with Intent Exclusive Locks?

To prevent other transactions from modifying the resource

To indicate the intention of a transaction regarding higher-level locks

To grant read access to the resource while preventing other shared locks

To lock a resource exclusively

10 / 25

10. Which type of lock is acquired when a transaction intends to modify a resource exclusively in SQL Server?

Intent Shared Lock

Intent Exclusive Lock

Shared Lock

Exclusive Lock

11 / 25

11. What is the primary benefit of using Shared Locks in SQL Server?

To lock a resource exclusively

To indicate the intention of a transaction to modify a resource without acquiring an exclusive lock

To grant read access to the resource while allowing other shared locks

To prevent other transactions from reading the resource

12 / 25

12. In SQL Server, which type of lock indicates the intention of a transaction to modify a resource exclusively?

Shared Lock

Exclusive Lock

Intent Exclusive Lock

Intent Shared Lock

13 / 25

13. What is the primary purpose of Shared Locks with Intent Exclusive Locks in SQL Server?

To lock a resource exclusively

To grant read access to the resource while allowing other shared locks

To indicate the intention of a transaction to modify a resource exclusively

To prevent other transactions from modifying the resource

14 / 25

14. In SQL Server, when does a transaction acquire an Exclusive Lock?

When it wants to grant read access to a resource

When it wants to allow other shared locks

When it wants to modify a resource exclusively

When it wants to indicate an intention to read a resource

15 / 25

15. What is the primary purpose of Intent Exclusive Locks in SQL Server?

To indicate the intention of a transaction regarding higher-level locks

To lock a resource exclusively

To grant read access to the resource while allowing other shared locks

To prevent other transactions from modifying the resource

16 / 25

16. In SQL Server, what is the primary purpose of Shared Locks?

To grant read access to the resource while allowing other shared locks

To prevent other transactions from reading the resource

To indicate the intention of a transaction to modify a resource

To lock a resource exclusively

17 / 25

17. What is the primary benefit of using Shared Locks with Intent Exclusive Locks in SQL Server?

To prevent other transactions from modifying the resource

To grant read access to the resource while allowing other shared locks

To lock a resource exclusively

To indicate the intention of a transaction to modify a resource exclusively

18 / 25

18. In SQL Server, when does a transaction acquire an Intent Shared Lock?

When it wants to prevent other transactions from reading the resource

When it wants to indicate an intention to read a resource

When it wants to modify a resource exclusively

When it wants to allow other shared locks

19 / 25

19. What is the primary purpose of Intent Shared Locks in SQL Server?

To grant read access to the resource while allowing other shared locks

To indicate the intention of a transaction regarding higher-level locks

To prevent other transactions from reading the resource

To lock a resource exclusively

20 / 25

20. In SQL Server, what is the primary benefit of using Exclusive Locks?

To lock a resource exclusively

To prevent other transactions from reading the resource

To indicate the intention of a transaction to modify a resource without acquiring an exclusive lock

To grant read access to the resource while allowing other shared locks

21 / 25

21. What is the primary purpose of Intent Exclusive Locks in SQL Server?

To indicate the intention of a transaction regarding higher-level locks

To prevent other transactions from modifying the resource

To grant read access to the resource while allowing other shared locks

To lock a resource exclusively

22 / 25

22. In SQL Server, when does a transaction acquire an Intent Exclusive Lock?

When it wants to indicate an intention to read a resource

When it wants to prevent other transactions from modifying the resource

When it wants to allow other shared locks

When it wants to modify a resource exclusively

23 / 25

23. What is the primary benefit of using Intent Locks in SQL Server?

To lock a resource exclusively

To indicate the intention of a transaction regarding higher-level locks

To grant read access to the resource while allowing other shared locks

To prevent other transactions from reading the resource

24 / 25

24. In SQL Server, what is the primary purpose of Shared Locks with Intent Exclusive Locks?

To grant read access to the resource while allowing other shared locks

To lock a resource exclusively

To indicate the intention of a transaction to modify a resource exclusively

To prevent other transactions from modifying the resource

25 / 25

25. What is the primary benefit of using Shared Locks with Intent Exclusive Locks in SQL Server?

To grant read access to the resource while allowing other shared locks

To indicate the intention of a transaction to modify a resource exclusively

To prevent other transactions from modifying the resource

To lock a resource exclusively

Your score is

MS SQL Server – 51 – Locking MCQ