Question Bank
1899 approved questions from the community
What are window functions in SQL?
What is the difference between DELETE and TRUNCATE in SQL?
What is the difference between a clustered and non-clustered index in SQL?
What is normalization in database design?
What is the purpose of mocking in unit tests?
What is Blazor in the .NET ecosystem?
What is SignalR in ASP.NET Core?
What is the main difference between Razor Pages and MVC in ASP.NET Core?
What is the IApplicationBuilder interface used for in ASP.NET Core?
What is the 'override' keyword used for in C#?
Records in C# are immutable by default and provide value-based equality.
In C#, the 'is' keyword can be used both for type checking and pattern matching.
In C#, the 'new' keyword when used in a method declaration hides the inherited member instead of overriding it.
How are NULL values typically handled in SQL comparisons?
In C#, async methods must always return Task or Task<T>.
The 'using' statement in C# automatically calls Dispose on IDisposable objects when the block exits.
What is the difference between INNER JOIN and LEFT JOIN in SQL?
In Entity Framework, what are migrations used for?
What is the Repository pattern in software architecture?
Indexing in SQL always improves query performance without any drawbacks.