Solutions 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
Explain how to scale from a single 5 user database to a 50 user, 500 user, 5000 user and then 5 million user database and explain how to overcome each hurdle. Explain the difference between raid0, 1, 5, 6, 10, 50 and 60 Explain the differences between C, C++ and C# Write a piece of code to turn a recursive operation into a non recursive one