Cognizant Trainee Programming Analyst interview questions

We had an Aptitude test and the selected candidates were sent for an interview with technical and HR officers. People qualifying Technical were sent to HR and the shortlisted candidates were given date of joining with in a month of leaving the college.

First Round- Online Aptitude and 2 Programs(GCD &Sorting array) Second Round-Technical He asked me about OOPS,Types of classes,Types of programming language,Final year project and told me to write an SQL query(Alias and finding the Avg)