Home/Companies/Mastercard
MC

Mastercard Interview Questions

Global payments technology company with major engineering hubs in Pune and Gurgaon. Interviews test Java, microservices, system design for high-throughput payment processing, and SQL. Security, fraud detection patterns, and API gateway design are common themes.

343questions
207 Medium136 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 an API Gateway and what does it do?

Medium
ArchitectureMicroservices

#72How do microservices communicate?

Medium
CommunicationMicroservices

#73What is service discovery in microservices?

Medium
InfrastructureMicroservices

#74What is the Circuit Breaker pattern and how does it prevent cascading failures?

Medium
ResilienceMicroservices

#75What is distributed tracing and why is it important?

Medium
ObservabilityMicroservices

#76What is the Strangler Fig pattern for microservices migration?

Medium
ArchitectureMicroservices

#77What is a sidecar pattern?

Hard
InfrastructureMicroservices

#78How do you manage configuration in microservices?

Medium
InfrastructureMicroservices

#79What are the 12-Factor App principles?

Medium
ArchitectureMicroservices

#80What is event-driven architecture and when should you use it?

Medium
ArchitectureMicroservices

#81What is the difference between orchestration and choreography in Saga?

Hard
Distributed TransactionsMicroservices

#82How do you test microservices effectively?

Medium
TestingMicroservices

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

Hard
InfrastructureMicroservices

#84How do you ensure data consistency across microservices?

Hard
Distributed TransactionsMicroservices

#85What is the circuit breaker pattern?

Medium
ResilienceMicroservices

#86What is service discovery and how does it work?

Medium
InfrastructureMicroservices

#87What is the Bulkhead pattern?

Medium
ResilienceMicroservices

#88What is the Retry pattern and how do you implement it safely?

Medium
ResilienceMicroservices

#89What is the difference between choreography and orchestration in Sagas?

Hard
Distributed TransactionsMicroservices

#90What is the Backend for Frontend (BFF) pattern?

Medium
ArchitectureMicroservices

#91How do you implement distributed tracing?

Medium
ObservabilityMicroservices

#92What is the Strangler Fig pattern for migrating a monolith?

Medium
ArchitectureMicroservices

#93What is eventual consistency and how do you design for it?

Hard
Distributed TransactionsMicroservices

#94How do you version microservice APIs?

Medium
API DesignMicroservices

#95What is the Sidecar pattern?

Medium
InfrastructureMicroservices

#96What is a dead letter queue and why is it important?

Medium
MessagingMicroservices

#97How do you implement health checks in microservices?

Medium
InfrastructureMicroservices

#98What is the Outbox pattern and how does it guarantee event delivery?

Hard
MessagingMicroservices

#99What is idempotency and how do you implement it in microservices?

Hard
Distributed TransactionsMicroservices

#100What are the 12-Factor App principles?

Medium
ArchitectureMicroservices

#101How do you handle secrets management in microservices?

Hard
SecurityMicroservices

#102What is the Ambassador pattern in microservices?

Medium
InfrastructureMicroservices

#103How do you implement inter-service authentication?

Hard
SecurityMicroservices

#104What is the Throttling pattern and how does it differ from rate limiting?

Medium
ResilienceMicroservices

#105What is CQRS and how does it apply to microservices?

Hard
ArchitectureMicroservices

#106How do you test microservices?

Medium
TestingMicroservices

#107What is service isolation and why is it important?

Medium
ArchitectureMicroservices

#108What is an Event-Driven Architecture?

Medium
ArchitectureMicroservices

#109How do you handle database per service in practice?

Hard
ArchitectureMicroservices

#110What is the Role of API composition in microservices?

Medium
ArchitectureMicroservices

#111What is graceful degradation in microservices?

Medium
ResilienceMicroservices

#112What is the Event Sourcing pattern?

Hard
ArchitectureMicroservices

#113How do you implement logging in a microservices environment?

Medium
ObservabilityMicroservices

#114What is the two-phase commit vs Saga for distributed transactions?

Hard
Distributed TransactionsMicroservices

#115How do you handle timeouts in microservices?

Medium
ResilienceMicroservices

#116What is the Scatter-Gather pattern?

Medium
ArchitectureMicroservices

#117What is the difference between a microservice and a nanoservice?

Medium
ArchitectureMicroservices

#118How do you implement canary deployments in microservices?

Medium
InfrastructureMicroservices

#119What is a Service Registry?

Medium
InfrastructureMicroservices

#120What is blue-green deployment and how does it work?

Medium
InfrastructureMicroservices

#121What is the Aggregator pattern?

Medium
ArchitectureMicroservices

#122How do microservices handle configuration management?

Medium
InfrastructureMicroservices

#123What is the Proxy pattern in microservices?

Medium
InfrastructureMicroservices

#124How do you implement distributed locking in microservices?

Hard
Distributed TransactionsMicroservices

#125What is Kafka and why is it popular in microservices?

Medium
MessagingMicroservices

#126How do you manage service dependencies in microservices?

Hard
ArchitectureMicroservices

#127What is a bounded context?

Hard
ArchitectureMicroservices

#128How do you implement a request-reply pattern over async messaging?

Hard
MessagingMicroservices

#129What is the Token Bucket algorithm and how is it used for rate limiting?

Hard
ResilienceMicroservices

#130How do you handle schema evolution in event-driven systems?

Hard
MessagingMicroservices

#131What is the difference between a monolith, microservices, and modular monolith?

Medium
ArchitectureMicroservices

#132What is the Choreography pattern in detail?

Hard
Distributed TransactionsMicroservices

#133What is a composite microservice?

Medium
ArchitectureMicroservices

#134How do you deal with "chatty" microservices?

Medium
ArchitectureMicroservices

#135What is a process manager / workflow engine in microservices?

Hard
ArchitectureMicroservices

#136How do you implement zero-downtime deployments for microservices?

Hard
InfrastructureMicroservices

#137What is the Anti-Corruption Layer pattern?

Medium
ArchitectureMicroservices

#138What are the common pitfalls of microservices adoption?

Medium
ArchitectureMicroservices

#139What is the difference between orchestration and choreography?

Medium
Distributed TransactionsMicroservices

#140How do you implement a consistent read across microservices?

Hard
Distributed TransactionsMicroservices

#141What is load shedding?

Medium
ResilienceMicroservices

#142What is the difference between gRPC and REST for inter-service communication?

Medium
API DesignMicroservices

#143What is the Gateway Aggregation pattern vs Gateway Routing?

Medium
ArchitectureMicroservices

#144What is the Inbox pattern?

Hard
MessagingMicroservices

#145How do you handle versioning of events in Kafka?

Hard
MessagingMicroservices

#146What is the Open Host Service pattern?

Medium
ArchitectureMicroservices

#147How do you implement service-level SLOs in microservices?

Medium
ObservabilityMicroservices

#148What is the Claim Check pattern?

Medium
MessagingMicroservices

#149What is service mesh traffic management?

Hard
InfrastructureMicroservices

#150What is the difference between horizontal and vertical scaling for microservices?

Medium
InfrastructureMicroservices

#151What is the role of a message schema registry?

Medium
MessagingMicroservices

#152How do you handle service discovery with Kubernetes?

Medium
InfrastructureMicroservices

#153How do you implement an API gateway from scratch?

Hard
ArchitectureMicroservices

#154What is consumer-driven contract testing (Pact)?

Hard
TestingMicroservices

#155How do you use feature toggles in microservices?

Medium
ArchitectureMicroservices

#156What is polyglot persistence in microservices?

Medium
Data ManagementMicroservices

#157What are distributed caching strategies for microservices?

Hard
InfrastructureMicroservices

#158How do you design a CI/CD pipeline for microservices?

Hard
InfrastructureMicroservices

#159How do you implement observability with Micrometer, Prometheus, and Grafana?

Hard
ObservabilityMicroservices

#160What is the Retry pattern and when should you NOT retry?

Medium
ResilienceMicroservices

#161How do you implement Saga compensation (rollback) in detail?

Hard
Distributed TransactionsMicroservices

#162What is multi-tenancy in microservices and how do you implement it?

Hard
ArchitectureMicroservices

#163What are the steps to migrate a monolith to microservices using the Strangler Fig pattern?

Hard
ArchitectureMicroservices

#164How do you design microservices for failure?

Hard
ResilienceMicroservices

#165What is data mesh and how does it relate to microservices data ownership?

Hard
Data ManagementMicroservices

#166What is a sidecar proxy and how does Envoy work?

Hard
InfrastructureMicroservices

#167How do you handle inter-service authorization (not just authentication)?

Hard
SecurityMicroservices

#168When should you NOT use microservices?

Medium
ArchitectureMicroservices

#169Explain the CAP theorem.

Medium
FundamentalsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Database DesignSystem Design

#172Explain cache invalidation strategies.

Medium
CachingSystem Design

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

Medium
System Design ProblemsSystem Design

#174What is the Saga pattern in microservices?

Hard
Microservices PatternsSystem Design

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

Hard
Microservices PatternsSystem Design

#176What are rate limiting algorithms?

Hard
Distributed SystemsSystem Design

#177What is the Circuit Breaker pattern?

Medium
Microservices PatternsSystem Design

#178How do you design for high availability?

Hard
ReliabilitySystem Design

#179What is eventual consistency?

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
System Design ProblemsSystem Design

#184What is the difference between REST and gRPC?

Medium
FundamentalsSystem Design

#185What is the Outbox Pattern?

Hard
Microservices PatternsSystem Design

#186How do you design a distributed cache layer?

Hard
CachingSystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Database DesignSystem Design

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

Medium
Real-World DesignSystem Design

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

Hard
Database DesignSystem Design

#196How do you handle distributed transactions across microservices?

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
InfrastructureSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
InfrastructureSystem Design

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

Hard
ReliabilitySystem Design

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

Medium
Distributed SystemsSystem Design

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

Hard
API DesignSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ObservabilitySystem Design

#207How do you implement idempotency in APIs?

Medium
API DesignSystem Design

#208How would you design a distributed job scheduler?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
InfrastructureSystem Design

#213What is the strangler fig pattern?

Medium
FundamentalsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

#216How do you design a fraud detection system?

Hard
Real-World DesignSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

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

Hard
Distributed SystemsSystem Design

#221How do you implement zero-downtime deployments?

Medium
InfrastructureSystem Design

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

Hard
Distributed SystemsSystem Design

#223How do you design a payment processing system?

Hard
Real-World DesignSystem Design

#224How would you design an autocomplete system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#229What is the CQRS pattern?

Hard
Distributed SystemsSystem Design

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

Medium
SecuritySystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
ReliabilitySystem Design

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

Medium
Database DesignSystem Design

#235How do you design an access control system?

Medium
SecuritySystem Design

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

Hard
Real-World DesignSystem Design

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

Medium
Microservices PatternsSystem Design

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

Hard
Distributed SystemsSystem Design

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

Hard
Real-World DesignSystem Design

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

Hard
PerformanceSystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
Database DesignSystem Design

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

Hard
Real-World DesignSystem Design

#244How do you design a recommendation system?

Hard
Real-World DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
Real-World DesignSystem Design

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

Medium
API DesignSystem Design

#248How do you handle large file uploads efficiently?

Medium
API DesignSystem Design

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

Hard
Database DesignSystem Design

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

Medium
InfrastructureSystem Design

#251How do you design for disaster recovery?

Hard
ReliabilitySystem Design

#252What is the thundering herd problem?

Medium
ReliabilitySystem Design

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

Hard
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

#255How do you ensure data consistency across microservices?

Hard
Microservices PatternsSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
API DesignSystem Design

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

Medium
Distributed SystemsSystem Design

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

Medium
FundamentalsSystem Design

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

Medium
IndexingMySQL

#261What is a covering index?

Medium
IndexingMySQL

#262What are MySQL transaction isolation levels?

Hard
TransactionsMySQL

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

Hard
TransactionsMySQL

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

Medium
PerformanceMySQL

#265What are window functions in SQL?

Hard
Advanced SQLMySQL

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

Medium
Advanced SQLMySQL

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

Medium
PerformanceMySQL

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

Medium
TransactionsMySQL

#269How do you optimize a slow MySQL query?

Hard
PerformanceMySQL

#270What is database normalization?

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL

#272What is partitioning in MySQL?

Hard
Schema DesignMySQL

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

Medium
Advanced SQLMySQL

#274How does the InnoDB storage engine handle locking?

Hard
TransactionsMySQL

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

Hard
Schema DesignMySQL

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

Medium
IndexingMySQL

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

Medium
IndexingMySQL

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

Medium
PerformanceMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Medium
QueryingMySQL

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

Hard
ReplicationMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

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

Medium
PerformanceMySQL

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

Hard
PerformanceMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Medium
TransactionsMySQL

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

Hard
PerformanceMySQL

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

Hard
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
InternalsMySQL

#294How do you implement pagination in MySQL efficiently?

Medium
PerformanceMySQL

#295What is group replication and InnoDB Cluster?

Hard
ReplicationMySQL

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

Medium
Schema DesignMySQL

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

Hard
PerformanceMySQL

#298What are common MySQL performance anti-patterns?

Medium
PerformanceMySQL

#299What is a generated column in MySQL?

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Medium
Schema DesignMySQL

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

Hard
TransactionsMySQL

#303How do you handle hierarchical data in MySQL?

Hard
Schema DesignMySQL

#304What is ProxySQL and how is it used?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
FundamentalsMySQL

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

Medium
Schema DesignMySQL

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

Hard
ReplicationMySQL

#310How do you use MySQL's performance_schema?

Hard
PerformanceMySQL

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

Hard
IndexingMySQL

#312How do you implement soft delete in MySQL?

Medium
Schema DesignMySQL

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

Hard
TransactionsMySQL

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

Medium
FundamentalsMySQL

#315How do you handle time zones in MySQL?

Medium
OperationsMySQL

#316How do you monitor MySQL in production?

Medium
OperationsMySQL

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

Medium
QueryingMySQL

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

Hard
SecurityMySQL

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

Medium
OperationsMySQL

#320What is the EXPLAIN ANALYZE command?

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

#322What is the MySQL query execution order?

Medium
QueryingMySQL

#323How do you scale MySQL reads?

Medium
ReplicationMySQL

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

Medium
ReplicationMySQL

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

Medium
QueryingMySQL

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

Medium
TransactionsMySQL

#327What is the purpose of the information_schema?

Medium
OperationsMySQL

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

Hard
InternalsMySQL

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

Medium
PerformanceMySQL

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

Medium
OperationsMySQL

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

Hard
IndexingMySQL

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

Medium
QueryingMySQL

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

Medium
QueryingMySQL

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

Medium
TransactionsMySQL

#335How do you implement a queue in MySQL?

Hard
Schema DesignMySQL

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

Medium
SecurityMySQL

#337What is index merge optimization?

Hard
IndexingMySQL

#338How do you detect and resolve replication lag?

Hard
ReplicationMySQL

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

Hard
InternalsMySQL

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

Hard
SecurityMySQL

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

Hard
TransactionsMySQL

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

Medium
Schema DesignMySQL

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

Hard
OperationsMySQL