Accor Interview Question

Mostly extensive on SQL Execution plan, How to do performance improvement, Clustered/Non-Clustered, ASP .NET Middleware