Pergunta de entrevista da empresa Adeva

1. Difference between optimistic and pessimistic locking. 2. Write an SQL query that uses an aggregate function. 3. Write a singleton class.