Top 50 transactions Interview Questions
The most frequently asked transactions questions across all roles and companies, ranked by real interview frequency. Updated daily.
Calculate monthly active-user retention for Unity Ads using CTEs, joins, date truncation, and conditional aggregation.
Insurify
Unity
DoorDashCalculate each customer's 7-day transaction average using daily aggregation and a PostgreSQL window frame.
Truist
BBVA
QuantexaIdentify duplicate transaction rows, retain the earliest record, and delete later duplicates safely.
Oracle
Amex
BrooksourceUse window functions and conditional aggregation to flag completed transactions that may duplicate one another within five minutes.
Revolut
RobinhoodUse ROW_NUMBER and a user join to find the three highest completed AARP Rewards purchases per user category.
AARP
Insight Global
SonySummarize transaction duration and failed requests to support reasoning about concurrent database operations.
ZscalerSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Implement nested key-value transactions with set, get, delete, commit, and rollback using layered state.
NetflixAggregate Ramp card transaction amounts into contiguous minute buckets using a hash map.
RAMP Consulting Group
Ramp