SDE - 2

Round started with an intro about the project. In my project i have mentioned that i had use Cassandra. The interviewer asked why use Cassandra , why not other No Sql database.
After that the interviewer started asking about the java concepts. How exception propagate takes in case of polymorphism.
There a question about multilevel inheritance. There were three classes parent, child , grandchild in a multlevel inheritance.
All three classes have a function with same name.
Question was about if we call a method something like this 
Parent p = new Grandchild();
p.method1();
which class method would be called

Interviewer started with some questions about Database locks .
I had to prepare a low level design of the library management system.
Then there were follow up questions regarding how many database table you will use, normalizing those databse table, writing the service logic for one of the functionality

It was managerial round. They asked few questions about the project and why you use this particular technology.