How to use different types of locks in SQL query?

Why or why not?

Increment the salaries by 5% and add a comm. of 300 to the existing comm, and changing the clerk to jobs of all salesman whose salary is more than or equal to 1500.