Collegedunia Associate Product Manager Interview Questions and Answers

Sql hackereank test, moderate level including window function

Q1. Rca , strategy , product improvement
Add your answer

Q1. SQL Query Advanced
Add your answer
Q2. SQL Query Advanced
Add your answer

Q1. SQL Query Advanced
Add your answer
Q2. SQL Query Advanced
Add your answer

Same set of questions get repeated.

Q1. Asked 2-3 sql questions
Add your answer
Q2. Rank , dense rank and row number differnece
Ans. 
Rank, dense rank, and row number are different ways to assign a ranking to rows in a dataset.
• Rank assigns unique ranks to rows, leaving gaps if there are ties.

• Dense rank assigns unique ranks to rows without any gaps, even if there are ties.

• Row number simply assigns a unique sequential number to each row in the dataset.
Answered by AI
Add your answer

Analytics round was the first round which was easy

Q1. No. of footballs in the air
Add your answer
Q2. Design fridge for the blind
Ans. 
Designing a fridge for the blind requires tactile and auditory cues for easy navigation and organization.
• Include braille labels on shelves and drawers for easy identification of items.

• Utilize voice recognition technology for hands-free operation.

• Implement textured buttons and knobs for temperature control and settings.

• Incorporate a talking feature that announces the contents of the fridge when opened.

• Ensure contrasting...read more
Answered by AI
Add your answer

There was question on RCA