C# & .NET & MS SQL Test

35 questions total, 80 minutes maximum, for mid-level programmers



Programming test includes:

C# & .NET - 20 Questions

  • C# Syntax, C# Statements: "try-catch", "using"
  • Object-Oriented Programming (OOP)
  • Entity Framework, LINQ to SQL
  • Value Types vs. Reference Types
  • Miscellaneous: Generics, Delegates, Extensions
  • Miscellaneous: Structs, Singleton Pattern, Direct Cast vs "As" Operator

MS SQL Server - 15 Questions

  • Joins, Queries
  • Grouping, Aggregate Functions, HAVING Clause
  • Subqueries, EXISTS, IN Operators
  • Miscellaneous: Ranking Functions, Foreign Key, UNION Operator, NULLs