Architect interview questions shared by candidates
What does ORM mean? What are the advantages of using an ORM? What are some commercially available ORMs?
Object-Relational Mapping. Advantages: Lets the devloper deal with objects in the business domain instead of database tables (relations). Manages connection and possibly transactions. Some ORMs can abstract from the relational model and span several different data sources, including files or XML, or connect to different DB servers, abstracting from the particular query language used. If working with an IDE, having the relational model as an object model can provide syntax help (like Visual Studio's IntelliSense). Unfortunately, I have seen in several projects how at the end of the project, when deployment is on its way and real-world performance becomes an issue, that developers start to circumvent the ORM and write native SQL. Recently I heard the opinion "ORMs considered harmful", so I'm not a totally convinced proponent of ORMs. Example ORMs (from the .Net world): nHibernate, LinQ to SQL, Entity Framework. And of course everything here: http://en.wikipedia.org/wiki/List_of_object-relational_mapping_software
Describe a situation with examples where you faced a challenge in your career and how you have resolved it (with examples) How do you go about leading the team? Describe a situation where you felt you were not being heard and how did you go about putting your views across Tell us about your skills (Focus on the requirements of the Job) What are your key strengths