Tech Interview Questions

Practice the exact questions companies are asking right now.

Questions

383

Companies

980

Updated

11.12.2026

383 Questions 980 Companies11.12.2026

PLTCHK

"I got asked a hardcore MCM DP question and I saw it on PracHub as well. Solved that question in 5 minutes. Without PracHub I doubt I could solve it in 5 hours. Though somehow didn't get hired, perhaps I guess I solved it too fast? /s"

_The_TaNk_

"Believe me i'm a student here jn US. Recently interviewed for MSFT. They asked me exact question from PracHub. I saw it the night before and ignored it cause why waste time on random sites. I legit wanna go back and redo this whole thing if I had chance. Not saying will work for everyone but there is certainly some merit to that website. And i'm gonna use it in future prep from now on like lc tagged"

ChrisSenior SWE, LinkedIn

"10 years of experience but never worked at a top company. PracHub's senior-level questions helped me break into FAANG at 35. Age is just a number."

sleepy33

"I was skeptical about the 'real questions' claim, so I put it to the test. I searched for the exact question I got grilled on at my last Meta onsite... and it was right there. Word for word."

JakeSenior ML Engineer, Lyft

"Got a Google recruiter call on Monday, interview on Friday. Crammed PracHub for 4 days. Passed every round. This platform is a miracle worker."

nuggetlord

"I've used LC, Glassdoor, and random Discords. Nothing comes close to the accuracy here. The questions are actually current — that's what got me. Felt like I had a cheat sheet during the interview."

CarlosFull Stack, Shopify

"The solution quality is insane. It covers approach, edge cases, time complexity, follow-ups. Nothing else comes close."

boba.tea.vibes

"Legit the only resource you need. TC went from 180k -> 350k. Just memorize the top 50 for your target company and you're golden."

AndySWE-II, Google

"PracHub Premium for one month cost me the price of two coffees a week. It landed me a $280K+ starting offer."

couchpotato99

"Literally just signed a $600k offer. I only had 2 weeks to prep, so I focused entirely on the company-tagged lists here. If you're targeting L5+, don't overthink it."

ShrutiData Engineer, Salesforce

"Coaches and bootcamp prep courses cost around $200-300 but PracHub Premium is actually less than a Netflix subscription. And it landed me a $178K offer."

midnightramen

"I honestly don't know how you guys gather so many real interview questions. It's almost scary. I walked into my Amazon loop and recognized 3 out of 4 problems from your database."

BiancaFrontend Eng, Figma

"Discovered PracHub 10 days before my interview. By day 5, I stopped being nervous. By interview day, I was actually excited to show what I knew."

tambrahm007

"I recently cleared Uber interviews (strong hire in the design round) and all the questions were present in prachub."

toa

"The search is what sold me. I typed in a really niche DP problem I got asked last year and it actually came up, full breakdown and everything. These guys are clearly updating it constantly."

PLTCHK

_The_TaNk_

ChrisSenior SWE, LinkedIn

"10 years of experience but never worked at a top company. PracHub's senior-level questions helped me break into FAANG at 35. Age is just a number."

sleepy33

"I was skeptical about the 'real questions' claim, so I put it to the test. I searched for the exact question I got grilled on at my last Meta onsite... and it was right there. Word for word."

JakeSenior ML Engineer, Lyft

"Got a Google recruiter call on Monday, interview on Friday. Crammed PracHub for 4 days. Passed every round. This platform is a miracle worker."

nuggetlord

CarlosFull Stack, Shopify

"The solution quality is insane. It covers approach, edge cases, time complexity, follow-ups. Nothing else comes close."

boba.tea.vibes

"Legit the only resource you need. TC went from 180k -> 350k. Just memorize the top 50 for your target company and you're golden."

AndySWE-II, Google

"PracHub Premium for one month cost me the price of two coffees a week. It landed me a $280K+ starting offer."

couchpotato99

"Literally just signed a $600k offer. I only had 2 weeks to prep, so I focused entirely on the company-tagged lists here. If you're targeting L5+, don't overthink it."

ShrutiData Engineer, Salesforce

"Coaches and bootcamp prep courses cost around $200-300 but PracHub Premium is actually less than a Netflix subscription. And it landed me a $178K offer."

midnightramen

"I honestly don't know how you guys gather so many real interview questions. It's almost scary. I walked into my Amazon loop and recognized 3 out of 4 problems from your database."

BiancaFrontend Eng, Figma

"Discovered PracHub 10 days before my interview. By day 5, I stopped being nervous. By interview day, I was actually excited to show what I knew."

tambrahm007

"I recently cleared Uber interviews (strong hire in the design round) and all the questions were present in prachub."

toa

"The search is what sold me. I typed in a really niche DP problem I got asked last year and it actually came up, full breakdown and everything. These guys are clearly updating it constantly."

Showing 20 results

Yahoo

Easy

Data ScientistSenior+

Feed Module Impressions, Clicks and CTR on Web Platforms Over a 7-Day Window

A news portal's homepage is made of content modules, and a daily traffic table records how often each article was shown and clicked in each module on ...

Data Manipulation (SQL/Python)SQL

Write monthly touches and last-touch SQL

You have two tables tracking marketing touches and downstream conversions. Write SQL to answer the three prompts below. Assume a warehouse like Postgr...

Data Manipulation (SQL/Python)SQLMetrics & KPIs

100 people solved

Oct 13, 2025

Medium

Data ScientistSenior+

Query US-based users and most active forums

You are given user and post data for an online forum platform. Tables (schemas) Assume the following tables: users - user_id BIGINT (PK) - home_countr...

Data Manipulation (SQL/Python)SQL

Define Ultra success and detect suspicious transactions

Assume the following relevant columns are available, and all timestamps are stored in UTC: - users(user_id BIGINT PRIMARY KEY, create_date TIMESTAMP, ...

Analytics & ExperimentationMetrics & KPIsSQL

Create and query an e-commerce schema

PostgreSQL only. 1) Create these tables with appropriate types and constraints (choose minimal correct types): products(product_id PK, name NOT NULL, ...

Data Manipulation (SQL/Python)SQL

Compute violation rate and flag precision in SQL

You are analyzing a Trust & Safety product in BigQuery. Assume 'today' is 2025-09-01 (UTC). Define precise metrics and write SQL to compute them, bein...

Data Manipulation (SQL/Python)SQLMetrics & KPIs

Software Engineer Locked

Design query pagination for large datasets

This question evaluates a candidate's understanding of pagination strategies, cursor/keyset design, SQL query formulation, consistency guarantees unde...

System DesignAPI DesignIndexing & Query Performance

Find top countries by population per continent

Table world_population - continent VARCHAR - country VARCHAR - population BIGINT Assume each row is a country’s latest population and (continent, coun...

Data Manipulation (SQL/Python)SQL

119 people solved

Feb 1, 2026

Count heavy callers in 7 days

This question evaluates proficiency in SQL-based data manipulation and analytics, covering joins between user and call records, aggregation and distin...

Data Manipulation (SQL/Python)SQLMetrics & KPIs

Write SQL for percent and window changes

Use PostgreSQL. Assume today = 2025-09-01. You must use CTEs and multiple window functions. Schema and tiny samples are below. Schema: - exposures(uni...

Data Manipulation (SQL/Python)SQL

Write SQL for DAU and first-purchase conversion

Today is 2025-09-01. Using the schema and sample data below, write a single ANSI-SQL query that returns one row per day for the last 7 days (2025-08-2...

Data Manipulation (SQL/Python)SQL

Write SQL: sum values ≤ each row’s value

Given table numbers(id INT PRIMARY KEY, val INT), return for every row the sum of all val across the entire table that are ≤ that row’s val (i.e., com...

Data Manipulation (SQL/Python)SQLIndexing & Query Performance

Data ScientistSenior+

Compare ROW_NUMBER, RANK, and DENSE_RANK for Top-k Results

Compare ROW_NUMBER, RANK, and DENSE_RANK for Top-k Results Explain how ROW_NUMBER, RANK, and DENSE_RANK differ when selecting top results within a gro...

Data Manipulation (SQL/Python)SQL

Calculate Regional Revenue and Identify Top Customers

Customers | customer_id | name | region | |-------------|-------|--------| | 1 | Alice | East | | 2 | Bob | West | | 3 ...

Data Manipulation (SQL/Python)SQLMetrics & KPIs

Data Scientist Locked

Write SQL using HAVING and window functions

This question evaluates SQL data manipulation competency, focusing on aggregation filtering with HAVING and the use of window functions for running co...

Data Manipulation (SQL/Python)SQL

Data Scientist Locked

Compute churn with re-subscriptions

This question evaluates proficiency in event-time data manipulation, temporal aggregation, and subscription-state logic for computing conversion and r...

Data Manipulation (SQL/Python)SQLSegmentation & Cohort Analysis

Business Intelligence Engineer

Identify Top-Buying Customers Daily with SQL Query

PRIME +-------------+------------+----------+ | Customer_ID | Start_Date | End_Date | +-------------+------------+----------+ | 1 | 2025-01-...

Data Manipulation (SQL/Python)SQLMetrics & KPIs

Find top category per region in Aug 2025

You are given the following schema and sample data. Schema: - customers(customer_id INT, name TEXT, region TEXT) - orders(order_id INT, customer_id IN...

Data Manipulation (SQL/Python)SQL

Compute party time blocks per neighborhood

You are given two datasets: 1. Parties: - party_id (string or integer) - start_timestamp (e.g., UNIX timestamp or datetime) - end_timestamp (...

Coding & AlgorithmsIntervals & Scheduling

Design Video Call Analytics Tables

You are building analytics tables for Discord video calls. Video-call activity is recorded from both client-side and server-side logs. Design a data m...

System DesignDimensional ModelingSQL

237 people solved

Apr 3, 2026

Visa Tools

Visa Sponsors

H-1B Odds Calculator

Visa Bulletin

Tech Interview Questions

Feed Module Impressions, Clicks and CTR on Web Platforms Over a 7-Day Window

Write monthly touches and last-touch SQL

Query US-based users and most active forums

Define Ultra success and detect suspicious transactions

Create and query an e-commerce schema

Compute violation rate and flag precision in SQL

Design query pagination for large datasets

Find top countries by population per continent

Count heavy callers in 7 days

Write SQL for percent and window changes

Write SQL for DAU and first-purchase conversion

Write SQL: sum values ≤ each row’s value

Compare ROW_NUMBER, RANK, and DENSE_RANK for Top-k Results

Calculate Regional Revenue and Identify Top Customers

Write SQL using HAVING and window functions

Compute churn with re-subscriptions

Identify Top-Buying Customers Daily with SQL Query

Find top category per region in Aug 2025

Compute party time blocks per neighborhood

Design Video Call Analytics Tables

Choose your next challenge

Blind 75

ML System Design

System Design Interview