Question

You have been asked to lock employee table using the LOCK TABLE… which type of lock you will  
use here?

Answer 1

LOCK TABLE employee IN ROW SHARE MODE MOWAIT;