Home/Companies/Microsoft
M

Microsoft Interview Questions

Balanced across Java, Spring Boot, and SQL. Backend roles test REST API design, database optimization, and cloud-native patterns.

400questions
265coding problems
68 Easy200 Medium132 Hard

Coding problems asked at Microsoft

Showing 50 focused problems from 265 tagged at Microsoft, foundational ones first.

Browse full bank

Company tags come from reported interview questions and are a guide, not a guarantee of what you will be asked.

#1What is the difference between == and .equals() in Java?

Easy
Core JavaJava

#2What is the difference between abstract class and interface?

Easy
OOPJava

#3Explain the SOLID principles.

Medium
OOPJava

#4How does HashMap work internally?

Medium
CollectionsJava

#5What is the difference between HashMap and ConcurrentHashMap?

Medium
CollectionsJava

#6Explain Java Memory Model: Heap, Stack, and Metaspace.

Medium
JVMJava

#7What is the volatile keyword in Java?

Medium
ConcurrencyJava

#8What is the difference between synchronized and ReentrantLock?

Hard
ConcurrencyJava

#9What is a deadlock and how do you prevent it?

Hard
ConcurrencyJava

#10What are functional interfaces and lambda expressions in Java 8?

Easy
Java 8+Java

#11What is Optional and when should you use it?

Easy
Java 8+Java

#12Explain the Stream API and intermediate vs terminal operations.

Medium
Java 8+Java

#13What is the difference between checked and unchecked exceptions?

Easy
Core JavaJava

#14What is the difference between String, StringBuilder, and StringBuffer?

Easy
Core JavaJava

#15What is garbage collection? How does G1 differ from ZGC?

Hard
JVMJava

#16What is method overloading vs method overriding?

Easy
OOPJava

#17What is the Java ClassLoader hierarchy?

Hard
JVMJava

#18What is the difference between final, finally, and finalize?

Easy
Core JavaJava

#19What are Java records (Java 16+)?

Medium
Java 8+Java

#20What is the Executor framework and when would you use it over raw Threads?

Medium
ConcurrencyJava

#21What is encapsulation and how is it achieved in Java?

Easy
OOPJava

#22What is polymorphism? Explain runtime vs compile-time polymorphism.

Easy
OOPJava

#23What is the difference between composition and inheritance?

Medium
OOPJava

#24What is a marker interface? Give examples.

Medium
OOPJava

#25What are the design patterns most commonly asked in Java interviews?

Medium
OOPJava

#26How do you implement a Singleton in Java correctly?

Hard
OOPJava

#27What is the difference between ArrayList and LinkedList?

Easy
CollectionsJava

#28What is the difference between HashSet, LinkedHashSet, and TreeSet?

Easy
CollectionsJava

#29What is the difference between HashMap and TreeMap?

Easy
CollectionsJava

#30What is the contract between equals() and hashCode()?

Medium
CollectionsJava

#31What is the difference between fail-fast and fail-safe iterators?

Medium
CollectionsJava

#32What is CopyOnWriteArrayList and when should you use it?

Medium
CollectionsJava

#33How does PriorityQueue work and when would you use it?

Medium
CollectionsJava

#34What is the happens-before relationship in Java Memory Model?

Hard
ConcurrencyJava

#35What is the difference between sleep(), wait(), and yield()?

Medium
ConcurrencyJava

#36What are atomic classes (AtomicInteger, AtomicReference)? How do they work?

Medium
ConcurrencyJava

#37What is a CountDownLatch vs CyclicBarrier?

Medium
ConcurrencyJava

#38What is a ThreadLocal and what are its dangers?

Hard
ConcurrencyJava

#39What is a CompletableFuture and how does it improve async programming?

Hard
ConcurrencyJava

#40What are virtual threads (Project Loom, Java 21)?

Hard
ConcurrencyJava

#41What is the difference between JDK, JRE, and JVM?

Easy
JVMJava

#42How does the JIT (Just-In-Time) compiler work?

Hard
JVMJava

#43What is the difference between minor GC, major GC, and full GC?

Hard
JVMJava

#44What tools do you use to diagnose JVM memory issues?

Hard
JVMJava

#45What is the String pool and how does string interning work?

Medium
JVMJava

#46What is type erasure in Java generics?

Hard
GenericsJava

#47What is the difference between <? extends T> and <? super T>?

Hard
GenericsJava

#48What are sealed classes (Java 17)?

Medium
Java 8+Java

#49What is pattern matching for instanceof (Java 16)?

Medium
Java 8+Java

#50What are text blocks (Java 15)?

Easy
Java 8+Java

#51What is the difference between map() and flatMap() in streams?

Medium
Java 8+Java

#52What are method references in Java 8?

Easy
Java 8+Java

#53What is the difference between Comparable and Comparator?

Medium
CollectionsJava

#54What is Stream.collect() and what are common Collectors?

Medium
Java 8+Java

#55What is try-with-resources and how does it work?

Medium
Exception HandlingJava

#56What is the difference between throw and throws?

Easy
Exception HandlingJava

#57What is exception chaining and why is it important?

Medium
Exception HandlingJava

#58What is the difference between Java IO and NIO?

Medium
Core JavaJava

#59What is Java Serialization and what are its pitfalls?

Hard
Core JavaJava

#60What is reflection in Java and when is it used?

Medium
Core JavaJava

#61What is the difference between deep copy and shallow copy?

Medium
Core JavaJava

#62What is autoboxing and unboxing? What are the performance implications?

Medium
Core JavaJava

#63What are enums in Java and what advanced features do they support?

Medium
Core JavaJava

#64What is the difference between static and instance initializer blocks?

Medium
Core JavaJava

#65What is the difference between String.format() and String.formatted()?

Easy
Core JavaJava

#66What is the var keyword (Java 10) and when should you use it?

Easy
Java 8+Java

#67What are Java modules (Java 9 — JPMS)?

Hard
Java 8+Java

#68What is the difference between an inner class, static nested class, and anonymous class?

Medium
OOPJava

#69What are the new switch expressions (Java 14)?

Medium
Java 8+Java

#70What is the difference between Runnable, Callable, and Future?

Medium
ConcurrencyJava

#71What is the difference between String.equals() and String.equalsIgnoreCase()?

Easy
Core JavaJava

#72What is the difference between Iterator and ListIterator?

Easy
CollectionsJava

#73What is the difference between abstract class and concrete class?

Easy
OOPJava

#74How do you handle NullPointerException in Java?

Medium
Exception HandlingJava

#75What is the Collections utility class? What are its most important methods?

Easy
CollectionsJava

#76What is the difference between Deque and Queue?

Medium
CollectionsJava

#77What is a WeakHashMap and when would you use it?

Hard
CollectionsJava

#78What is the difference between checked and unchecked exceptions — best practices for APIs?

Medium
Exception HandlingJava

#79What is the ternary operator and the null-coalescing equivalent in Java?

Easy
Core JavaJava

#80What is the difference between == null check and Objects.isNull()?

Easy
Core JavaJava

#81What is the difference between interface default methods and abstract class methods?

Medium
OOPJava

#82What is the difference between Iterable and Iterator?

Easy
CollectionsJava

#83What are the best practices for writing clean Java code?

Medium
Core JavaJava

#84What is the difference between a process and a thread in Java?

Easy
ConcurrencyJava

#85What is a race condition and how do you prevent it?

Medium
ConcurrencyJava

#86What is the difference between HashMap.computeIfAbsent() and getOrDefault()?

Medium
CollectionsJava

#87What is the purpose of the transient keyword?

Medium
Core JavaJava

#88What is method hiding in Java?

Hard
OOPJava

#89What is the difference between i++ and ++i in Java?

Easy
Core JavaJava

#90What are the Java 8 Date/Time APIs and why were they introduced?

Medium
Java 8+Java

#91What is the difference between HashMap.put() and HashMap.putIfAbsent()?

Medium
CollectionsJava

#92What is the difference between String.valueOf() and toString()?

Easy
Core JavaJava

#93What is an immutable class and how do you create one?

Medium
OOPJava

#94What is the covariant return type in Java?

Medium
OOPJava

#95What is the difference between static and instance methods?

Easy
OOPJava

#96What is the difference between Predicate.and(), Predicate.or(), and Predicate.negate()?

Medium
Java 8+Java

#97What is the Observer pattern and how is it implemented in Java?

Medium
OOPJava

#98What is the Strategy pattern in Java?

Medium
OOPJava

#99What is String.intern() and when should you use it?

Hard
Core JavaJava

#100What are the key differences between Java 8, 11, 17, and 21?

Medium
Java 8+Java

#101What is auto-configuration in Spring Boot?

Medium
Core ConceptsSpring Boot

#102What is @SpringBootApplication and what does it do?

Easy
Core ConceptsSpring Boot

#103What is IoC (Inversion of Control) and Dependency Injection?

Easy
Core ConceptsSpring Boot

#104What is the difference between @Component, @Service, and @Repository?

Easy
Core ConceptsSpring Boot

#105What is the difference between @Controller and @RestController?

Easy
REST APISpring Boot

#106Explain @Transactional and its propagation levels.

Hard
Data AccessSpring Boot

#107How does Spring Boot handle exceptions globally?

Medium
REST APISpring Boot

#108What is Spring Boot Actuator?

Easy
ProductionSpring Boot

#109What is the difference between @Bean and @Component?

Medium
Core ConceptsSpring Boot

#110Explain Spring Bean scopes.

Medium
Core ConceptsSpring Boot

#111What is Spring AOP and where is it used?

Hard
AdvancedSpring Boot

#112What is circular dependency and how do you fix it?

Hard
AdvancedSpring Boot

#113How do you configure Spring profiles?

Easy
ConfigurationSpring Boot

#114How does Spring Security authentication work?

Hard
SecuritySpring Boot

#115What is @Async in Spring Boot and how does it work?

Medium
AdvancedSpring Boot

#116What is Spring Data JPA and how does it simplify data access?

Medium
Data AccessSpring Boot

#117How does Spring Boot externalized configuration work?

Medium
ConfigurationSpring Boot

#118What is Spring Cache Abstraction and how do you use it?

Medium
AdvancedSpring Boot

#119What are Spring Boot starters and why are they useful?

Easy
Core ConceptsSpring Boot

#120How do you write integration tests in Spring Boot?

Medium
TestingSpring Boot

#121What is the Spring ApplicationContext and how does it differ from BeanFactory?

Medium
Core ConceptsSpring Boot

#122What is a BeanPostProcessor and when would you use it?

Hard
Core ConceptsSpring Boot

#123What is the @PostConstruct and @PreDestroy lifecycle?

Medium
Core ConceptsSpring Boot

#124What is @Qualifier and when do you need it?

Medium
Core ConceptsSpring Boot

#125How does Spring Boot auto-configuration work under the hood?

Hard
Core ConceptsSpring Boot

#126What is @ConfigurationProperties and how does it differ from @Value?

Medium
ConfigurationSpring Boot

#127What is Spring Boot's embedded server and how do you switch from Tomcat to Undertow?

Medium
Core ConceptsSpring Boot

#128What is Spring's @EventListener and ApplicationEvent?

Medium
AdvancedSpring Boot

#129What is @Conditional and how do you create custom conditions?

Hard
AdvancedSpring Boot

#130What is Spring Boot DevTools?

Easy
Core ConceptsSpring Boot

#131What is the difference between @RequestParam, @PathVariable, and @RequestBody?

Easy
REST APISpring Boot

#132How do you implement request validation in Spring Boot?

Medium
REST APISpring Boot

#133What is ResponseEntity and when should you use it?

Medium
REST APISpring Boot

#134What is content negotiation in Spring MVC?

Medium
REST APISpring Boot

#135How do you implement pagination and sorting in Spring Boot?

Medium
REST APISpring Boot

#136What is HATEOAS and does Spring Boot support it?

Hard
REST APISpring Boot

#137How do you version a REST API in Spring Boot?

Medium
REST APISpring Boot

#138What is the difference between findById() and getById() in Spring Data JPA?

Medium
Data AccessSpring Boot

#139What are JPA entity states (Transient, Managed, Detached, Removed)?

Hard
Data AccessSpring Boot

#140What is the difference between @OneToMany with fetch LAZY vs EAGER?

Medium
Data AccessSpring Boot

#141What is Hibernate first-level cache and second-level cache?

Hard
Data AccessSpring Boot

#142What is the Open Session in View (OSIV) pattern and why is it controversial?

Hard
Data AccessSpring Boot

#143What is a Spring Data JPA Specification and when would you use it?

Hard
Data AccessSpring Boot

#144What is CSRF and how does Spring Security handle it?

Medium
SecuritySpring Boot

#145How do you implement JWT authentication in Spring Boot?

Hard
SecuritySpring Boot

#146What is the difference between @Secured, @PreAuthorize, and @RolesAllowed?

Medium
SecuritySpring Boot

#147What is CORS and how do you configure it in Spring Boot?

Medium
SecuritySpring Boot

#148What is OAuth2 and how does Spring Security support it?

Hard
SecuritySpring Boot

#149What is MockMvc and how do you use it?

Medium
TestingSpring Boot

#150What is @MockBean vs @Mock in Spring Boot tests?

Medium
TestingSpring Boot

#151What is @DataJpaTest and how does it differ from @SpringBootTest?

Medium
TestingSpring Boot

#152What is Testcontainers and how does it improve Spring Boot tests?

Medium
TestingSpring Boot

#153What is Micrometer and how does it integrate with Spring Boot Actuator?

Medium
ProductionSpring Boot

#154How do you implement custom health indicators in Spring Boot?

Medium
ProductionSpring Boot

#155How do you implement distributed tracing in Spring Boot?

Hard
ProductionSpring Boot

#156What is graceful shutdown in Spring Boot and how do you configure it?

Medium
ProductionSpring Boot

#157What is a Filter vs HandlerInterceptor in Spring Boot?

Hard
AdvancedSpring Boot

#158What is @ControllerAdvice and how does it work?

Medium
REST APISpring Boot

#159What is Spring WebFlux and how does it differ from Spring MVC?

Hard
AdvancedSpring Boot

#160What is Spring's @Scheduled and how do you configure it?

Medium
AdvancedSpring Boot

#161What happens during Spring Boot startup?

Hard
Core ConceptsSpring Boot

#162What is CommandLineRunner and ApplicationRunner?

Easy
Core ConceptsSpring Boot

#163What is Spring Boot's banner and how can you customize it?

Easy
Core ConceptsSpring Boot

#164What is Spring Boot's fat JAR and how is it structured?

Hard
Core ConceptsSpring Boot

#165What is Spring Retry and how do you use it?

Medium
AdvancedSpring Boot

#166What is Spring Integration vs Spring Batch?

Hard
AdvancedSpring Boot

#167What is @Transactional readOnly = true and what does it optimize?

Medium
Data AccessSpring Boot

#168What is the difference between Spring @Repository exception translation and JDBC exceptions?

Hard
Data AccessSpring Boot

#169How do you handle file uploads in Spring Boot?

Medium
REST APISpring Boot

#170What is the difference between @RequestMapping and specific mapping annotations?

Easy
REST APISpring Boot

#171What is Spring Cloud and its key components?

Hard
AdvancedSpring Boot

#172What is the difference between @Transactional on a class vs a method?

Medium
Data AccessSpring Boot

#173What is Spring Boot's connection pool? How do you tune HikariCP?

Medium
Data AccessSpring Boot

#174What is Spring Boot's auto-configuration for messaging (RabbitMQ / Kafka)?

Medium
AdvancedSpring Boot

#175What is Spring's @Lookup annotation?

Hard
Core ConceptsSpring Boot

#176What is Spring Security's method security and how is it different from URL security?

Hard
SecuritySpring Boot

#177How does Spring Boot handle environment-specific properties?

Medium
ConfigurationSpring Boot

#178What is the purpose of @EnableJpaAuditing?

Medium
Data AccessSpring Boot

#179How do you implement rate limiting in Spring Boot?

Hard
AdvancedSpring Boot

#180What is the difference between eager and lazy initialization in Spring Boot?

Medium
Core ConceptsSpring Boot

#181What is Spring Boot's support for caching with Redis?

Medium
AdvancedSpring Boot

#182What is Spring Boot's support for MongoDB?

Medium
Data AccessSpring Boot

#183What is @Transactional self-invocation problem and how do you fix it?

Hard
AdvancedSpring Boot

#184What is the difference between @Valid and @Validated in Spring?

Medium
REST APISpring Boot

#185What is Spring Boot's support for scheduled tasks with Quartz?

Hard
AdvancedSpring Boot

#186What is Spring Data REST and how does it differ from Spring MVC?

Medium
Data AccessSpring Boot

#187What is the difference between @Inject and @Autowired?

Easy
Core ConceptsSpring Boot

#188What is Flyway and how does it integrate with Spring Boot?

Medium
Data AccessSpring Boot

#189What is Spring Boot's support for WebSockets?

Hard
AdvancedSpring Boot

#190How do you implement a multi-tenant application in Spring Boot?

Hard
AdvancedSpring Boot

#191What are Spring Boot's management endpoints and how do you secure them?

Medium
ProductionSpring Boot

#192What is Spring Boot's support for R2DBC (reactive database access)?

Hard
Data AccessSpring Boot

#193How do you implement idempotency in Spring Boot APIs?

Hard
AdvancedSpring Boot

#194What is Spring Boot's support for virtual threads (Java 21)?

Hard
AdvancedSpring Boot

#195What is Spring Boot's Docker image building support?

Medium
ProductionSpring Boot

#196What is GraalVM native image and Spring Boot AOT support?

Hard
ProductionSpring Boot

#197What is the difference between @SpringBootTest(webEnvironment) options?

Medium
TestingSpring Boot

#198What is Spring Boot's support for SSE (Server-Sent Events)?

Medium
AdvancedSpring Boot

#199What is Resilience4j and how does it integrate with Spring Boot?

Hard
AdvancedSpring Boot

#200What are best practices for Spring Boot application performance tuning?

Hard
ProductionSpring Boot

#201What is the difference between horizontal and vertical scaling?

Easy
FundamentalsSystem Design

#202Explain the CAP theorem.

Medium
FundamentalsSystem Design

#203What is consistent hashing and why is it used?

Hard
Distributed SystemsSystem Design

#204What is database sharding and how does it work?

Hard
Database DesignSystem Design

#205Explain cache invalidation strategies.

Medium
CachingSystem Design

#206How would you design a URL shortener (like bit.ly)?

Medium
System Design ProblemsSystem Design

#207What is the Saga pattern in microservices?

Hard
Microservices PatternsSystem Design

#208What is CQRS and when should you use it?

Hard
Microservices PatternsSystem Design

#209What are rate limiting algorithms?

Hard
Distributed SystemsSystem Design

#210What is the Circuit Breaker pattern?

Medium
Microservices PatternsSystem Design

#211How do you design for high availability?

Hard
ReliabilitySystem Design

#212What is eventual consistency?

Medium
Distributed SystemsSystem Design

#213What is a message queue and when should you use one?

Medium
FundamentalsSystem Design

#214What is the difference between SQL and NoSQL databases?

Medium
Database DesignSystem Design

#215What is a CDN and how does it improve performance?

Easy
PerformanceSystem Design

#216How do you handle distributed transactions without 2PC?

Hard
Distributed SystemsSystem Design

#217How would you design a notification system (push, email, SMS)?

Medium
System Design ProblemsSystem Design

#218What is the difference between REST and gRPC?

Medium
FundamentalsSystem Design

#219What is the Outbox Pattern?

Hard
Microservices PatternsSystem Design

#220How do you design a distributed cache layer?

Hard
CachingSystem Design

#221What is the difference between synchronous and asynchronous communication in microservices?

Medium
Microservices PatternsSystem Design

#222How do you design a notification system that sends 100M notifications per day?

Hard
Real-World DesignSystem Design

#223What are the different types of database indexes and when do you use each?

Medium
Database DesignSystem Design

#224How would you design a URL shortener like bit.ly?

Hard
Real-World DesignSystem Design

#225What is eventual consistency and how do you handle it in practice?

Hard
Distributed SystemsSystem Design

#226How do you design a search system at scale?

Hard
Real-World DesignSystem Design

#227What is the difference between optimistic and pessimistic locking?

Medium
Database DesignSystem Design

#228How would you design a real-time leaderboard?

Medium
Real-World DesignSystem Design

#229What is a write-ahead log (WAL) and how is it used?

Hard
Database DesignSystem Design

#230How do you handle distributed transactions across microservices?

Hard
Distributed SystemsSystem Design

#231How do you design a chat application like WhatsApp?

Hard
Real-World DesignSystem Design

#232What is a service mesh and when should you use one?

Hard
InfrastructureSystem Design

#233How would you design a video streaming platform like YouTube?

Hard
Real-World DesignSystem Design

#234What is the difference between a load balancer and an API gateway?

Medium
InfrastructureSystem Design

#235How do you prevent and handle cascading failures in distributed systems?

Hard
ReliabilitySystem Design

#236What is the difference between a message queue and a message broker?

Medium
Distributed SystemsSystem Design

#237How do you design a rate limiter for an API?

Hard
API DesignSystem Design

#238What is the difference between replication and partitioning in databases?

Medium
Database DesignSystem Design

#239How would you design Twitter's news feed?

Hard
Real-World DesignSystem Design

#240What is observability and what are its three pillars?

Medium
ObservabilitySystem Design

#241What is the difference between SQL and NoSQL databases?

Easy
Database DesignSystem Design

#242How do you implement idempotency in APIs?

Medium
API DesignSystem Design

#243How would you design a distributed job scheduler?

Hard
Real-World DesignSystem Design

#244What is the Saga pattern vs 2PC for distributed transactions?

Hard
Distributed SystemsSystem Design

#245How do you design a file storage system like Dropbox?

Hard
Real-World DesignSystem Design

#246What are the trade-offs of microservices vs monolithic architecture?

Medium
FundamentalsSystem Design

#247How does DNS work and how is it used in load balancing?

Medium
InfrastructureSystem Design

#248What is the strangler fig pattern?

Medium
FundamentalsSystem Design

#249How do you design an e-commerce inventory system that handles flash sales?

Hard
Real-World DesignSystem Design

#250What is the difference between push and pull architectures for data?

Medium
Distributed SystemsSystem Design

#251What is a CDN and how does it work?

Easy
InfrastructureSystem Design

#252How do you design a fraud detection system?

Hard
Real-World DesignSystem Design

#253What is event sourcing and how does it differ from CRUD?

Hard
Distributed SystemsSystem Design

#254How would you design a geospatial service like Uber's nearby driver system?

Hard
Real-World DesignSystem Design

#255What is API versioning and what are the different strategies?

Medium
API DesignSystem Design

#256What is a Bloom filter and where is it used in system design?

Hard
Distributed SystemsSystem Design

#257How do you implement zero-downtime deployments?

Medium
InfrastructureSystem Design

#258What is the two-generals problem and what does it tell us about distributed systems?

Hard
Distributed SystemsSystem Design

#259How do you design a payment processing system?

Hard
Real-World DesignSystem Design

#260What are the key principles of the SOLID design principles?

Easy
FundamentalsSystem Design

#261How would you design an autocomplete system?

Hard
Real-World DesignSystem Design

#262What is backpressure and how do you handle it?

Medium
Distributed SystemsSystem Design

#263What is a time-series database and when should you use one?

Medium
Database DesignSystem Design

#264What is a circuit breaker and how do you implement it?

Medium
ReliabilitySystem Design

#265How do you handle database migrations safely in production?

Medium
Database DesignSystem Design

#266What is the CQRS pattern?

Hard
Distributed SystemsSystem Design

#267How do you secure an API at the architecture level?

Medium
SecuritySystem Design

#268What is the difference between synchronous replication and asynchronous replication?

Medium
Database DesignSystem Design

#269How do you design a system for billions of events per day (analytics pipeline)?

Hard
Real-World DesignSystem Design

#270What is chaos engineering and how do you implement it?

Medium
ReliabilitySystem Design

#271What is the database connection pool and how do you tune it?

Medium
Database DesignSystem Design

#272How do you design an access control system?

Medium
SecuritySystem Design

#273How would you design an online code execution system like LeetCode?

Hard
Real-World DesignSystem Design

#274What are SLOs, SLIs, and SLAs?

Easy
ObservabilitySystem Design

#275How does the request flow work in a typical microservices architecture?

Medium
Microservices PatternsSystem Design

#276What is a hot partition problem and how do you solve it?

Hard
Distributed SystemsSystem Design

#277How do you design a multi-tenant SaaS architecture?

Hard
Real-World DesignSystem Design

#278What is tail latency and why does it matter?

Hard
PerformanceSystem Design

#279What is the difference between availability and reliability?

Easy
ReliabilitySystem Design

#280How do you design a global, low-latency key-value store?

Hard
Distributed SystemsSystem Design

#281What is the N+1 query problem and how do you fix it?

Medium
Database DesignSystem Design

#282How would you design a booking system like Airbnb?

Hard
Real-World DesignSystem Design

#283What is the difference between a forward proxy and a reverse proxy?

Easy
InfrastructureSystem Design

#284What is the difference between stateful and stateless services?

Easy
FundamentalsSystem Design

#285How do you design a recommendation system?

Hard
Real-World DesignSystem Design

#286What is the read-your-own-writes consistency guarantee?

Medium
Distributed SystemsSystem Design

#287How do you design a search-as-you-type / typeahead feature?

Medium
Real-World DesignSystem Design

#288What is the difference between gRPC unary, server streaming, client streaming, and bidirectional streaming?

Medium
API DesignSystem Design

#289How do you handle large file uploads efficiently?

Medium
API DesignSystem Design

#290What are the key considerations when designing for high write throughput?

Hard
Database DesignSystem Design

#291What is the difference between monolithic and microservices deployment strategies?

Medium
InfrastructureSystem Design

#292How do you design for disaster recovery?

Hard
ReliabilitySystem Design

#293What is the thundering herd problem?

Medium
ReliabilitySystem Design

#294What is a vector clock and how does it work?

Hard
Distributed SystemsSystem Design

#295What is the difference between a monorepo and polyrepo?

Medium
FundamentalsSystem Design

#296How do you ensure data consistency across microservices?

Hard
Microservices PatternsSystem Design

#297What is the difference between a batch job and a stream processing job?

Medium
Distributed SystemsSystem Design

#298How do you design an API for mobile clients vs web clients?

Medium
API DesignSystem Design

#299What is the role of a message broker in event-driven architecture?

Medium
Distributed SystemsSystem Design

#300How do you approach capacity planning for a new system?

Medium
FundamentalsSystem Design

#301What are the different types of SQL JOINs?

Easy
QueryingMySQL

#302How does indexing work in MySQL (InnoDB)?

Medium
IndexingMySQL

#303What is a covering index?

Medium
IndexingMySQL

#304What are MySQL transaction isolation levels?

Hard
TransactionsMySQL

#305What is MVCC (Multi-Version Concurrency Control) in InnoDB?

Hard
TransactionsMySQL

#306How do you use EXPLAIN to analyze a query?

Medium
PerformanceMySQL

#307What are window functions in SQL?

Hard
Advanced SQLMySQL

#308What are CTEs (Common Table Expressions) and when should you use them?

Medium
Advanced SQLMySQL

#309What is the N+1 query problem and how do you fix it?

Medium
PerformanceMySQL

#310What is a deadlock in MySQL and how does it occur?

Medium
TransactionsMySQL

#311What is the difference between DELETE, TRUNCATE, and DROP?

Easy
QueryingMySQL

#312How do you optimize a slow MySQL query?

Hard
PerformanceMySQL

#313What is database normalization?

Medium
Schema DesignMySQL

#314What is MySQL replication and how does it work?

Hard
OperationsMySQL

#315What is partitioning in MySQL?

Hard
Schema DesignMySQL

#316What is GROUP BY vs HAVING in SQL?

Easy
QueryingMySQL

#317What is a stored procedure and when should you use it?

Medium
Advanced SQLMySQL

#318How does the InnoDB storage engine handle locking?

Hard
TransactionsMySQL

#319What is the difference between UNION and UNION ALL?

Easy
QueryingMySQL

#320How do you design a schema for a multi-tenant SaaS application?

Hard
Schema DesignMySQL

#321What is the difference between a clustered and a non-clustered index?

Medium
IndexingMySQL

#322How does MySQL handle AUTO_INCREMENT?

Easy
Schema DesignMySQL

#323What are covering indexes and how do they improve performance?

Medium
IndexingMySQL

#324What is the EXPLAIN output and how do you read it?

Medium
PerformanceMySQL

#325What are database triggers and when should you avoid them?

Medium
Schema DesignMySQL

#326What is a foreign key constraint and what are its performance implications?

Medium
Schema DesignMySQL

#327What is the difference between CHAR and VARCHAR?

Easy
Schema DesignMySQL

#328How do you implement full-text search in MySQL?

Medium
QueryingMySQL

#329What is the difference between MyISAM and InnoDB?

Easy
FundamentalsMySQL

#330How does MySQL replication work and what are its modes?

Hard
ReplicationMySQL

#331What is a deadlock in MySQL and how does InnoDB handle it?

Hard
TransactionsMySQL

#332What are MySQL stored procedures and when should you use them?

Medium
FundamentalsMySQL

#333How do you perform a slow query analysis in MySQL?

Medium
PerformanceMySQL

#334What is InnoDB buffer pool and how do you size it?

Hard
PerformanceMySQL

#335What is the difference between HAVING and WHERE?

Easy
QueryingMySQL

#336What is MySQL's query cache and why was it removed?

Medium
PerformanceMySQL

#337How do you back up a MySQL database without downtime?

Medium
OperationsMySQL

#338What is the difference between optimistic and pessimistic locking in MySQL?

Medium
TransactionsMySQL

#339What are MySQL partitioning types and when do you use them?

Hard
PerformanceMySQL

#340How do you handle large data migrations in production?

Hard
OperationsMySQL

#341What is the difference between IN, EXISTS, and JOIN for subqueries?

Medium
QueryingMySQL

#342What is the InnoDB redo log and undo log?

Hard
InternalsMySQL

#343How do you implement pagination in MySQL efficiently?

Medium
PerformanceMySQL

#344What are the different types of JOINs in MySQL?

Easy
QueryingMySQL

#345What is group replication and InnoDB Cluster?

Hard
ReplicationMySQL

#346What is the difference between a view and a materialized view?

Medium
Schema DesignMySQL

#347How does MySQL's optimizer choose an execution plan?

Hard
PerformanceMySQL

#348What are common MySQL performance anti-patterns?

Medium
PerformanceMySQL

#349What is a generated column in MySQL?

Medium
Schema DesignMySQL

#350What are the best practices for MySQL schema design?

Medium
Schema DesignMySQL

#351How do you use MySQL's JSON column type?

Medium
Schema DesignMySQL

#352What is the difference between transaction isolation levels in MySQL?

Hard
TransactionsMySQL

#353How do you handle hierarchical data in MySQL?

Hard
Schema DesignMySQL

#354What is ProxySQL and how is it used?

Medium
OperationsMySQL

#355What is MVCC and how does InnoDB implement it?

Hard
InternalsMySQL

#356How do you detect and fix index fragmentation in MySQL?

Medium
PerformanceMySQL

#357What are the MySQL 8.0 improvements over MySQL 5.7?

Medium
FundamentalsMySQL

#358How do you design a schema for audit logging?

Medium
Schema DesignMySQL

#359What is binlog and how is it used for CDC?

Hard
ReplicationMySQL

#360How do you use MySQL's performance_schema?

Hard
PerformanceMySQL

#361What is the difference between COUNT(*), COUNT(1), and COUNT(col)?

Easy
QueryingMySQL

#362What is a composite index and how should you order columns?

Hard
IndexingMySQL

#363How do you implement soft delete in MySQL?

Medium
Schema DesignMySQL

#364What is the difference between CHAR, VARCHAR, TEXT, and BLOB?

Easy
Schema DesignMySQL

#365How does MySQL handle concurrent writes to the same row?

Hard
TransactionsMySQL

#366What is the difference between schema-on-write and schema-on-read?

Medium
FundamentalsMySQL

#367How do you handle time zones in MySQL?

Medium
OperationsMySQL

#368What is the difference between a unique constraint and a unique index?

Easy
IndexingMySQL

#369How do you monitor MySQL in production?

Medium
OperationsMySQL

#370What are window functions and how do you use them?

Medium
QueryingMySQL

#371How do you implement row-level security in MySQL?

Hard
SecurityMySQL

#372What is the difference between a primary key and a unique key?

Easy
IndexingMySQL

#373How do you use MySQL's event scheduler?

Medium
OperationsMySQL

#374What is the EXPLAIN ANALYZE command?

Medium
PerformanceMySQL

#375How do you handle database connection failures in application code?

Medium
OperationsMySQL

#376What is the MySQL query execution order?

Medium
QueryingMySQL

#377How do you scale MySQL reads?

Medium
ReplicationMySQL

#378What is the difference between row-based and statement-based replication?

Medium
ReplicationMySQL

#379How do you use CTEs (Common Table Expressions) effectively?

Medium
QueryingMySQL

#380What is the difference between TRUNCATE, DELETE, and DROP?

Easy
OperationsMySQL

#381How do you implement optimistic locking with versioning in MySQL?

Medium
TransactionsMySQL

#382What are the different ways to copy a table in MySQL?

Easy
OperationsMySQL

#383What is the purpose of the information_schema?

Medium
OperationsMySQL

#384What is innodb_flush_log_at_trx_commit and how does it affect durability?

Hard
InternalsMySQL

#385How do you implement full-table search across millions of rows efficiently?

Medium
PerformanceMySQL

#386What is the max_connections parameter and how do you tune it?

Medium
OperationsMySQL

#387What is a spatial index in MySQL and how is it used?

Hard
IndexingMySQL

#388What is the difference between ROLLUP and CUBE in SQL?

Medium
QueryingMySQL

#389How do you handle NULL values in MySQL queries?

Medium
QueryingMySQL

#390What is the difference between a read and a write transaction?

Medium
TransactionsMySQL

#391How do you implement a queue in MySQL?

Hard
Schema DesignMySQL

#392What is the mysql.user table and how does MySQL authentication work?

Medium
SecurityMySQL

#393What is index merge optimization?

Hard
IndexingMySQL

#394How do you detect and resolve replication lag?

Hard
ReplicationMySQL

#395What is the difference between MyISAM and InnoDB row format?

Hard
InternalsMySQL

#396How do you implement rate limiting at the database level?

Hard
SecurityMySQL

#397What is the difference between REPEATABLE READ and READ COMMITTED in practice?

Hard
TransactionsMySQL

#398What are MySQL's data types for storing money?

Medium
Schema DesignMySQL

#399How do you handle schema evolution in a microservices environment?

Hard
OperationsMySQL

#400What is the difference between DATETIME and TIMESTAMP in MySQL?

Easy
Schema DesignMySQL