Multiple choice technology packaged enterprise solutions

Which of the following is true with locking?

  1. No data can be updated while it is being read

  2. No data can be read while it is being updated

  3. While SQL statement gets executed automatically DBA locks data called implicit locking

  4. All the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
AI explanation

Under standard locking behavior, a row being updated blocks other transactions from reading it (in some isolation models) and definitely blocks other writers, and equally, data being read under certain lock modes can block writers. Implicit locking is also correctly described — the database automatically applies locks during SQL execution without the DBA manually issuing lock commands. Since each individual statement is true, 'All the Above' is the right combined answer.

Keep practicing — related questions