The image cncpt156.gif shows a parent table and its child table. Rows 1 through 4 of the parent table are indexed on keys 1 through 4, respectively. Row 5 in the child table is updated and acquires an exclusive row lock (key 2).
End of image description.