cswork / libraryOpen practice workspace

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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. 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.

  15. 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.

  16. 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.

  17. 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.

  18. 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.

  19. 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.

  20. 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.

  21. 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.

  22. 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.

  23. 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.

  24. 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.