SQL Practice Logo

SQLPractice Online

Level 5 - SeniorOutput Prediction Questions

Output: Partial Unique Constraint

Interviewer prompt: With unique index on (org_id, lower(name)) WHERE deleted_at IS NULL, will inserting org_id=10,name='ACME',deleted_at=NULL succeed if an existing row has org_id=10,name='acme',deleted_at='2025-01-01'? Answer Yes or No.