2019 interview question

Cross Apply vs Cross Join
Merge query in sql
Group by query in sql
How to optimize stored procedure
One to One Relationship in sql
Normalization and what is 3rd NF
ACID Property
default exceptio  in webapi
MVC routing vs Webapi routing
Group by query in linq
Singleton
Factory method
Strategy Pattern
Abstract Factory
Prototype
Adapter
Webapi return types
IActionResutl vs HttpResponseMessage
IEnumerable Vs Iquarable
throw vs throw exception
Abstract vs Interface
Dictionary vs Concurant Dictionary
Solid Principle
DI and its trype
Unit test (NUnit and Moq)
Token based authentication vs UserName/Password
static constructor
Static class and method