Started of with self introduction , asked concepts from DBMS like primary key foreign key asked me to list out certain constraints , joins , oops , to write down basic queries and a coding question

It was an On campus Hiring. We were called to the OSI digital office to write the aptitude exam. The aptitude exam has the normal aptitude questions one can expect , speed , time , age related questions , questions on probability etc. Prepare any major exams's aptitude questions from the internet such as TCS nqt's and you are good to go. We had technical questions in the test as well , like a few coding questions on JAVA and C++. After the test the selected candidates who passed the exam were divided into groups and were sent to different conference rooms for the GD. In group discussion you can expect the run of the mill group discussion topics , Mine was the importance of soft skills. About half the people were eliminated in GD. Next were the interviews , there were 2 rounds of interview , in the first interview I was asked questions on my education , projects , future goals and my resume. The second interview was a technical interview where I had to solve a coding question and answer a bunch of technical questions on OOPs and SQL. I was asked to solve a coding question where I had to reverse the positions of only the capitalized and special characters and let the rest of the string remain the same. I got the logic right but there were a few syntax errors I made out of nervousness but the interviewer was patient and let me take my time. I got the offer after the process