Multiple choice technology databases

we can select while LOCk is on a rows

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle, readers never block writers and writers never block readers due to multiversion read consistency. When rows are locked by DML operations, other sessions can still query those rows using the before-image from undo segments. This prevents SELECT statements from waiting for row locks to be released.

Keep practicing — related questions