Rupee112 Interview Questions and Answers

Q1. All concepts regarding the SQL. What is SQL, what is database, joins, regular expressions, group by, order by, ddl,dml
Add your answer

Q1. Over the Linux operating system
Add your answer

Q1. Education background, personal development skills, communication skills, interpersonal skills
Add your answer

Q1. Gold appraisal test
Add your answer
Q2. Business related
Add your answer

Q1. There will be two technical rounds, one with AVP Data Science and second with VP Data Science and final HR discussion.
Add your answer
Q2. First Round Questions: 1. Python - Difference between tuple and dictionary. 2. Python - what is groupby, how to use. 3. SQL - find second largest salary of employee. 4. SQL - Find Manager and Employee na...read more
Add your answer
Q3. Regarding Projects you have mentioned in resume
Add your answer

Q1. Basic python arrays and dictionary questions
Add your answer

Q1. Python fundamental questions
Add your answer

Q1. What are the new features of Java 8
Ans. 
Java 8 introduced several new features including lambda expressions, streams, and default methods.
• Lambda expressions enable functional programming and simplify code.

• Streams provide a new way to process collections and perform operations in parallel.

• Default methods allow interfaces to have method implementations.

• Other features include the Optional class, Date and Time API, and Nashorn JavaScript engine.
Answered by AI
Add your answer
Q2. What is lambda and optional
Ans. 
Lambda is an anonymous function in programming, while Optional is a container object that may or may not contain a non-null value.
• Lambda is used to write concise and functional code by allowing the creation of small, reusable functions.

• Optional is used to handle null values in a more explicit and safe way, reducing the chances of NullPointerExceptions.

• Lambda expressions can be used with functional interfaces, allowing ...read more
Answered by AI
Add your answer
Q3. What is a singleton design pattern
Ans. 
A singleton design pattern restricts the instantiation of a class to a single object.
• Singleton pattern ensures that only one instance of a class is created.

• It provides a global point of access to the instance.

• Commonly used in scenarios where a single instance is required to control actions or resources.

• Example: Database connection manager, logger, configuration manager.
Answered by AI
Add your answer
Q4. What is an observer design pattern
Ans. 
Observer design pattern is a behavioral design pattern that allows objects to subscribe and receive updates from a subject.
• It is used to establish a one-to-many dependency between objects.

• The subject maintains a list of observers and notifies them of any state changes.

• Observers can be added or removed dynamically.

• It promotes loose coupling between objects.

• Example: A weather station broadcasts weather updates to multipl
Answered by AI
Add your answer

Q1. What do you know about NRIFT
Add your answer
Q2. Are you okay with Kolkata location
Add your answer

1. One question regarding the MaxPartitions for a given array, if array is [4, 3, 2, 6 , 5, 10, 9] => upon sorting it appears like [2, 3, 4, 5, 6, 7, 9, 10] ..Max slices are [2,3,4] [5, 6] [9, 10] so slice count is 3

2. Another one Max integer upon removal 5 digit

Q1. Two technical rounds happened 1. One technical round : It was all about the Architecture , Design patterns on Microservices like CircuitBreaker etc and also security concepts, 2. Another technical round...read more
Add your answer

Q1. 1. what is the day-to-day activity of the Product analyst 2. What A/B testing 3. Case study on how many Tata cars are there in India 4. Asked about the difference between rank, dense_rank,row_number,
Ans. 
Describing day-to-day activities, A/B testing, Tata cars in India, and difference between rank functions for Product Business Analyst role.
• Day-to-day activities include gathering and analyzing data, creating reports, identifying trends, and collaborating with cross-functional teams.

• A/B testing involves comparing two versions of a product or feature to determine which performs better.

• As of 2021, Tata Motors has sold ove...read more
Answered by AI
Add your answer
Q2. 5. difference between truncate, delete and drop 6. difference between union and union all 7. He asked to solve SQL questions involving percentages and another one with rank
Ans. 
Answers to SQL-related questions for Product Business Analyst position
• Truncate is a DDL command that removes all rows from a table without logging the individual row deletions, while delete is a DML command that removes specific rows from a table and logs each deletion

• Drop is a DDL command that removes an entire table from the database

• Union combines the results of two or more SELECT statements into a single result set,...read more
Answered by AI
Add your answer

SQL and metrics based questions

Q1. How would you find the top triplet from data set
Ans. 
To find the top triplet from a data set, sort the data in descending order and select the first three values.
• Sort the data in descending order

• Select the first three values

• Consider ties if applicable
Answered by AI
Add your answer
Q2. Questions around the aptitude test
Add your answer

Q1. Top Metrics for Instagram platform
Ans. 
Top metrics for Instagram platform include engagement rate, reach, impressions, follower growth, and click-through rate.
• Engagement rate measures the level of interaction with your content.

• Reach refers to the number of unique accounts that have seen your content.

• Impressions refer to the total number of times your content has been viewed.

• Follower growth measures the rate at which your follower count is increasing.

• Click-t...read more
Answered by AI
Add your answer
Q2. How would you find the batsmen with fastest 5000 runs
Ans. 
To find the batsmen with fastest 5000 runs, we need to analyze the data of all the batsmen who have scored 5000 runs or more.
• Create a database of all batsmen who have scored 5000 runs or more in their career.

• Sort the database based on the time taken by each batsman to reach 5000 runs.

• Identify the batsman who reached 5000 runs in the shortest time.

• Verify the accuracy of the data and the methodology used to calculate the...read more
Answered by AI
Add your answer
Q3. Which is better. 5% discount to get 30% increase in trips or 10% discount to get 50% increase in trips or 15% discount to get 65% increase in trips, considering avg trip value is constant
Ans. 
15% discount to get 65% increase in trips is the best option.
• The percentage increase in trips is directly proportional to the discount offered.

• The increase in trips should be weighed against the decrease in revenue due to the discount.

• In this case, the 15% discount offers the highest increase in trips while still maintaining a reasonable revenue.

• It is important to consider the long-term effects of offering discounts on
Answered by AI
Add your answer

Q1. Sales experience
Ans. 
I have 5 years of sales experience in the technology industry, consistently exceeding targets.
• Managed a team of sales representatives to drive revenue growth

• Developed and implemented sales strategies to increase market share

• Built strong relationships with clients to ensure customer satisfaction

• Utilized CRM software to track sales performance and identify opportunities for improvement
Answered by AI
Add your answer
Q2. People management questions
Add your answer
Q3. Data management
Add your answer

Q1. Data management
Add your answer
Q2. People management
Add your answer