Given a scnerio, create a database model

How to improve performance?

What are the other questions they ask ? Related to programming

Given some queries asked you to find where the clustered index or non clustered indexes are focused. This is what all I remember, and after that they ask you to demo your prev project on your laptop and few questions related to that and the written test.

Can you tell the exact questions they asked you in onsite? What Programming questions? What follow up questions after demo? What areas to focus to be successful and get offer?

Can you tell the programming questions they had asked? Was it based on C#? would you be able to tell the topics we should go through to answer those programming questions? What topics should we focus on database questions ?