interview questions

1.draw architect design of the project you worked on.
2. SQL;
employee, dept
find departid which has duplicate employee name

SELECT name, departid  COUNT(name) AS NumOccurrences FROM employee GROUP BY name,departid HAVING ( COUNT(name) > 1 )

find the person who has the highest salary in one dept

select name

where salary = (select max(salary)

from employee

group by departid )

from employee
3. List
sort the list
(calling Collection.sort)
4.tapestry design
5.java jdbc calls what is the common mistakes
6. http protocol
7. WAR config
8. webservices structure

(ST)