Gurit India Junior Engineer Production Interview Questions and Answers

The test consisted of 4 DSA questions (1 easy, 2 medium, 1 hard) that had to be completed in 2 hours. They were standard questions from Leetcode and the test was similar to Leetcode's weekly coding contest.

Q1. Simple DSA questions like time complexity to insert in a Hash Map, the difference between singly and doubly linked lists, etc.
Add your answer
Q2. Subarray with sum 0
Ans. 
Find subarray in an array with sum 0
• Iterate through the array and keep track of the running sum

• Store the running sum in a hashmap and check if the same sum has been seen before

• If the sum is 0 or if the running sum is already in the hashmap, a subarray with sum 0 exists
Answered by AI
Add your answer
Q3. Linked List Cycle
Add your answer
Q4. Rainwater trapping proble
Add your answer

Q1. Design a database for a blogging website
Ans. 
Database design for a blogging website
• Create tables for users, blog posts, comments, and categories

• Use primary and foreign keys to establish relationships between tables

• Include fields such as title, content, author, date, and tags

• Implement indexing for faster retrieval of data

• Consider implementing a caching mechanism for improved performance
Answered by AI
Add your answer
Q2. What can be done to balance the load of requests coming to a single server
Ans. 
To balance the load of requests on a single server, one can implement load balancing techniques.
• Implementing a load balancer to distribute incoming requests evenly across multiple servers

• Using round-robin algorithm to route requests to different servers in a sequential manner

• Utilizing server health checks to monitor the performance of each server and adjust the load distribution accordingly
Answered by AI
Add your answer

Q1. Design database for my college
Ans. 
Design a database for a college
• Create tables for students, courses, professors, departments, and grades

• Establish relationships between tables using foreign keys

• Include attributes such as student ID, course ID, professor ID, department ID, and grade

• Consider normalization to reduce redundancy and improve data integrity
Answered by AI
Add your answer
Q2. Pseudo code to validate password
Ans. 
Pseudo code to validate password
• Create a function that takes a password as input

• Check if the password meets the required criteria (e.g. length, special characters)

• Return true if the password is valid, false otherwise
Answered by AI
Add your answer
Q3. Strengths and weakness that can affect my profesional life
Add your answer
Q4. Challenges faced during the projects in my resum and how did I overcome them
Add your answer

5 questions of medium difficulty level covering topics like queue, dynamic programming, binary search, greedy.

Q1. System design. Using a NoSQL document schema. Design a document store schema to store bike model data.
Add your answer

Q1. Willing to relocate to Navi Mumbai. Strengths and weekness General process related to my compatibility with the company.
Add your answer

Questions from trees and linkedin

Q1. Question on dsa and on oops
Add your answer
Q2. Reverse linked list with multiple approach
Ans. 
Reverse a linked list using multiple approaches.
• Iterative approach: Use three pointers to reverse the links between nodes.

• Recursive approach: Recursively reverse the rest of the list and adjust the links.

• Stack approach: Push all the nodes onto a stack and then pop them to create the reversed list.
Answered by AI
Add your answer

1 hr, there were some DSA problems

1 hr, there were some DSA problems

Q1. Any hard situation u faced ?
Add your answer
Q2. How you tackled hard situation
Add your answer

Q1. Be confident there is no barrier of language in this organisation if you are comfortable in hindi use it
Add your answer

General SQL and Python questions for Data analysis and Visualization tools

Q1. What do you understand y Churn Rate ?
Ans. 
Churn Rate is the percentage of customers who stop using a product or service over a certain period of time.
• Churn Rate is calculated by dividing the number of customers who stopped using the product by the total number of customers at the beginning of the period.

• It is used to measure customer retention and satisfaction.

• A high churn rate indicates that a company may be losing customers at a high rate, while a low churn ...read more
Answered by AI
Add your answer
Q2. What can be done to increase retention rate ?
Ans. 
To increase retention rate, companies can focus on improving employee engagement, providing opportunities for growth and development, offering competitive compensation and benefits, and creating a positive work culture.
• Improve employee engagement through regular feedback sessions and recognition programs

• Provide opportunities for growth and development through training programs and career advancement opportunities

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

Sql with window functions

Data analysis assignment based on python and SQL including visualisations

Q1. Tell me about your self
Add your answer
Q2. Why chose sales as carreer?
Add your answer
Q3. Tell about Toothsi and skinsi
Add your answer