Atos-Syntel Associate Software Engineer interview questions

1st round was general aptitude like logical,resoning and then 2nd round was programming statement with technical interview round and last was hr round.1st round was at bangalore then after clearing this round the 2nd round was in chennai

The process took around 2 months first online aptitude test result of which was declared after a month. Interview was scheduled 1 month later in jaipur first there was gd and they cleared almost 90% candidates in gd in my group 10 of 10 cleared the we had tech. Interview, person who took my interview was kind of idiot or what my resume clearly stated that i am good in languages like c c++ and oops concept yet he asked me questions on database obviously i was not able to ans them at the end he asked me to write a program to find if a no. Is prime i correctly wrote the code bt still i was not through to next round