The Oterra hotel Interview Questions and Answers

Q1. Coding Question and resume based questions
Add your answer

1 dsa question 2 sql queries questions on data analysis

Q1. Sql query using window function
Ans. 
Using window functions in SQL to perform calculations within a specific subset of data.
• Window functions are used to perform calculations across a set of rows related to the current row.

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

• Example: SELECT employee_id, salary, AVG(salary) OVER (PARTITION BY department_id) AS avg_salary FROM employees;
Answered by AI
Add your answer
Q2. Dsa question of string manipulation
Add your answer

Q1. Sql query advanced level
Add your answer
Q2. Guesstimate and resume questions
Add your answer

Q1. Basic common HR questions
Add your answer
Q2. Questions about educational background cultural fit
Add your answer

Q1. Technically full workshop,
Add your answer
Q2. Iam hard work in Formen,
Add your answer

Q1. Your introduction
Ans. 
I am a dedicated and experienced Front Office Executive with a strong background in customer service and administrative tasks.
• Over 5 years of experience in managing front office operations

• Skilled in handling customer inquiries and resolving issues

• Proficient in using office software and managing appointments

• Excellent communication and interpersonal skills

• Ability to multitask and prioritize tasks efficiently
Answered by AI
Add your answer
Q2. Why do you want to move to this brand
Ans. 
I am drawn to the brand's reputation for exceptional customer service and innovative approach to hospitality.
• Impressed by the brand's commitment to providing top-notch customer service

• Excited about the brand's innovative approach to hospitality

• Seeking new challenges and opportunities for growth in this brand
Answered by AI
Add your answer

Q1. About job responsibilities
Add your answer
Q2. Day sales, team handling,
Add your answer
Q3. Inventory management
Add your answer
Q4. To reach monthly sales target, local marketing quality Costamor service, to maintaining good quality team and food, focused on company goal etc
Add your answer

Q1. Asking about food cast, p&l, wastage control, team management, local marketing
Add your answer