Hi Shalini, I understand that an internship is a short period for learning new things. To make the most of it, I suggest you first draft your questionnaire, and then seek help from seniors for valuable suggestions and feedback.
As mentioned earlier, we lack knowledge about your company and its people. You, being with them for some time, have insights. Consult your project guide at the company to understand the people and create a motivation questionnaire. There is no need to categorize the questionnaires based on hierarchy unless specified by your project guide.
When Framing Questions, Consider:
1. Work hours and work-life balance
2. Male/Female ratio
3. Include a few open-ended questions to understand individual motivations
4. Since you are pursuing an MBA, ensure the questionnaire is detailed, providing valuable learning points.
Hope this helps :)