Uber Business Executive Interview Questions and Answers

Yeah its 1st round of aptitude

Coding test is very essential part

Q1. H. R asked few questions ?
Add your answer
Q2. What is your target in the month
Add your answer

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer

Q1. What you have technical improvement in codes?
Ans. 
I have implemented various technical improvements in codes to enhance performance and functionality.
• Implemented caching mechanisms to reduce load times

• Optimized database queries for faster retrieval of data

• Introduced error handling techniques to improve code reliability

• Utilized design patterns to make the codebase more maintainable

• Refactored legacy code to adhere to best practices
Answered by AI
Add your answer
Q2. What is your excitment about fresh job?
Add your answer

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
• The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

• Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
Answered by AI
Add your answer

Q1. Interview with stakeholders
Add your answer

Q1. They will ask about your profile and past experience.
Add your answer

Q1. A peer level colleague will ask some basic knowledge check questions
Add your answer

This is literally a live coding test. For analytics expect SQL, python, R.

Q1. Interviewed by a manager of another team
Add your answer

Q1. Interviewed by dotted line reporting manager
Add your answer

Q1. Cross functional interview
Add your answer

Q1. Core Values Interview
Add your answer

Q1. Only salary discussion
Add your answer
Q2. HR ask me that what is your total experience
Add your answer
Q3. Say something about your self
Add your answer
Q4. What is your preferred location to work
Add your answer