Java/J2EE Job Interview Companion

Have you got the time to read 10 or more books and articles to add value prior to the interview? This book has been written mainly from the perspective of Java/J2EE job seekers and interviewers. There are numerous books and articles on the market covering specific topics like Java, J2EE, EJB, Design Patterns, ANT, CVS, Multi-Threading, Servlets, JSP, emerging technologies like AOP (Aspect Oriented Programming), Test Driven Development (TDD), Dependency Injection Dl (aka IoC - Inversion of Control) etc. But from an interview perspective it is not possible to brush up on all these books where each book usually has from 300 pages to 600 pages. The basic purpose of this book is to cover all the core concepts and key areas, which all Java/J2EE developers, designers and architects should be conversant with to perform well in their current jobs and to launch a successful career by doing well at interviews. The interviewer can also use this book to make sure that they hire the right candidate depending on their requirements. This book contains a wide range of topics relating to Java/J2EE development in a concise manner supplemented with diagrams, tables, sample codes and examples. This book is also appropriately categorized to enable you to choose the area of interest to you. This book will assist all Java/J2EE practitioners to become better at what they do. Usually it takes years to understand all the core concepts and key areas when you rely only on your work experience. The best way to fast track this is to read appropriate technical information and proactively apply these in your work environment. It worked for me and hopefully it will work for you as well. I was also at one stage undecided whether to name this book "Java/J2EE core concepts and key areas" or "Java/J2EE Job Interview Companion". The reason I chose "Java/J2EE Job Interview Companion" is because the core concepts and key areas discussed in this book helped me to be successful in my interviews, helped me to survive and succeed at my work regardless what my job (junior developer, senior developer, technical lead, designer, contractor etc) was and also gave me thumbs up in code reviews. This book also has been set out as a handy reference guide and a roadmap for building enterprise Java applications.

http://www.mediafire.com/?sml2twnvyxy

Visual Basic and SQL Server interview questions

1. What is the difference between modal and modaless form in VB?
2. Why we need a MDI form? How can we make a form as a mdichild form?
3. Specify technical & functional architecture of your last 2 projects.
4. What are the objects in ADODB?
5. What are different types of cursors in ADODB?
6. What are different types of locks in ADODB?
7. What is disconnected recordset?
8. Besides Standard Exe what are other types of projects in VB?
9. What is the difference among Standard EXE, Active-X DLL, Active-X EXE?
10. A standard exe contains a registered Active-X DLL. Now some error arise in the application but not in the standard exe , it is in the Active-X DLL. How do you find it out in which line no the error is?
11. How can we find out that a recordset is blank (without using recordcount property)?
12. What is the difference between procedure and functions in VB?
13. What are the differences between stored procedure and functions in SQL Server 2000?
14. I want to develop a stand alone application which can communicate with the existing applications in the system. On which this application should be based on: Standard Exe,Active-X Exe,Active-X Dll.
15. can we call stored Procedure in Function in Sql Server 2000 and vice versa.
16. What is an extended Stored Procedure?
17. What is Trigger?
18. Suppose I made an after Trigger on Delete. Now I fire Delete * From tablename. will this trigger work? Now do I fire truncate from table name (instead of delete command). will this trigger work now? If yes or no then why?
19. What is a view? is View updatable?
20. What is the difference between having and where clause?
21. Why we need a group by clause?
22. What is a join and their types?
23. What is the difference between referencing and joining?
24. What is the difference between constraints and triggers?
25. What is the maximum size of form to hold the controls?
26. Write the correct order of execution of following form’s events: initialization, Load, Activate, Refresh , Paint
27. What is ACID Property of Transaction?
28. How do we call MS- Excel in VB?
29. What does option Explicit means?
30. What is an index?
31. What is normalization and its forms?
32. What does Query_unload event do in VB? Why we need Form _unload event?
33. What is a cursor in SQL Server 2000 and their types?
34. How do we get month name in SQL Server 2000, Oracle, MS Access?
35. How do we return a record set from a Stored Procedure in SQl server 2000?
36. What are the magic tables in SQL Server 2000?
37. What is Enum in VB?

There are 2 tables:
EMP : EmpId, Ename, Sal, DeptId
DEPT : DeptId, Dname

38. Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows “No Department”.
39. Write a query to find out those department names which has no employee.
40. Write a query to find out those employees whose salary is greater than their department’s average salary.
41. How do we get current date in SQL Server 2000, Oracle, MS Access?