Eckovation Interview Questions and Answers

Hackerrank Test including 4 coding and few mcq questions

Q1. Frontend and Javascript related question.
Add your answer
Q2. Coding Question in Javascript
Add your answer

Q1. Asked about myself and my interest
Add your answer
Q2. Asked about project that I did in college
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

3 coding questions based on Tree and kind of similar to each other. Based on dijkstra algo.

One question that was a bit lengthy, with name 'Tree of Space' you can get it from internet.

I have asked to improved my code from previous round and explain it and then they ask improve your code if if the inputs are in the form of multiple thread.

Q1. I have to some tree questions like height and one question from leetcode.
Add your answer

Q1. Some basic questions what you want what are your goals
Add your answer

Q1. Tell me about yourself? basic testing questions like functional testing?
Add your answer
Q2. Verify the login functionality
Ans. 
To verify login functionality, we need to test the login process with valid and invalid credentials.
• Test login with valid credentials and ensure user is logged in successfully

• Test login with invalid credentials and ensure appropriate error message is displayed

• Test login with blank username or password and ensure appropriate error message is displayed

• Test login with special characters in username or password and ensure
Answered by AI
Add your answer

Q1. It was one-on-one round with the CTO. They judged me on my technical knowledge as well as understanding of tech-era.
Add your answer
Q2. I was asked question related to the languages and tech-stacks I mentioned in my resume and also question related to OOPs concepts.
Add your answer