EchoStar Software Engineer Java interview questions

1st Interview (Engineering Manager): It was a phone interview. -Tell me about yourself -Project description -Advantages of OOPS -Types of modifiers in java -What Abstract class and interface -Difference between overloading vs overriding -Life cycle of JSP (don't forget to mention jsp are translated to servlet) -What is deadlock SQL questions -types of joins with difference between each of them -get results from table with timestamp with criteria as only year not date range eg only year =2008 no range comparison -more sql queries related to above by modifying certain conditions (AND and ORDER BY clause ) They use MAC OS for their development I said I didn't work on that OS ever so he got a bit displeased with that. Plus my previous jobs were contract based jobs so he expressed his disapproval over that stating I am a job hopper. Had to clear the air out on that since I expressed that I was looking for a permanent position and looking to settle down but he still kept that in his mind the whole time. 2nd Interview (Panel over phone for 1hr + coding on google docs): There were two guys one was ok and the other was a definitely a junior to me in terms of experience and sounded either not that aware of the answers I gave or was just plain condescending. After that the Engineering Manager sent a set of question over google docs which were to be completed in a hour -Types of access modifiers -Abstract class vs interface -transient vs volatile -Collections and how to sort objects in a collection -life cycle of a thread -life cycle of servlet and jsp -difference between servlets and jsps -difference between final, finally and finalize -Immutable classes eg String -Why is String immutable -What are marker interfaces -Garbage collection -Scope of beans in spring -What is IOC - Autowiring in spring -Types of joins -Difference between foreign and unique keys - What is hibernate session -Difference between Session and SessionInterface - What is JMS and difference between P2P and pub-sub model Coding on google docs 1) A site tracks the activity of its users and sends emails to users who have been active on the site recently. Given the table definition: `users_table`( `id` int not null primary, `name` varchar not null, `email` varchar not null, ‘salary’ number, `last_activity_time` timestamp default null) write three SQL statements to retrieve: - The email addresses and names of all users who were active this year - The ids of the 10 most recently active users - Find the 2nd highest salary of the user 2) In a Unix-like environment, you have a directory called /var/logs. There are hundreds of log files in this directory that may or may not contain the string “error”. If you wanted to aggregate all the error messages (lines containing “error”) into a file, /tmp/errors.log, how would you do this? 3) Given a String “str”, write a Java program which will count the number of occurrences of each word in that string and print out the results. For example, given the string “Do as I say not as I do”, the output should be similar to below: do: 2 as: 2 i: 2 say: 1 not: 1