READ. UNDERSTAND. PRACTICE.
Prepare for your next interview.
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
20,926 resources · Page 96 of 872
Coding questions · Apple
Analyze TSV File for User Page Visits and Patterns
This question evaluates skills in parsing and manipulating time-series user-event data, performing aggregations and path-frequency analysis, and understanding vectorized or parallel computations for performance.
Coding questions · Meta
Analyze User Engagement and Spammer Read-Rate in SQL
This question evaluates SQL-based data manipulation and analytics skills—specifically joins, time-window filtering, aggregation, and metric calculation for measuring user engagement and spammer read-rate—within the Data Manipulation (SQL/Python) domain.
Coding questions · Meta
Analyze User Engagement Metrics for Video-Calling App
This question evaluates competency in data manipulation and product-metric computation, focusing on combining user profile and call event data to produce user-level engagement measures like participation rates and average call duration.
Coding questions · Amazon
Analyze User Engagement with SQL Queries
This question evaluates proficiency in SQL data manipulation, including aggregation, window functions, joins, and temporal calculations for analyzing event and session logs.
Coding questions · Uber
Analyze User Purchase Behavior in Online Marketplace Data
This question evaluates data manipulation and analytical skills in SQL and Python, focusing on time-based aggregation, deduplication and ranking of events, calculation of rolling averages, and computation of daily active user metrics.
Coding questions · Meta
Analyze VR App Usage and Engagement Metrics
This question evaluates data manipulation and analytical competencies, including SQL/Python joins and aggregations, time-window filtering, definition of engagement metrics, and basic statistical hypothesis testing.
Coding questions · Others
Answer ancestor-walk queries on a rooted tree
This question evaluates understanding of tree data structures and ancestor-walk queries, assessing competency in traversing rooted trees, interpreting parent arrays, and designing efficient query-processing methods for large n and q.
Coding questions · Meta
Answer four string/array/battery coding questions
This set of four problems evaluates algorithmic competencies including ASCII string processing and character classification, array transformation and operation-count reasoning, cost-minimization for enforcing monotonicity under only-increase constraints, and time-based simulation of resource scheduling with recharge cycles.
Coding questions · Bloomberg
Answer multi-round grid and data-structure questions
This multi-part question evaluates algorithmic problem-solving and data structure design skills across ordered-array search with dynamic updates, expected O(1) randomized set operations, nesting-depth string parsing, Manhattan-range counting on grids, and constrained shortest-path search.
Coding questions · Meta
Answer Repeated Range Aggregate Queries on a Static BST
Preprocess a sorted array derived from a static BST to answer many inclusive range queries. Use binary-search boundaries and wide prefix sums to return both the sum and count for each range without rescanning the tree.
Coding questions · Uber
Answer Repeated Shortest Increasing-Path Queries
Preprocess shortest strictly increasing grid paths for repeated target queries, with deterministic BFS ties, predecessor reconstruction, and memory trade-offs.
Coding questions · LinkedIn
Answer Repeated Shortest Word Distance Queries
Preprocess a fixed word array and answer many shortest-distance queries between distinct repeated words. The prompt defines case-sensitive matching, ordered batch outputs, repeated queries, valid-word guarantees, and input sizes that reward indexed occurrence lists and two-pointer scans.
Coding questions · Akuna Capital
Answer SQL MCQs with reasoning
This question evaluates proficiency in SQL query semantics and reasoning about relational operations—specifically INNER, LEFT, and RIGHT JOIN behavior; GROUP BY and HAVING usage; NULL handling in comparisons and aggregates; window functions such as ROW_NUMBER and RANK; and the logical query processing order—within the Data Manipulation (SQL/Python) domain. It is commonly asked to assess the ability to interpret and justify query outcomes versus alternative answers, testing both conceptual understanding of relational theory and practical application of SQL query behavior.
Coding questions · Amazon
Append country tables and rank salaries in USD
This question evaluates skills in data manipulation and integration, specifically appending country-level tables, normalizing salaries via historical exchange rates, deduplicating by a composite primary key, and ranking results, with implementations expected in both SQL and pandas.
Coding questions · Anthropic
Apply bitwise tricks for performance
This question evaluates proficiency with bitwise operations, branchless programming, low-level performance optimizations, and microarchitectural reasoning about pipeline stalls, instruction-level parallelism, and cache behavior.
Coding questions · Capital One
Apply commands to transform a matrix
This question evaluates array and matrix manipulation skills, specifically in-place row reversal, row swapping, and 90-degree rotation, and falls under the Coding & Algorithms domain with emphasis on practical implementation.
Coding questions · Palantir
Apply Item Coupons with Exact Per-Item Cent Rounding
Calculate cart totals from item coupons with exact half-even cent rounding, unmatched-coupon handling, and integer monetary totals.
Coding questions · NVIDIA
Apply sliding window techniques
This interview question evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer for Apply sliding window techniques states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.
Coding questions · Toma
Approximate Pi from Random Points
This question evaluates a candidate's understanding of Monte Carlo estimation, basic Euclidean geometry, probability, and numerical reasoning when using random sampling to approximate mathematical constants.
Coding questions · LinkedIn
Arrange Nonnegative Integers to Form the Largest Number
Arrange nonnegative integers so their decimal strings form the largest possible concatenation. The prompt requires every value exactly once, returns a string for unbounded result length, defines the all-zero case, and includes order-sensitive examples.
Coding questions · Microsoft
Assemble DNA payload strings from tagged fragments
This question evaluates proficiency in string manipulation, sequence assembly, and labeled-graph path reconstruction—skills involved in ordering fragments by matching start/end tags and concatenating payloads—and it belongs to the Coding & Algorithms domain.
Coding questions · Freddie Mac
Assess SQL cleaning, mapping, joins, keys, and DDL/DML
This question evaluates skills in data cleaning, deduplication, schema mapping, referential integrity, DDL/DML, and SQL/Python data manipulation, focusing on joins, keys, validation of values, and ETL mapping competencies.
Coding questions · Fannie Mae
Assess SQL joins, unions, windows, dedup, and pandas
This question evaluates proficiency in SQL and pandas data-manipulation techniques, including aggregations with NULL semantics, various join types, set operations and deduplication, window functions, and reconciling normalized and denormalized sources.
Coding questions · eBay
Assign Ads to Browser Positions
This question evaluates algorithmic problem-solving around randomized selection, constraint-based resource allocation, and per-user state management, including enforcing eligibility rules and incrementing display counts.