Cognizant Software Developer interview questions

1st Round (Some Aptitude Questions and Communication Round) 2nd Round (Technical Questions and Basic Coding Questions with basic SQL queries) SQL -> JOINS WHERE Clause Coding -> Valid Password Arctic Temperature Tracker 3rd Round (Technical Interview + HR) 1) Introduce yourself (I Answered) 2) About the project (I Gave answer) 3) Remove duplicates in array (I Gave answer) 4) Sub-Queries(MySQL) (He Gave me Hint) 5) DDL and DML differences (I Gave answer) 6) ACID Properties explanation (I Gave answer) 7) Difference between set and tuple (I Gave answer) 8) What are lists? (I Gave answer) 9) What is Dictionary? (I Gave answer) 10) Reverse a String(But in one line) (He Gave me some Hint after i took time to think) 11) Remove Duplicates in list in one line (Done using Set()) 12) Why we use COMMIT in SQL (I gave answer) 13) Given a code to guess output (I gave him wrong answer but then after some time i was able to crack it) 14) What are types of Joins? (I gave answer) 15) What is Self Join? (Not able to Answer as I don't know exactly) He said No Problem 16) What is __init__ method? (I gave answer) 17) What is Inheritance? (I gave answer) 18) Difference between DELETE and TRUCATE (Not Sure able TRUCATE But I was Confident) 19) What is pass keyword? (I was able to give general Answer) 20) what are args and *args ?(Unable to answer)