Design a dashboard API that aggregates millions of records without expensive queries on each request.
BrowserStack · 3-4-years · 0 answers
Year not specified · Java, SQL, Redis
SQL interview questions
Explore sql interview questions shared by candidates. Read available community answers and practise for your next interview.
Browse interview topics · Browse companies
Questions
How would you model hierarchical categories efficiently with SQL, JPA, and Hibernate?
Zomato · 3-4-years · 0 answers
Year not specified · Java, JPA, SQL
Compare server-side and client-side filtering for a React table backed by Spring Boot.
Zomato · 3-4-years · 0 answers
Year not specified · Java, React, SQL
Explain propagation and rollback behavior in Spring transactions, including common proxy-related mistakes.
Swiggy · 3-4-years · 0 answers
Year not specified · Java, Spring Boot, SQL
How would you migrate a very large SQL table with near-zero downtime in a Spring Boot system?
CRED · 3-4-years · 0 answers
Year not specified · Java, SQL, DevOps
Explain SQL transaction isolation and choose an approach for inventory reservation under concurrency.
Flipkart · 3-4-years · 0 answers
Year not specified · Java, SQL, System Design
How would you implement cursor-based pagination with Spring Data JPA and SQL for changing data?
Freshworks · 3-4-years · 0 answers
Year not specified · Java, JPA, SQL
How would you diagnose and fix a slow Hibernate query without simply increasing the timeout?
Zoho · 3-4-years · 0 answers
Year not specified · Java, Hibernate, SQL
Design a dashboard API that aggregates millions of records without running expensive queries on every page load.
BrowserStack · 3-4-years · 1 answers
Year not specified · .NET, SQL, Redis
How would you model and query hierarchical product categories efficiently in SQL and Entity Framework Core?
Zomato · 3-4-years · 1 answers
Year not specified · .NET, Entity Framework Core, SQL
Compare server-side filtering with client-side filtering for a React data grid backed by ASP.NET Core.
Zomato · 3-4-years · 1 answers
Year not specified · .NET, React, SQL
How would you migrate a large SQL table with near-zero downtime in a .NET application?
CRED · 3-4-years · 1 answers
Year not specified · .NET, SQL, DevOps
Explain SQL transaction isolation levels and choose one for an inventory reservation workflow.
Flipkart · 3-4-years · 1 answers
Year not specified · .NET, SQL, System Design
How do you avoid N+1 queries and cartesian explosion when loading related data with Entity Framework Core?
Flipkart · 3-4-years · 1 answers
Year not specified · .NET, Entity Framework Core, SQL
How would you implement cursor-based pagination in ASP.NET Core and SQL for a frequently changing dataset?
Freshworks · 3-4-years · 0 answers
Year not specified · .NET, ASP.NET Core, SQL
How would you diagnose and fix a slow Entity Framework Core query without hiding the problem behind a larger timeout?
Zoho · 3-4-years · 0 answers
Year not specified · .NET, Entity Framework Core, SQL
SQL Database Concepts – VARCHAR vs NVARCHAR
EPAM · not-specified · 0 answers
Year not specified · SQL
Search Index Experience: Do you have experience with search indexes — Solr, Elasticsearch?
Dodge Construction Network · not-specified · 0 answers
Asked in 2026 · SQL, Elasticsearch
Raw SQL/Stored Procedures vs EF Core: You mentioned using both raw SQL/stored procedures and EF Core — can you give a specific scenario where EF Core didn't work well, and why you needed raw SQL instead?
Dodge Construction Network · not-specified · 0 answers
Asked in 2026 · SQL, Entity Framework Core
Dense rank
HCA Healthcare · not-specified · 0 answers
Year not specified · SQL