NOON.COM Interview Questions, Process, and Tips

Q1. What is difference between dense_rank and rank function
Ans. 
dense_rank assigns consecutive ranks to rows with the same value, while rank leaves gaps in ranking.
• dense_rank assigns the same rank to rows with the same value, while rank leaves gaps in ranking

• dense_rank always produces consecutive ranks, while rank may skip ranks

• Example: dense_rank of 1, 2, 2, 3 would be 1, 2, 2, 3; rank would be 1, 2, 2, 3
Answered by AI
Add your answer

Q1. Hgg bgvb hhjj ggg
Add your answer
Q2. Ggghh hgggh hgg
Add your answer

Q1. Dggg gfffg hgffhh
Add your answer
Q2. Xfvvbb gffgh hghjj
Add your answer

Q1. SQL based questions were asked on Group by, Window functions
Add your answer

The interview was good mostly on SQL, and Python

Duration was 45 min, Questions about business decisions, marketing campaigns

Q1. How many times you working maintenance?
Add your answer
Q2. How many times you work in Saudi Arabia?
Add your answer

Q1. Resume questions
Add your answer
Q2. Guesstimates- how many ice creams are sold in a year
Ans. 
It depends on various factors such as location, season, and popularity of ice cream shops.
• Consider factors like population, weather, and popularity of ice cream shops

• Look at industry reports and sales data for estimates

• Take into account different types of ice creams sold and their average prices
Answered by AI
Add your answer

Q1. What are the KRAs?
Add your answer
Q2. Past experience
Add your answer

Q1. Regarding the salary structure
Add your answer
Q2. Regarding the benefits and all.
Add your answer