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.