does page lock locks more than one table?

Question

If I have two tables withmin size 4kb each and present in one page. If I had apply intent lock for a key in table1 for update operation then the hierrachy will be

key-> page->extent locks will be applied.

then can I able to retrive data from second table which is not involved in update operation

Answer 1

The hierarchy is object->page-row. Extents are not involved in locking. The hierarchy is always from container to contained.

Different objects (tables) cannot overlap. Pages are not shared, and since extents are not involved in locking, mixed extents do not matter.