Is a shared lock assigned to each data record of the table during a full table scan as long as the query is running?
Answer Posted / Rajender Kumar
During a full table scan, a shared lock is not assigned to individual data records. Instead, an exclusive (X) lock is acquired on the entire table until the scan finishes. This prevents other transactions from modifying the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category