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
68 Easy200 Medium132 Hard

#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