Encora interview questions

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)