With MyISAM table locking, deadlocks do not occur because:

Question

Options

• AAll tables to be locked are sorted in an internally defined order
• BIf a table is locked with a read lock and a write lock, the write lock is set before the read lock
• CTables are locked one table at a time until the thread gets all the locks
• DNone of the above

• A
  10% (3)
• B
  3% (1)
• C
  17% (5)
• D
  70% (21)

Explanation

With table locking, the server can determine what locks are needed and acquire them before executing a statement, so deadlock never occurs.

No community discussion yet for this question.