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