Exclusive - only one user can read/write/update
Share - Only one user can update/write. Others r allowed to read
Update - (i will get u that later)
Intent - These r like indicators. If a job is using some table say "A"
and other job want to access the same. This lock jus says about the status of the table. That is it gives information about which job is currently using that and for what sort of operation and all related stuff.
Intent locks r further classified into different categories.
(I will get u the other information tommorrow).