Dataford
Top 50
Topic
~8h total · Updated weekly · Last refresh Jul 24

Top 50 null handling Interview Questions

The most frequently asked null handling questions across all roles and companies, ranked by real interview frequency. Updated weekly.

Start practicing free →
NULLs in Aggregate Metrics
Easy

Explain how PostgreSQL aggregate functions treat NULL values and when to use COALESCE to control results.

null handlingCase WhenAggregations
Recently asked
NTT DATASanta Clara Family Health PlanExusia
Handling Missing and Skewed Data
Medium

Explain how to handle NULLs, skewed values, and outliers when preparing an analysis dataset using SQL.

Data Qualitynull handlingData Wrangling
Recently asked
McKinsey &ProSidianTalent Tribe Consulting
Comparing Join Types in Reporting
Easy

Explain how INNER, LEFT, RIGHT, and FULL OUTER JOIN differ, especially in how they return matched and unmatched rows.

null handlingJoinsData Wrangling
Recently asked
InfosysRobert HalfCRIF
LEFT JOIN vs INNER JOIN
Easy

Explain how INNER JOIN and LEFT JOIN differ when analyzing matched and unmatched records in SQL.

null handlingJoinsData Wrangling
Recently asked
American ExpressFitch RatingsNatixis Corporate & Investment Banking
Clean Nulls and Duplicates Before Joins
Medium

Explain how to handle NULL keys and duplicate rows before joining large PostgreSQL tables.

null handlingJoinsdata integrity
Recently asked
GoogleNevada Staffing
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Owning Ambiguous Data Quality Issues
Medium

Tests ownership under ambiguity in a data engineering context, especially how you diagnose unclear data issues and drive a measurable resolution.

pandasnull handlingperformance
Recently asked
Susquehanna International GroupHinge healthIDinsight

Open any question for its full solution and discussion.

Browse all questions →