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 for 3–4 years developers
Explore sql interview questions for 3–4 years developers 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