Tip 1: Practice coding problems consistently to build strong problem-solving skills.
Tip 2: Revise core concepts like OOP, DBMS, and data structures regularly.
Tip 3: Be confident while explaining your projects and approach in interviews.
Tip 1: Keep your resume simple, clear, and limited to one page.
Tip 2: Only include skills and projects that you can confidently explain in the interview.
The online assessment was conducted during the daytime and was scheduled in advance. The environment was smooth and well-organized, ensuring fair monitoring throughout the test. Clear instructions were provided before the start, and the platform worked without any major issues. It was important to stay focused and manage time efficiently across sections. Overall, the experience was professional and hassle-free.



'N' = 5, 'ARR' = [1, 2, 3, 2, 3]
Output: 1
Except for number 1, all numbers occur an even number of times.
Step 1: I first understood the problem carefully. It was given that all coins originally appeared an even number of times, but after losing one coin, one denomination becomes odd.
Step 2: I realized that the task is to find the number that occurs an odd number of times in the array.
Step 3: Initially, I thought of using nested loops to count the frequency of each element and check which one has odd occurrences.
Step 4: Then I optimized the approach using XOR logic. I used the property that the XOR of the same numbers cancels out (A ^ A = 0), and the XOR of all elements will give the number with odd frequency.
Step 5: Finally, I applied XOR to all elements of the array and printed the result, which gave the missing coin denomination efficiently in O(n) time.
The interview was conducted face-to-face during the daytime with a panel of three interviewers, including technical, managerial, and HR representatives. The environment was professional yet comfortable, and the interaction was smooth throughout the session.
The technical interviewer focused on assessing my core concepts, problem-solving approach, and understanding of my projects. The managerial interviewer asked questions related to teamwork, handling challenges, and real-life situations. The HR interviewer evaluated my communication skills, confidence, and overall personality.
Since it was for the Prime role, the difficulty level was slightly higher, and they expected clear and structured answers. All three interviewers were supportive and gave me enough time to think and respond. Overall, it was a well-organized and positive experience.
Write a SQL query to find the second-highest salary from an Employee table without using the LIMIT clause.
Step 1: I first understood that I needed to find the second-highest distinct salary without using LIMIT, so I could not directly sort and pick the second value.
Step 2: Initially, I thought of using ORDER BY with LIMIT, but since it was restricted, I moved to using subqueries.
Step 3: I used a subquery to find the maximum salary from the table and then excluded that value.
Step 4: After excluding the highest salary, I applied the MAX function again to the remaining values to get the second-highest salary.
Step 5: This approach worked efficiently and handled duplicate values as well.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What does the SQL function NOW() return?