281
SQL Server Interview
ASP.NET Core, EF Core & SQL Server Real-World Scenarios
SQL Server interview questions covering asp.net core, ef core & sql server real-world scenarios.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
282
What is change tracking in EF Core?
283
What does AsNoTracking() do?
284
What is the N+1 query problem?
285
What is eager loading in EF Core?
286
What is projection and why is it important for EF Core performance?
287
What is the difference between IQueryable and IEnumerable in an EF Core query?
288
How should pagination be implemented efficiently?
289
What is keyset pagination?
290
How does EF Core handle transactions?
291
What is DbContext pooling?
292
What is SQL connection pooling in an ASP.NET Core application?
293
Why should DbContext usually be scoped per web request?
294
What are EF Core migrations?
295
When would you use raw SQL or a stored procedure instead of LINQ?
296
How do you diagnose a slow EF Core query?
297
How can an ASP.NET Core application safely handle transient SQL Server failures?
298
How do you prevent duplicate records when two requests arrive at the same time?
299
An ASP.NET Core API times out while SQL Server CPU is low. What would you investigate?
300