Encora interview questions

How to roll back all transactions if one of them fails in a number of transactions.
How to persist a transaction if one of them fails in a number of transactions. Answer in this link > https://medium.com/geekculture/spring-transactional-rollback-handling-741fcad043c6
Emp id name depid projid

Dep id name

Pro id name

List of dep names at least one employee tag to atlas one project

my answer for SQL was this :)

Select e.depid,d.name from dep d,emp e, (select p.id from proj groupby e.depid having count(e.depid>0)) as proj

where e.depid=d.id and proj.id=e.projid groupby e.depid having count(e.depid>0)

Insights