Cognizant Programmer Analyst Trainee interview questions

In Sql they asked left join, top 3 salary, sub query, group by, order by, and write the code in pen and paper. They also asked views, acid properties, ddl, dcl, dml, tcl,

As my programming language was java so they asked java specific question like. 1. Is java platform independent? 2. Why java do not support multiple inheritance? 3. What is JVM, JRE, JDK? 4. What is java servlet? (i was not able to answer this question) 5. How we connect Sql with JDBC? (i was not able to answer this question)

In OOPs: 1. Difference between class and object? 2. 4 pillars of oops. 3. Abstract class vs Interface? 4. Types of inheritance? 5. Types of polymorphism? 6. Abstraction vs Encapsulation?