SQL Practice Logo

SQLPractice Online

Level 5 - SeniorScenario-Based Questions

Scenario: Introduce Multi-Column Business Key

Interviewer prompt: invoices must be unique by (tenant_id, external_invoice_id) for active rows only. Write enforcement SQL.

Schema Context

invoices(invoice_id, tenant_id, external_invoice_id, deleted_at)