SQL queries:
delete duplicate records from the table,
Nth highest salary,
Select 2 from employee,
Basic joins
Python:
1.Create list of integers from a list of string containing integers ( 'a_101_z', 'b_103_z')
2. String replace with characters based on dictionary values
3. 2nd highest array element without using inbuilt methods and functions
4. Smallest repeating substring
And there were some questions around project, Apache Kafka, basic data warehousing concepts, acid properties in rdbms etc