Assistant IT Question:

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