Scaler Academy Production Analyst Interview Questions and Answers

5 SQL Questions (Leetcode Level)

Uber is experiencing a decline in profits in the current quarter. How can this issue be addressed?

Q1. Simple SQL based questions on Joins , Self Joins, Window Functions, Group Concat etc.
Add your answer
Q2. Difference between Rank, Dense Rank and Row number.
Ans. 
Rank assigns a unique rank to each row, Dense Rank assigns a unique rank to each distinct row, and Row number assigns a unique sequential integer to each row.
• Rank function does not skip any ranks if there are ties.

• Dense Rank function skips ranks if there are ties.

• Row number function assigns a unique sequential integer to each row.

• Example: Rank - 1, 2, 2, 4; Dense Rank - 1, 2, 2, 3; Row number - 1, 2, 3, 4.
Answered by AI
Add your answer

Q1. SQL Questions on Windows Functions , Self Join Etc.
Add your answer
Q2. Case Study: Suppose there is a resume builder in Scaler. What metrics should we track on Resume builder.
Ans. 
Metrics to track on a resume builder in Scaler
• Number of resumes created

• Average time spent on creating a resume

• Percentage of resumes completed

• Number of templates used

• Feedback ratings from users
Answered by AI
Add your answer

Q1. Basic SQL Questions
Add your answer
Q2. What could be the root causes of the decline in transactions on an e-commerce platform?
Ans. 
Possible root causes of decline in e-commerce transactions
• Poor user experience leading to high bounce rates

• Lack of marketing efforts resulting in decreased traffic

• Technical issues causing website downtime or slow loading times

• Increased competition from other e-commerce platforms

• Changes in consumer behavior or preferences

• Security concerns leading to lack of trust in the platform
Answered by AI
Add your answer

General Case Study on real life topic

Q1. SQL - Easy to Medium
Add your answer

Q1. SQL - Hard + Logical Thinking + Case Study
Add your answer

Q1. SQL + Resume + HR
Add your answer

SQL questions, easy, medium, hard