Reviewed by Aditya Kumar · Last reviewed 2026-03-24
Super key: Any column set that uniquely identifies a row; can have redundant cols. Minimal super key = candidate key. Composite key: Multi-column key, e.g. (order_id, line_item_id). PK can be composite. Super key is broader; composite is a type....
Super key: Any column set that uniquely identifies a row; can have redundant cols. Minimal super key = candidate key. Composite key: Multi-column key, e.g. (order_id, line_item_id). PK can be composite. Super key is broader; composite is a type. Choose minimal candidate as PK.
Red Flag: Using them interchangeably. Pro-Move: 'We use composite PK (tenant_id, id) for multi-tenant; super key includes tenant_id+email for uniqueness check.'
According to DataEngPrep.tech, this is one of the most frequently asked General/Other interview questions, reported at 1 company. DataEngPrep.tech maintains an editor-reviewed database of 1,863 data engineering interview questions across 7 categories.