Which of the following is the correct syntax to explicitly lock a table in SHARE ROW EXCLUSIVE mode in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - Transactions and Concurrency

ALOCK TABLE my_table IN SHARE MODE ROW EXCLUSIVE;

BLOCK my_table SHARE ROW EXCLUSIVE;

CLOCK TABLE my_table SHARE ROW EXCLUSIVE;

DLOCK TABLE my_table IN SHARE ROW EXCLUSIVE MODE;

Step-by-Step Solution

Solution:

Step 1: Recall the correct LOCK syntax in PostgreSQL
The correct syntax is: LOCK TABLE table_name IN lock_mode;
Step 2: Match the syntax with the options
LOCK TABLE my_table IN SHARE ROW EXCLUSIVE MODE; matches the correct syntax exactly with 'IN SHARE ROW EXCLUSIVE MODE'.
Final Answer:
LOCK TABLE my_table IN SHARE ROW EXCLUSIVE MODE; -> Option D
Quick Check:
LOCK syntax = LOCK TABLE ... IN mode [OK]

Quick Trick: Use 'LOCK TABLE table_name IN mode;' syntax [OK]

Common Mistakes:

Master "Transactions and Concurrency" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free