Cognizant GenC(Migrated from phase 1) Around 48 Students have attended the interview from various colleges
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)
And He moved to HR Questions
21)Are you able to work on various shifts? (Yes)
22) What are your Strengths and Weakness? (I am very flexible and i am very eager to learn new technology(Then he asked what is new Technology your learning, I instantly said cybersecurity which i mentioned in resume and he said okay and weakness was Ig i keep forgetting the things under pressure he said then How will you work, I said I will definitely overcome)
23 )Are you able to Relocate? (Yes, I gave me smile telling i am quite moving around from my childhood and he smiled back)
24)Which Technology you don't want as role in the Company? (I said Ig I'm Confidence to learn any technology provided and said as a IT person we should adopt to new things)
25) Any Question for him? (I said No Questions From me) and finally Stated him with Thank you very much...
He was Friendly and give me hints whenever I am struck But it was around 50mins which was Very Exhausting but i was Keeping my Smile probably throughout the interview.
Verdict: Got Selected