Prodigy Technovations Interview Questions and Answers

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. Online DSA round where question to be solved in front of interviewer and we need to pass all the cases. Question was based on frequency sort. This was to be done on HackerRank platform for which interviewe...read more
Add your answer
Q2. Basic question based on internal working of hashmap, inter threads communication, Concurrent HashMap working and how it handles thread safety.
Add your answer

Q1. Basic introduction and question asked based on my previous projects that i worked on. Few follow ups on the same.
Add your answer
Q2. Was asked to design a ratelimiter service
Add your answer
Q3. Question on synchronized keyword and it works internally. Threads and its inter communication.
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Total 25 questions in 30 min

GD is on social effect

Q1. 1 min talk on a specific given topic
Add your answer

Q1. Some technical questions as am from Entc bg...try to clear your own technical clear ... nothing extra
Add your answer

Q1. All about HR QUESTIONS
Add your answer

Q1. What is the Total Experience as the All Lines
Add your answer

Group Discussion as the ABM ,GM , Founder and Co Fouder

Q1. What is the Experience total years
Add your answer
Q2. Where are you Working Location
Add your answer

Q1. Which is the Reporting Manager
Ans. 
The Reporting Manager is the individual to whom the Business Development Manager will report to.
• The Reporting Manager is typically a higher-level manager within the organization

• They are responsible for overseeing the work and performance of the Business Development Manager

• The Reporting Manager provides guidance, feedback, and support to the Business Development Manager

• Examples of Reporting Managers could include the Di...read more
Answered by AI
Add your answer
Q2. What is the Experience in All sector
Add your answer

Written test with 16 aptitude and 10 pseudo code

6 questions with moderate level

Q1. Self introduction
Add your answer
Q2. Resume based questions
Add your answer