InnoEye Technologies Software Developer (Java) interview questions

It consists of 2 rounds: 1-It has two parts: a)Aptitude-30 Questions on logical reasoning,10 on computer fundamentals(OS,DB,NETWORKING),30 on JAVA b)Its purely coding- 3 Questions on SQL queries-count no of employees belonging to a particular city,concate first & last name separated by , 3 Questions on JAVA- WAP to display prime numbers from a given range,Display the count of occurence of the given alaphabet in a string. After first round they selected 68 among 350. 2-Video round-10 Questions having 3 subquestions each. 1- Tell us about yourself a) gaps if any & reasons for the same b) academic background 2- Details about your project a) Technologies used b) Team size,DB structure of your project c) Brief about any java class which you have implemented in your project 3- How can you deploy java servlet without using IDE If there are multiple servlets then explain all the phases the object has to go through in respect to servlet lifecycle 4- What do you know about CSS,JAVASCRIPT Have you used it yet if yes tell the features of javascipt's latest version 5- What do u mean by static method? When it gets executed If several classes contain static block then in which order they will get executed 6- Write a query for counting customers who have not placed any order yet 7- What is index in DB? how to decide when to use which 8- How many types of jdbc are there & how to decide when to use which? 9- What is the difference between multithreading,multitasking & multiprocessing How CPU makes use of cache memory 10- Difference between IPV4 & IPV6 a) What is DHCP? How your PC can search for a DHCPserver b) How can you change IPaddress of your PC

I applied online through company website. Then HR contacted me. He was very humble and told me about the interview process. There were 2 rounds. The first round was the online test consists of MCQ's from Java and Aptitude. 3 programming questions and 3 sql queries. Process took one week I got selected.