PDG Consulting interview questions

1.Hibernate one to one and one to many mapping 2.How to delete the all entry in case of many to one. 3.Different type of cache and difference. 4.Different type of Fetch Operation n+1 problem in Hibernate and how o resolve it 1.Transaction management 2.Transaction no rollback in case of specific error 3.Isolation level 4.Prapogation 1Spring bean prototype and Request bean scope difference

Basic SQL table design followed by a system design question