Innoviti Technologies Private Limited Management Trainee Interview Questions and Answers

Asking about the excel and other data tool. Salary offer as per their terms no negotiate.

Q1. Salary offer as per their terms.
Add your answer
Q2. Tell me some thing about your self.
Add your answer
Q3. What is expertise why want to leave
Add your answer

General SQL Question

Q1. General puzzle questions from GFG
Add your answer
Q2. Normal interview level SQL Question
Add your answer

Q1. There were lot of behavioral questions
Add your answer
Q2. Then there were few questions related to how to navigate through the data
Add your answer

Q1. Difference between rank & dense rank
Ans. 
Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.
• Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

• For example, if there are two rows with the same value and rank 1, the n...read more
Answered by AI
Add your answer
Q2. Given two tables Tell how many values would be there for left right inner outer join
Ans. 
The number of values in different types of joins depends on the relationship between the tables.
• In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

• In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...read more
Answered by AI
Add your answer
Q3. Find the newest customer id for every product
Ans. 
Use SQL query to find the newest customer id for every product
• Use GROUP BY clause to group by product

• Use MAX() function to find the newest customer id for each product

• Join the tables if necessary
Answered by AI
Add your answer

Q1. Techncal discussion
Add your answer

Q1. Regarding profile
Add your answer
Q2. Techincal question
Add your answer

Did a nice case study but interview was stupid to understand

Q1. Where do you see yourself in 10 years
Ans. 
In 10 years, I see myself as a successful Assistant Manager, leading a team and contributing to the growth of the company.
• Leading a team of motivated individuals

• Implementing innovative strategies to drive business growth

• Continuously learning and developing new skills

• Building strong relationships with clients and stakeholders

• Contributing to the overall success of the company
Answered by AI
Add your answer
Q2. Why do you wamt to join phonepe
Ans. 
I want to join PhonePe because of its innovative technology, strong market presence, and growth opportunities.
• PhonePe is known for its innovative technology in the digital payment industry.

• I am impressed by PhonePe's strong market presence and its ability to compete with other payment platforms.

• I believe joining PhonePe will provide me with excellent growth opportunities and a chance to contribute to its success.

• PhoneP...read more
Answered by AI
Add your answer

Aptitude reasoning quant and permutations and combinations

A topic was given for a group ..eg cryptocurrency is boon or bane