Cognizant Software Engineer Associate interview questions

Initially they have asked about my HR questions relocation flexibility and shifts flexibility, later they continued with technical session with 2 codes compilation in our language preference then a joins SQL query to explain, finally some fundamental questions in DBMS and Java Collections

It was on campus interview, after online assessments interviews were conducted by company, each interviews were 20-30 mins long where question were based on projects introduction, resume based but mainly focused on python and its concepts.