Cognizant Interview Experience 2021
Cognizant visited our college campus after many years and thus we were guided by our TPOs very carefully with the application process. At first, a list of eligible candidates was published by the college. Then we were to create an account in AMCAT with our mail id. The registration process was to be completed by 4th December 2020. After that, the list of shortlisted candidates was published and an online exam was conducted on the AMCAT platform between 18th October to 19th October.
Round 1(Online Assessment MCQ test): The pattern was similar to that of AMCAT. It consisted of different modules:
- Aptitude(70 mins)
- Automata fix(20 mins)
- Narrative(30 mins)
Round 2(Technical Interview): Results for the MCQ test were declared via TPO on 23rd November 2020. Before that students who were eligible for GenC Next had their exams. Our interview was conducted on SmartMeet. It was a 45 minutes interview. Below are the questions I was asked:
- How was your day?
- Kindly sent your CV.
- Introduce yourself.
- Since you are good with DBMS so you must be knowing SQL.So explain different joins.
- Table A has 300 tuples, table B has 200 and among them, 100 were unique i.e. matching. So if I want all the matching tuples and the rest of the tuples of table B then which join should be used, explain.
- Explain a project that you did during the curriculum.
- Difference between PL/SQL and MySQL.
- Since you know Java as well, explain the difference between Overloading and Overriding.
- Where did you use Java in your projects?
- Write a code to print your name in vertical order.
- Write a code to count the occurrence of a given word in a PDF.
- If you are relocated to Cochin, how would I manage?
- Suppose you have planned for a weekend at home and already booked the tickets but at the last time, you get a call for some work from the office? What will you do?
- Tell me about a difficult situation in your life and how did you overcome it.
- Do you have any questions for me?
- I asked :
- How was my performance?
- How can I improve myself?
Result: Selected(GenC profile).
Results were declared on 20th December 2020.