Technical- Questions

1. Compare and contrast REST and SOAP web services.
2. Define authentication and authorization and the tools that are used to support them in enterprise deployments.
3. Describe the difference between optimistic and pessimistic locking.
4. Describe the elements of an in tier architecture and their appropriate use.
5. Have you used Eclipse?
6. Have you used Visual Studio?
7. How did you manage source control?
8. How much (what percentage) of your time do you spend unit testing?
9. How much reuse do you get out of the code that you develop, and how?
10. How would you describe the ideal working environment?
11. If you know you aren't going to make a project deadline what will you tell your manager and/or the client?
12. In databases, what is the difference between a delete statement and a truncate statement?
13. In network security, what is a honey pot, and why is it used?
14. What are the most important database performance metrics, and how do you monitor them?
15. What are transaction logs, and how are they used?
16. What did you do to ensure quality in your deliverables?
17. What do you consider documentation and why is it important?
18. What do you do to ensure you provide accurate project estimates?
19. What do you expect in the solution documents you are provided?
20. What elements are necessary for a successful team and why?
21. What have you done to ensure consistency across unit, quality, and production environments?
22. What is a cross site scripting attack, and how do you defend against it?
23. What is a SAN, and how is it used?
24. What is clustering, and describe its use.
25. What is ETL and when should it be used?
26. What is most important - quality or quantity?
27. What is structure?
28. What is the difference between OLAP and OLTP? When is each used?
29. What is the role of continuous integration systems in the automated-build process?
30. What is the role of SMNP?
31. What is the role of the DMZ in network architecture? How do you enforce relational integrity in database design?
32. When is it appropriate to denormalize database design?
33. When is the last time you downloaded a utility from the internet to make your work more productive, and what was it?
34. Which do you prefer; service oriented or batch oriented solutions?