Birlasoft interview question

The interviewer asked following questions: 1. What is an Array? 2. What are the differences between c, c++, java, and python? 3. Tell me some Features of Python 4. What are joins? Difference between Inner Join and Outer Join? 5. what is DBMS? what is the difference between DBMS & RDBMS? 6. WAP to find whether the given number is prime or not? 7. WAP to reverse the given string. 8. Difference between drop and Truncate. 9. OOPs with real life examples. 10. what is a trigger? 11. what is a stored procedure? 12. write a sql query to find second highest salary from employee table. 13. when HAVING is used in DBMS . what is the difference between having and where in DBMS? 14. Tell me Some SQL clauses.