Rapido Interview Questions, Process, and Tips

MCQ based of loops, iteration, pseudocode, SQL and debugging were asked. 30 questions in total and fairly easy. 1 hour duration and I attempted about 20 questions. No negative marking. It was conducted on HackerEarth platform.

Q1. 1. Tell me about yourself
Add your answer
Q2. 2. Basic Statistical Questions > mean, median, mode > data cleaning process. > how do you treat missing values? > what are joins and give an application of joins in data? > what are views in sql? > explain...read more
Add your answer
Q3. 3. Execute a SQL query to get the top second row.
Ans. 
SQL query to get the second row from the top.
• Use the LIMIT keyword to limit the number of rows returned.

• Use the OFFSET keyword to skip the first row.

• Order the rows by a column to ensure consistent results.
Answered by AI
Add your answer
Q4. 4. Difference between DBMS and RDBMS
Ans. 
DBMS is a software system to manage databases, while RDBMS is a type of DBMS that uses a relational model.
• DBMS stands for Database Management System, while RDBMS stands for Relational Database Management System.

• DBMS can manage any type of database, while RDBMS uses a specific model based on tables, keys, and relationships.

• DBMS is less strict in terms of data integrity, while RDBMS enforces strict rules to ensure data c...read more
Answered by AI
Add your answer
Q5. 5. What are stored procedures and when are they used?
Ans. 
Stored procedures are pre-written SQL codes that can be saved and reused. They are used to improve performance and security.
• Stored procedures are used to reduce network traffic by executing a batch of SQL statements at once.

• They can improve performance by reducing the amount of time spent parsing and optimizing SQL statements.

• Stored procedures can also enhance security by allowing access to only specific parts of the d...read more
Answered by AI
Add your answer

Q1. 1. Tell me about yourself
Add your answer
Q2. 2. Explain the data process in your project
Ans. 
The data process in my project involves data collection, cleaning, analysis, and visualization.
• Data collection involved gathering data from various sources such as surveys, databases, and APIs.

• Data cleaning was done to remove duplicates, missing values, and outliers.

• Data analysis was performed using statistical methods and machine learning algorithms.

• Data visualization was used to present the findings in a clear and co...read more
Answered by AI
Add your answer
Q3. 3. What was the finding from the project?
Ans. 
The finding from the project was that there is a strong correlation between customer satisfaction and repeat purchases.
• The project analyzed customer satisfaction surveys and purchase data

• The data showed that customers who reported high satisfaction scores were more likely to make repeat purchases

• This finding suggests that improving customer satisfaction can lead to increased customer loyalty and revenue
Answered by AI
Add your answer
Q4. 4. A case study based on hypothesis testing and its application
Add your answer
Q5. 5. Name three things that your learnt from your Data Science and Analytics course.
Ans. 
Three things I learned from my Data Science and Analytics course are statistical analysis, data visualization, and machine learning.
• Statistical analysis: Learned how to use statistical methods to analyze data and draw conclusions.

• Data visualization: Learned how to create visual representations of data to better understand patterns and trends.

• Machine learning: Learned how to use algorithms to build predictive models and
Answered by AI
Add your answer

It was a written SQL , Python , Statistics test at the office.

Q1. Discussion of the queries and codes written in the first round and its optimizing
Add your answer
Q2. Prime numbers between two number ranges
Add your answer
Q3. Number of rows in the output after different joins
Add your answer
Q4. SQL query optimization
Add your answer

Q1. About Rapido, Why Rapido?
Add your answer
Q2. How fit are you for the BI team?
Add your answer

Q1. General HR questions
Add your answer

Q1. Pick up and drop
Add your answer
Q2. Parcel and delivery service in rapido
Ans. 
Rapido does not currently offer parcel and delivery services.
• Rapido is primarily a bike taxi service, focusing on transporting passengers from one place to another.

• They do not have a dedicated parcel and delivery service like other companies such as Uber Eats or Swiggy Genie.

• Customers can use Rapido for quick and convenient transportation within cities, but not for sending parcels or packages.
Answered by AI
Add your answer
Q3. Uber also parcel and delivery
Add your answer
Q4. I want to parcel delivery loading and unloading in in airport ground staff work and food delivery
Add your answer
Q5. And I have experience in sales and marketing
Add your answer

Q1. Please explain your portfolio and the intention behind the selected projects.
Add your answer
Q2. What would be your strategy is the team fails to deliver quality work.
Add your answer