Home/Companies/Razorpay
RP

Razorpay Interview Questions

India's leading payment infrastructure company. Interviews emphasise Java Spring Boot, payment system design (idempotency, ledger, fraud), SQL transactions, Kafka, and API security.

424questions
244 Medium180 Hard

#1Explain the SOLID principles.

Medium
OOPJava

#2How does HashMap work internally?

Medium
CollectionsJava

#3What is the difference between HashMap and ConcurrentHashMap?

Medium
CollectionsJava

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

Medium
JVMJava

#5What is the volatile keyword in Java?

Medium
ConcurrencyJava

#6What is the difference between synchronized and ReentrantLock?

Hard
ConcurrencyJava

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

Hard
ConcurrencyJava

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

Medium
Java 8+Java

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

Hard
JVMJava

#10What is the Java ClassLoader hierarchy?

Hard
JVMJava

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

Medium
Java 8+Java

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

Medium
ConcurrencyJava

#13What is the difference between composition and inheritance?

Medium
OOPJava

#14What is a marker interface? Give examples.

Medium
OOPJava

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

Medium
OOPJava

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

Hard
OOPJava

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

Medium
CollectionsJava

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

Medium
CollectionsJava

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

Medium
CollectionsJava

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

Medium
CollectionsJava

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

Hard
ConcurrencyJava

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

Medium
ConcurrencyJava

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

Medium
ConcurrencyJava

#24What is a CountDownLatch vs CyclicBarrier?

Medium
ConcurrencyJava

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

Hard
ConcurrencyJava

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

Hard
ConcurrencyJava

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

Hard
ConcurrencyJava

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

Hard
JVMJava

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

Hard
JVMJava

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

Hard
JVMJava

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

Medium
JVMJava

#32What is type erasure in Java generics?

Hard
GenericsJava

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

Hard
GenericsJava

#34What are sealed classes (Java 17)?

Medium
Java 8+Java

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

Medium
Java 8+Java

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

Medium
Java 8+Java

#37What is the difference between Comparable and Comparator?

Medium
CollectionsJava

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

Medium
Java 8+Java

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

Medium
Exception HandlingJava

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

Medium
Exception HandlingJava

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

Medium
Core JavaJava

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

Hard
Core JavaJava

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

Medium
Core JavaJava

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

Medium
Core JavaJava

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

Medium
Core JavaJava

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

Medium
Core JavaJava

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

Medium
Core JavaJava

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

Hard
Java 8+Java

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

Medium
OOPJava

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

Medium
Java 8+Java

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

Medium
ConcurrencyJava

#52How do you handle NullPointerException in Java?

Medium
Exception HandlingJava

#53What is the difference between Deque and Queue?

Medium
CollectionsJava

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

Hard
CollectionsJava

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

Medium
Exception HandlingJava

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

Medium
OOPJava

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

Medium
Core JavaJava

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

Medium
ConcurrencyJava

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

Medium
CollectionsJava

#60What is the purpose of the transient keyword?

Medium
Core JavaJava

#61What is method hiding in Java?

Hard
OOPJava

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

Medium
Java 8+Java

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

Medium
CollectionsJava

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

Medium
OOPJava

#65What is the covariant return type in Java?

Medium
OOPJava

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

Medium
Java 8+Java

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

Medium
OOPJava

#68What is the Strategy pattern in Java?

Medium
OOPJava

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

Hard
Core JavaJava

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

Medium
Java 8+Java

#71What is auto-configuration in Spring Boot?

Medium
Core ConceptsSpring Boot

#72Explain @Transactional and its propagation levels.

Hard
Data AccessSpring Boot

#73How does Spring Boot handle exceptions globally?

Medium
REST APISpring Boot

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

Medium
Core ConceptsSpring Boot

#75Explain Spring Bean scopes.

Medium
Core ConceptsSpring Boot

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

Hard
AdvancedSpring Boot

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

Hard
AdvancedSpring Boot

#78How does Spring Security authentication work?

Hard
SecuritySpring Boot

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

Medium
AdvancedSpring Boot

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

Medium
Data AccessSpring Boot

#81How does Spring Boot externalized configuration work?

Medium
ConfigurationSpring Boot

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

Medium
AdvancedSpring Boot

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

Medium
TestingSpring Boot

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

Medium
Core ConceptsSpring Boot

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

Hard
Core ConceptsSpring Boot

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

Medium
Core ConceptsSpring Boot

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

Medium
Core ConceptsSpring Boot

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

Hard
Core ConceptsSpring Boot

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

Medium
ConfigurationSpring Boot

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

Medium
Core ConceptsSpring Boot

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

Medium
AdvancedSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
REST APISpring Boot

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

Medium
REST APISpring Boot

#95What is content negotiation in Spring MVC?

Medium
REST APISpring Boot

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

Medium
REST APISpring Boot

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

Hard
REST APISpring Boot

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

Medium
REST APISpring Boot

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

Medium
Data AccessSpring Boot

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

Hard
Data AccessSpring Boot

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

Medium
Data AccessSpring Boot

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

Hard
Data AccessSpring Boot

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

Hard
Data AccessSpring Boot

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

Hard
Data AccessSpring Boot

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

Medium
SecuritySpring Boot

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

Hard
SecuritySpring Boot

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

Medium
SecuritySpring Boot

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

Medium
SecuritySpring Boot

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

Hard
SecuritySpring Boot

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

Medium
TestingSpring Boot

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

Medium
TestingSpring Boot

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

Medium
TestingSpring Boot

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

Medium
TestingSpring Boot

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

Medium
ProductionSpring Boot

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

Medium
ProductionSpring Boot

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

Hard
ProductionSpring Boot

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

Medium
ProductionSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
REST APISpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
AdvancedSpring Boot

#122What happens during Spring Boot startup?

Hard
Core ConceptsSpring Boot

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

Hard
Core ConceptsSpring Boot

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

Medium
AdvancedSpring Boot

#125What is Spring Integration vs Spring Batch?

Hard
AdvancedSpring Boot

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

Medium
Data AccessSpring Boot

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

Hard
Data AccessSpring Boot

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

Medium
REST APISpring Boot

#129What is Spring Cloud and its key components?

Hard
AdvancedSpring Boot

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

Medium
Data AccessSpring Boot

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

Medium
Data AccessSpring Boot

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

Medium
AdvancedSpring Boot

#133What is Spring's @Lookup annotation?

Hard
Core ConceptsSpring Boot

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

Hard
SecuritySpring Boot

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

Medium
ConfigurationSpring Boot

#136What is the purpose of @EnableJpaAuditing?

Medium
Data AccessSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
Core ConceptsSpring Boot

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

Medium
AdvancedSpring Boot

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

Medium
Data AccessSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
REST APISpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
Data AccessSpring Boot

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

Medium
Data AccessSpring Boot

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

Hard
AdvancedSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
ProductionSpring Boot

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

Hard
Data AccessSpring Boot

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

Hard
AdvancedSpring Boot

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

Hard
AdvancedSpring Boot

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

Medium
ProductionSpring Boot

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

Hard
ProductionSpring Boot

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

Medium
TestingSpring Boot

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

Medium
AdvancedSpring Boot

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

Hard
AdvancedSpring Boot

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

Hard
ProductionSpring Boot

#158Explain the CAP theorem.

Medium
FundamentalsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Database DesignSystem Design

#161Explain cache invalidation strategies.

Medium
CachingSystem Design

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

Medium
System Design ProblemsSystem Design

#163What is the Saga pattern in microservices?

Hard
Microservices PatternsSystem Design

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

Hard
Microservices PatternsSystem Design

#165What are rate limiting algorithms?

Hard
Distributed SystemsSystem Design

#166What is the Circuit Breaker pattern?

Medium
Microservices PatternsSystem Design

#167How do you design for high availability?

Hard
ReliabilitySystem Design

#168What is eventual consistency?

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
System Design ProblemsSystem Design

#173What is the difference between REST and gRPC?

Medium
FundamentalsSystem Design

#174What is the Outbox Pattern?

Hard
Microservices PatternsSystem Design

#175How do you design a distributed cache layer?

Hard
CachingSystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Medium
Real-World DesignSystem Design

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

Hard
Database DesignSystem Design

#185How do you handle distributed transactions across microservices?

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
InfrastructureSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
InfrastructureSystem Design

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

Hard
ReliabilitySystem Design

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

Medium
Distributed SystemsSystem Design

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

Hard
API DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ObservabilitySystem Design

#196How do you implement idempotency in APIs?

Medium
API DesignSystem Design

#197How would you design a distributed job scheduler?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
InfrastructureSystem Design

#202What is the strangler fig pattern?

Medium
FundamentalsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

#205How do you design a fraud detection system?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

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

Hard
Distributed SystemsSystem Design

#210How do you implement zero-downtime deployments?

Medium
InfrastructureSystem Design

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

Hard
Distributed SystemsSystem Design

#212How do you design a payment processing system?

Hard
Real-World DesignSystem Design

#213How would you design an autocomplete system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#218What is the CQRS pattern?

Hard
Distributed SystemsSystem Design

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

Medium
SecuritySystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#224How do you design an access control system?

Medium
SecuritySystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
PerformanceSystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

#233How do you design a recommendation system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

#237How do you handle large file uploads efficiently?

Medium
API DesignSystem Design

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

Hard
Database DesignSystem Design

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

Medium
InfrastructureSystem Design

#240How do you design for disaster recovery?

Hard
ReliabilitySystem Design

#241What is the thundering herd problem?

Medium
ReliabilitySystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

#244How do you ensure data consistency across microservices?

Hard
Microservices PatternsSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
API DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

#249What is a consumer group and how does it enable parallelism?

Medium
ConsumersKafka

#250Explain Kafka delivery semantics: at-most-once, at-least-once, and exactly-once.

Hard
ReliabilityKafka

#251How does Kafka ensure message ordering?

Medium
FundamentalsKafka

#252What are producer acknowledgment settings (acks)?

Medium
ProducersKafka

#253What is log compaction in Kafka?

Hard
InternalsKafka

#254What is Kafka Streams and when would you use it?

Hard
Stream ProcessingKafka

#255What is consumer lag and how do you monitor it?

Medium
OperationsKafka

#256How does Kafka differ from RabbitMQ?

Medium
ComparisonsKafka

#257What is the role of ZooKeeper / KRaft in Kafka?

Medium
InternalsKafka

#258How do you handle large messages in Kafka?

Hard
ProducersKafka

#259What is Kafka Connect?

Medium
EcosystemKafka

#260How does Kafka replication work?

Hard
ReliabilityKafka

#261What is Schema Registry and why is it important?

Hard
EcosystemKafka

#262What is the difference between Kafka and RabbitMQ?

Medium
FundamentalsKafka

#263How do you handle consumer group rebalancing?

Hard
ConsumerKafka

#264What is Kafka Streams?

Hard
EcosystemKafka

#265What are Kafka transactions and how do they work?

Hard
ReliabilityKafka

#266What is the difference between at-most-once, at-least-once, and exactly-once delivery?

Hard
ReliabilityKafka

#267How do you choose the right number of partitions for a Kafka topic?

Hard
ProducerKafka

#268What is KRaft mode in Kafka?

Medium
ArchitectureKafka

#269What is log compaction in Kafka?

Hard
FundamentalsKafka

#270How does Kafka handle backpressure?

Medium
ConsumerKafka

#271What is the role of the Kafka controller?

Hard
ArchitectureKafka

#272What is the difference between Kafka producer acks=0, acks=1, and acks=all?

Medium
ProducerKafka

#273How do you monitor Kafka in production?

Medium
OperationsKafka

#274What is a Kafka consumer poll loop?

Medium
ConsumerKafka

#275What are Kafka headers and how are they used?

Medium
ProducerKafka

#276What is the consumer group coordinator?

Hard
ConsumerKafka

#277How do you implement idempotent consumers with Kafka?

Hard
ConsumerKafka

#278What is Kafka's storage architecture?

Hard
ArchitectureKafka

#279What is consumer lag and how do you manage it?

Medium
ConsumerKafka

#280What is the Kafka retention policy and how does it work?

Medium
OperationsKafka

#281How do you handle poison pill messages in Kafka?

Medium
ConsumerKafka

#282What is Kafka MirrorMaker 2 and when do you use it?

Hard
OperationsKafka

#283How does Kafka achieve high throughput?

Hard
ArchitectureKafka

#284What is Kafka's ISR (In-Sync Replicas) and how does it affect durability?

Hard
ReliabilityKafka

#285What are Kafka Streams stateful operations?

Hard
EcosystemKafka

#286What is the difference between Kafka Streams and Apache Flink?

Hard
EcosystemKafka

#287How does Kafka handle message ordering?

Medium
FundamentalsKafka

#288What is Kafka's __consumer_offsets topic?

Hard
ArchitectureKafka

#289How do you implement a CDC pipeline with Kafka and Debezium?

Hard
EcosystemKafka

#290What is the difference between push and pull in Kafka?

Medium
ConsumerKafka

#291How do you perform a Kafka cluster rolling restart?

Hard
OperationsKafka

#292What is Kafka consumer group offset management?

Medium
ConsumerKafka

#293What is Kafka's batch processing capability?

Medium
ProducerKafka

#294What is the relationship between Kafka partitions and consumers?

Medium
ConsumerKafka

#295What is the Kafka producer buffer and how does it affect performance?

Medium
ProducerKafka

#296How does Kafka support exactly-once semantics end to end?

Hard
ReliabilityKafka

#297What is Kafka's message format / record format?

Hard
ArchitectureKafka

#298How does Kafka handle broker failure and partition recovery?

Hard
ReliabilityKafka

#299What is Kafka's wire protocol?

Hard
ArchitectureKafka

#300What are Kafka consumer interceptors?

Medium
EcosystemKafka

#301How do you secure a Kafka cluster?

Hard
OperationsKafka

#302What is Kafka's log segment management?

Medium
ArchitectureKafka

#303How do you increase the throughput of a Kafka producer?

Medium
ProducerKafka

#304What is the Kafka AdminClient API?

Medium
EcosystemKafka

#305What is tiered storage in Kafka?

Hard
ArchitectureKafka

#306How does Kafka handle time and event-time processing?

Hard
EcosystemKafka

#307What is Kafka's producer idempotence?

Hard
ProducerKafka

#308What are the different Kafka message delivery patterns?

Medium
FundamentalsKafka

#309How do you tune Kafka for low latency?

Hard
OperationsKafka

#310What is Kafka's producer partitioner?

Medium
ProducerKafka

#311What is the Kafka Broker Rack Awareness?

Medium
ArchitectureKafka

#312How do you handle schema migrations in a Kafka event stream?

Hard
EcosystemKafka

#313What are Kafka quotas and how do they work?

Medium
OperationsKafka

#314What is a Kafka topic compaction tombstone?

Medium
FundamentalsKafka

#315How do you implement a Kafka consumer with Spring Boot?

Medium
EcosystemKafka

#316What is the Kafka offset commit semantics?

Hard
ConsumerKafka

#317How do you benchmark a Kafka cluster?

Medium
OperationsKafka

#318What is the difference between Kafka and Apache Pulsar?

Hard
FundamentalsKafka

#319How do you implement a Kafka producer with Spring Boot?

Medium
EcosystemKafka

#320What is a Kafka connector and how does it work?

Medium
EcosystemKafka

#321What is the Kafka consumer fetch protocol?

Hard
ConsumerKafka

#322What is Kafka consumer group rebalance protocol and incremental cooperative rebalancing?

Hard
ConsumerKafka

#323What is the Kafka log cleaner and how does compaction work internally?

Hard
ArchitectureKafka

#324How do you debug Kafka consumer issues?

Medium
OperationsKafka

#325What is Kafka's min.insync.replicas and how does it interact with acks?

Hard
ReliabilityKafka

#326What is Apache Kafka's role in the data lakehouse architecture?

Hard
EcosystemKafka

#327What is the Kafka log flush policy and how does it affect durability?

Hard
ArchitectureKafka

#328How do you implement a Saga with Kafka?

Hard
EcosystemKafka

#329What is the difference between Kafka topic partitions and consumer group partitions?

Medium
ConsumerKafka

#330What is Confluent's ksqlDB?

Medium
EcosystemKafka

#331What is Kafka's message size limit and how do you handle large messages?

Medium
OperationsKafka

#332What are Kafka producer callbacks and how are they used?

Medium
ProducerKafka

#333How do you implement a Kafka multi-datacenter setup?

Hard
OperationsKafka

#334What is Kafka's leader epoch?

Hard
ArchitectureKafka

#335What is the high watermark in Kafka?

Hard
ArchitectureKafka

#336What is a Kafka consumer group's session timeout vs heartbeat interval?

Medium
ConsumerKafka

#337What is a Kafka changelog topic in Kafka Streams?

Hard
EcosystemKafka

#338What happens when a Kafka broker runs out of disk space?

Hard
OperationsKafka

#339What is Kafka's dynamic configuration and how do you update it?

Medium
OperationsKafka

#340What is the Kafka consumer seek API?

Medium
ConsumerKafka

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

Medium
IndexingMySQL

#342What is a covering index?

Medium
IndexingMySQL

#343What are MySQL transaction isolation levels?

Hard
TransactionsMySQL

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

Hard
TransactionsMySQL

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

Medium
PerformanceMySQL

#346What are window functions in SQL?

Hard
Advanced SQLMySQL

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

Medium
Advanced SQLMySQL

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

Medium
PerformanceMySQL

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

Medium
TransactionsMySQL

#350How do you optimize a slow MySQL query?

Hard
PerformanceMySQL

#351What is database normalization?

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL

#353What is partitioning in MySQL?

Hard
Schema DesignMySQL

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

Medium
Advanced SQLMySQL

#355How does the InnoDB storage engine handle locking?

Hard
TransactionsMySQL

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

Hard
Schema DesignMySQL

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

Medium
IndexingMySQL

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

Medium
IndexingMySQL

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

Medium
PerformanceMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Medium
QueryingMySQL

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

Hard
ReplicationMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

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

Medium
PerformanceMySQL

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

Hard
PerformanceMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Medium
TransactionsMySQL

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

Hard
PerformanceMySQL

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

Hard
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
InternalsMySQL

#375How do you implement pagination in MySQL efficiently?

Medium
PerformanceMySQL

#376What is group replication and InnoDB Cluster?

Hard
ReplicationMySQL

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

Medium
Schema DesignMySQL

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

Hard
PerformanceMySQL

#379What are common MySQL performance anti-patterns?

Medium
PerformanceMySQL

#380What is a generated column in MySQL?

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Hard
TransactionsMySQL

#384How do you handle hierarchical data in MySQL?

Hard
Schema DesignMySQL

#385What is ProxySQL and how is it used?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
FundamentalsMySQL

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

Medium
Schema DesignMySQL

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

Hard
ReplicationMySQL

#391How do you use MySQL's performance_schema?

Hard
PerformanceMySQL

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

Hard
IndexingMySQL

#393How do you implement soft delete in MySQL?

Medium
Schema DesignMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

#396How do you handle time zones in MySQL?

Medium
OperationsMySQL

#397How do you monitor MySQL in production?

Medium
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
SecurityMySQL

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

Medium
OperationsMySQL

#401What is the EXPLAIN ANALYZE command?

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

#403What is the MySQL query execution order?

Medium
QueryingMySQL

#404How do you scale MySQL reads?

Medium
ReplicationMySQL

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

Medium
ReplicationMySQL

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

Medium
QueryingMySQL

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

Medium
TransactionsMySQL

#408What is the purpose of the information_schema?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Hard
IndexingMySQL

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

Medium
QueryingMySQL

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

Medium
QueryingMySQL

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

Medium
TransactionsMySQL

#416How do you implement a queue in MySQL?

Hard
Schema DesignMySQL

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

Medium
SecurityMySQL

#418What is index merge optimization?

Hard
IndexingMySQL

#419How do you detect and resolve replication lag?

Hard
ReplicationMySQL

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

Hard
InternalsMySQL

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

Hard
SecurityMySQL

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

Hard
TransactionsMySQL

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

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL