A(n)____ lock will prevent any DDL operations from being performed on the locked table.
A) shared
B) exclusive
C) partial
D) partitioned

Question

A(n)____ lock will prevent any DDL operations from being performed on the locked table.​
A) ​shared
B) ​exclusive
C) ​partial
D) ​partitioned

Quizplus · Accepted Answer

An exclusive lock will prevent any DDL operations from being performed on the locked table. A shared lock still allows some DDL operations to be performed. Partial and partitioned locks do not apply to preventing DDL operations.

A(n)____ Lock Will Prevent Any DDL Operations from Being Performed