Question Bank
3705 approved questions from the community
What is a foreign key in SQL?
What is the difference between DELETE and TRUNCATE in SQL?
What are window functions in SQL?
What is a Common Table Expression (CTE) in SQL?
How can SQL injection attacks be prevented in .NET applications?
What is the difference between EXISTS and IN operators in SQL?
What is the purpose of the EXPLAIN or QUERY PLAN statement in SQL?
What is the difference between GROUP BY and HAVING in SQL?
What is a composite key in SQL?
What is a materialized view in SQL?
How are NULL values typically handled in SQL comparisons?
What is the difference between scalar functions and table-valued functions in SQL?
When designing a multi-tenant database schema, which approach isolates each tenant's data in separate databases?
What is the difference between Task.Run and Task.Factory.StartNew in .NET?
What is lazy loading in Entity Framework?
What is eager loading in Entity Framework?
What keyword is used in C# to handle exceptions?
What is a multicast delegate in C#?
What are lambda expressions in C#?
What is covariance and contravariance in C# generics?