Orientallabs Retail Services Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. SQL query related to Uber
Add your answer

Q1. Question related to Tableau and one SQL question
Add your answer

It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.

There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.

Q1. Email validation question from coding challenge
Add your answer
Q2. Binary Search on rotated arrays
Add your answer
Q3. About projects (reason behind using the mentioned database)
Add your answer
Q4. Use of package.json file
Add your answer
Q5. What are scripts in package.json file
Add your answer

Q1. I have around 9 rounds interview in span of 2 months
Add your answer

Q1. Everyday one round interview
Add your answer

Q1. Same as above .it is too much
Add your answer

Q1. Same as above .it is too much
Add your answer

Q1. Same only .it is too much
Add your answer

4 member team interview

Q1. One on one interview
Add your answer

Q1. Reference . through referral I sent my resume
Add your answer

Q1. Salary discussion
Add your answer

Q1. It is too much
Add your answer

Q1. Graph theory questions related
Add your answer
Q2. Programming,data structure and algo
Add your answer

Q1. Intro about your self
Add your answer
Q2. Mostly focused on CSE fundamentals
Add your answer

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

Q1. Salary why not time being paid ?
Add your answer
Q2. Without any evidence how blaming staff ??
Ans. 
Blaming staff without evidence is unprofessional and can damage morale and trust within the team.
• Avoid jumping to conclusions without concrete evidence

• Encourage open communication and transparency

• Focus on problem-solving rather than assigning blame

• Provide constructive feedback and support to help staff improve

• Lead by example and take responsibility for mistakes
Answered by AI
Add your answer
Q3. Company always carried out theft staff ?
Add your answer
Q4. No one professional staff in office and overall company ??
Add your answer
Q5. Why directors board unseen to thefts??
Ans. 
Directors may not always be aware of thefts due to lack of oversight, trust in employees, or focus on other priorities.
• Directors may not be directly involved in day-to-day operations where thefts occur

• There may be a lack of proper oversight or monitoring mechanisms in place

• Directors may trust their employees and not suspect them of theft

• Directors may be focused on other strategic priorities and not pay attention to pot
Answered by AI
Add your answer

Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte

30 Aptitude Question
3 Mail Writing Question

Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
Ans. 
Solved a sorting problem by implementing quicksort algorithm.
• Implemented quicksort algorithm to efficiently sort the array.

• Used recursion to divide the array into smaller subarrays and sort them individually.

• Optimized the algorithm by choosing a pivot element strategically to minimize comparisons.
Answered by AI
Add your answer
Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
Add your answer
Q3. Explain 3rd Question based on SQL Query.
Ans. 
The 3rd question based on SQL query likely refers to a specific query or scenario related to SQL.
• Understand the context of the query being asked about

• Analyze the structure and purpose of the SQL query

• Explain the expected output or result of the query
Answered by AI
Add your answer
Q4. Write a code to Reverse Digits.
Ans. 
Code to reverse digits of a number
• Use modulo operator to extract the last digit of the number

• Multiply the result by 10 and add the next digit until all digits are reversed

• Handle negative numbers separately by converting to positive before reversing
Answered by AI
View 1 more amswer
Q5. A problem question for solving a SQL Query.
Add your answer