Infosys | Specialist Programmer | Accepted

Online Assessment and Interview Details

• Online Assessment Questions: I don't remember the questions asked in the Online Assessment.

• Interview Date: 9th September 2024 (Offline)
  Coding Question: Remove Invalid Parentheses
  SQL Query:
  I was given two tables:

  • employee
  • salary

  I needed to print the name of all employees whose salary is the second highest.

  Fundamental Questions from DBMS, OS, and OOPS:

  1. What is a deadlock?
  2. Transactions in DBMS?
  3. Difference between inner join and outer join?
  4. Pillars of OOPS
  5. Difference between a thread and a process

• The interviewer gave me paper sheets and asked me to write the code on them, although I was asked to bring my own laptop. I provided a recursive solution to the coding question and a complete solution for the SQL question.

Interview Result: Got the result on 25th November 2024.

Questions as a Fresher

1. As Infosys has a 3-month notice period, will it affect my resume shortlisting in the future?
2. How hard will it be to switch from Infosys to a good product-based company?