Tiktok Software Engineer Data Manipulation (SQL/Python) Interview Questions
Practice the exact questions companies are asking right now.
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