Question Bank

What are attributes in C#?

In .NET, what is Just-In-Time (JIT) compilation?

Indexing in SQL always improves query performance without any drawbacks.

What is the Repository pattern in software architecture?

In Entity Framework, what are migrations used for?

What is the difference between INNER JOIN and LEFT JOIN in SQL?

What is the Large Object Heap (LOH) in .NET?

What is the difference between Task.Run and Task.Factory.StartNew in .NET?

What is lazy loading in Entity Framework?

In C#, strings are reference types even though they behave like value types in many scenarios.

What is the IDisposable interface used for in .NET?

When designing a multi-tenant database schema, which approach isolates each tenant's data in separate databases?

What is the difference between scalar functions and table-valued functions in SQL?

What is a composite key in SQL?

What is the difference between GROUP BY and HAVING in SQL?

What is the purpose of the EXPLAIN or QUERY PLAN statement in SQL?

What is the difference between EXISTS and IN operators in SQL?

How can SQL injection attacks be prevented in .NET applications?

Which of the following are benefits of using LINQ in C#? (Select all that apply)

Which of the following are advantages of using Entity Framework? (Select all that apply)