TikTok Software Engineer Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
3Questions
1Company
3 Questions 1 Company
Showing 3 results
TikTok
Medium
Software EngineerDebug a Hive query
You are given a prewritten Hive SQL query that produces incorrect results. Describe how you would debug it: identify logical errors (e.g., join condit...
Data Manipulation (SQL/Python)
0
0
Sep 6, 2025
TikTok
Medium
Software EngineerDiscuss Python mutability, copying, and GIL
In Python, explain the differences between mutable and immutable objects and illustrate how they affect function arguments and container behavior. Des...
Data Manipulation (SQL/Python)
0
0
Sep 6, 2025
TikTok
Medium
Software EngineerWrite complex SQL for cohorts and retention
Given tables users(uid, created_at, country), orders(order_id, uid, amount, created_at, status), and events(uid, ts, event_type, campaign), write one ...
Data Manipulation (SQL/Python)
0
0
Jul 15, 2025