Miles Education - CPA & CMA Review (Hyderabad) Center Manager Interview Questions and Answers

Time management
Objective
Team dynamics

Verbal Ability
Critical Thinking

Q1. Share details of your previous job.
Add your answer

Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Add your answer

Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...read more
Add your answer

Q1. Was asked basic HR questions
Add your answer

Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Add your answer

Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...read more
Add your answer

Q1. Sql scenario based questions.
Add your answer
Q2. Partition by and group by difference
Ans. 
Partition by is used in SQL to divide the result set into partitions to perform aggregate functions, while group by is used to group rows with the same values into summary rows.
• Partition by is used in SQL to perform aggregate functions within specific partitions of the result set

• Group by is used to group rows with the same values into summary rows

• Partition by can be used with window functions to calculate aggregates wi...read more
Answered by AI
Add your answer
Q3. Writing a query
Add your answer

Q1. Case study On ideal scenario how ola cabs will be booked 100% from airport.
Ans. 
To achieve 100% booking from the airport, Ola cabs can implement dedicated airport kiosks, offer exclusive discounts for airport pickups, and provide seamless integration with flight schedules.
• Implement dedicated airport kiosks for easy booking and pickup

• Offer exclusive discounts or promotions for airport pickups to attract more customers

• Provide seamless integration with flight schedules to ensure timely pickups and dr
Answered by AI
Add your answer

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer

Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
Add your answer
Q2. Sql joins questions based on three tables, complex joins
Add your answer

Q1. Why are you interested in this internship
Add your answer
Q2. How much you expect Stephen from us
Add your answer