P

Paytm Interview Questions

Fintech backend interviews stress transaction safety, SQL performance, and Java Spring Boot. Security and data consistency are key themes.

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 are the different types of SQL JOINs?

Easy
QueryingMySQL

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

Medium
IndexingMySQL

#203What is a covering index?

Medium
IndexingMySQL

#204What are MySQL transaction isolation levels?

Hard
TransactionsMySQL

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

Hard
TransactionsMySQL

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

Medium
PerformanceMySQL

#207What are window functions in SQL?

Hard
Advanced SQLMySQL

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

Medium
Advanced SQLMySQL

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

Medium
PerformanceMySQL

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

Medium
TransactionsMySQL

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

Easy
QueryingMySQL

#212How do you optimize a slow MySQL query?

Hard
PerformanceMySQL

#213What is database normalization?

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL

#215What is partitioning in MySQL?

Hard
Schema DesignMySQL

#216What is GROUP BY vs HAVING in SQL?

Easy
QueryingMySQL

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

Medium
Advanced SQLMySQL

#218How does the InnoDB storage engine handle locking?

Hard
TransactionsMySQL

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

Easy
QueryingMySQL

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

Hard
Schema DesignMySQL

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

Medium
IndexingMySQL

#222How does MySQL handle AUTO_INCREMENT?

Easy
Schema DesignMySQL

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

Medium
IndexingMySQL

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

Medium
PerformanceMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

#227What is the difference between CHAR and VARCHAR?

Easy
Schema DesignMySQL

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

Medium
QueryingMySQL

#229What is the difference between MyISAM and InnoDB?

Easy
FundamentalsMySQL

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

Hard
ReplicationMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

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

Medium
PerformanceMySQL

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

Hard
PerformanceMySQL

#235What is the difference between HAVING and WHERE?

Easy
QueryingMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Medium
TransactionsMySQL

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

Hard
PerformanceMySQL

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

Hard
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
InternalsMySQL

#243How do you implement pagination in MySQL efficiently?

Medium
PerformanceMySQL

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

Easy
QueryingMySQL

#245What is group replication and InnoDB Cluster?

Hard
ReplicationMySQL

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

Medium
Schema DesignMySQL

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

Hard
PerformanceMySQL

#248What are common MySQL performance anti-patterns?

Medium
PerformanceMySQL

#249What is a generated column in MySQL?

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Hard
TransactionsMySQL

#253How do you handle hierarchical data in MySQL?

Hard
Schema DesignMySQL

#254What is ProxySQL and how is it used?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
FundamentalsMySQL

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

Medium
Schema DesignMySQL

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

Hard
ReplicationMySQL

#260How do you use MySQL's performance_schema?

Hard
PerformanceMySQL

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

Easy
QueryingMySQL

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

Hard
IndexingMySQL

#263How do you implement soft delete in MySQL?

Medium
Schema DesignMySQL

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

Easy
Schema DesignMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

#267How do you handle time zones in MySQL?

Medium
OperationsMySQL

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

Easy
IndexingMySQL

#269How do you monitor MySQL in production?

Medium
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
SecurityMySQL

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

Easy
IndexingMySQL

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

Medium
OperationsMySQL

#274What is the EXPLAIN ANALYZE command?

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

#276What is the MySQL query execution order?

Medium
QueryingMySQL

#277How do you scale MySQL reads?

Medium
ReplicationMySQL

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

Medium
ReplicationMySQL

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

Medium
QueryingMySQL

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

Easy
OperationsMySQL

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

Medium
TransactionsMySQL

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

Easy
OperationsMySQL

#283What is the purpose of the information_schema?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Hard
IndexingMySQL

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

Medium
QueryingMySQL

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

Medium
QueryingMySQL

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

Medium
TransactionsMySQL

#291How do you implement a queue in MySQL?

Hard
Schema DesignMySQL

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

Medium
SecurityMySQL

#293What is index merge optimization?

Hard
IndexingMySQL

#294How do you detect and resolve replication lag?

Hard
ReplicationMySQL

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

Hard
InternalsMySQL

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

Hard
SecurityMySQL

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

Hard
TransactionsMySQL

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

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL

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

Easy
Schema DesignMySQL

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

Easy
FundamentalsSystem Design

#302Explain the CAP theorem.

Medium
FundamentalsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Database DesignSystem Design

#305Explain cache invalidation strategies.

Medium
CachingSystem Design

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

Medium
System Design ProblemsSystem Design

#307What is the Saga pattern in microservices?

Hard
Microservices PatternsSystem Design

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

Hard
Microservices PatternsSystem Design

#309What are rate limiting algorithms?

Hard
Distributed SystemsSystem Design

#310What is the Circuit Breaker pattern?

Medium
Microservices PatternsSystem Design

#311How do you design for high availability?

Hard
ReliabilitySystem Design

#312What is eventual consistency?

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
Database DesignSystem Design

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

Easy
PerformanceSystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
System Design ProblemsSystem Design

#318What is the difference between REST and gRPC?

Medium
FundamentalsSystem Design

#319What is the Outbox Pattern?

Hard
Microservices PatternsSystem Design

#320How do you design a distributed cache layer?

Hard
CachingSystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Medium
Real-World DesignSystem Design

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

Hard
Database DesignSystem Design

#330How do you handle distributed transactions across microservices?

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
InfrastructureSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
InfrastructureSystem Design

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

Hard
ReliabilitySystem Design

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

Medium
Distributed SystemsSystem Design

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

Hard
API DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ObservabilitySystem Design

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

Easy
Database DesignSystem Design

#342How do you implement idempotency in APIs?

Medium
API DesignSystem Design

#343How would you design a distributed job scheduler?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
InfrastructureSystem Design

#348What is the strangler fig pattern?

Medium
FundamentalsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Easy
InfrastructureSystem Design

#352How do you design a fraud detection system?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

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

Hard
Distributed SystemsSystem Design

#357How do you implement zero-downtime deployments?

Medium
InfrastructureSystem Design

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

Hard
Distributed SystemsSystem Design

#359How do you design a payment processing system?

Hard
Real-World DesignSystem Design

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

Easy
FundamentalsSystem Design

#361How would you design an autocomplete system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#366What is the CQRS pattern?

Hard
Distributed SystemsSystem Design

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

Medium
SecuritySystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#372How do you design an access control system?

Medium
SecuritySystem Design

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

Hard
Real-World DesignSystem Design

#374What are SLOs, SLIs, and SLAs?

Easy
ObservabilitySystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
PerformanceSystem Design

#379What is the difference between availability and reliability?

Easy
ReliabilitySystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Easy
InfrastructureSystem Design

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

Easy
FundamentalsSystem Design

#385How do you design a recommendation system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

#389How do you handle large file uploads efficiently?

Medium
API DesignSystem Design

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

Hard
Database DesignSystem Design

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

Medium
InfrastructureSystem Design

#392How do you design for disaster recovery?

Hard
ReliabilitySystem Design

#393What is the thundering herd problem?

Medium
ReliabilitySystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

#396How do you ensure data consistency across microservices?

Hard
Microservices PatternsSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
API DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design