Cognizant Programmee Analyst interview questions

1.was asked to write sql query given a scenario. (I used inner join.) 2.About all types of joins in sql. 3.java coding question - To count vowels given a string. 4.was asked to code exception handling in java. 5.Given a code snippet was asked to explain the code and what will be the output. It was related to polymorphism (method overloading and over riding). 6.what is static variable and static methods? 7.what is final variable? define an example final variable in the code editor. 8.what is lambda expression? 9.what is difference between java 8 and java 13? 10.list some new features of java8. 11.what is the use of finally block? code one example 12.list some aggregate functions in sql 13.write a query to find second highest salary from the employee table.