Citi Interview Question

Oops concepts DB optimization profiler etc