I applied through college or university. The process took two days.

In the first round, there were 60 questions:

• 20 from aptitude, which mainly included Permutations and Combinations (P&C), profit and loss, analytical reasoning, data interpretation, time and work, simple and compound interest (SI and CI), and probability.
• 20 from programming skills, which mainly included concepts of strings, pointers, functions, storage classes, Object-Oriented Programming (OOP), and arrays.
• 20 from the technical section, which mainly included basics of Data Structures (DS), Operating Systems (OS) like LRU replacement and scheduling algorithms, microprocessors including addressing modes, digital electronics, and computer networking.

Remember: Each question carries +1 mark for a correct answer and 0.25 marks for a wrong answer. There was also an individual sectional cut-off, which may have been around 65%.

Twenty-four students were selected after the first round; I was one of them.

Next, there were three interview rounds.

INTERVIEW 1 (Technical Behavior) The interviewer was very friendly and asked some questions related to my project. Basically, they assess how well you can practically implement the technologies you have mentioned on your resume. After this round, 19 students were shortlisted for the next round, and I was one of them.

INTERVIEW 2 (Technical) As I had mentioned SQL Server in my resume, he asked questions related to it, such as string functions, which included Charindex, Ltrim, Rtrim, Replicate, etc. He asked me how I would differentiate between a large database of my company and a database that is related only to me. Then he asked me what I knew about RDBMS and its features. As I had mentioned C#, he asked about auto-implemented properties in C#. Next, he asked about a difficult situation that I had faced in my life and how I was able to handle it. He also asked me to code for Insertion Sort. Next, he asked about the different types of operating systems and the concept of scheduling algorithms. Then we had a healthy discussion about the real-life applications of scheduling algorithms. After this, 11 students were shortlisted for the last HR round.

INTERVIEW 3: HR ROUND The interviewer was very friendly. She asked me to tell her about myself. She asked about my plans for higher studies. She inquired about my experience of college life. And she asked how my placement experience in college had been so far. At last, she asked if I had any questions. I asked her about the internship period and details about the internship. At last, we had a healthy discussion about the qualities that a human being should have while giving presentations. At last, 9 students were selected from my college, and I was one of them.

For the HR round, please be very honest and try to show your true self, otherwise, they will catch you.

ALL THE BEST FOR YOUR EXAM.

Recent changes in SQL Server 2017 and how it is being used nowadays.