ivy Senior Software Engineer and Lead Interview Questions and Answers

Q1. Basics of oops, .net framework and .net core
Add your answer
Q2. Sql query for student department id
Ans. 
SQL query to retrieve student department id.
• Use SELECT statement to retrieve data

• Specify the columns to be selected, including the department id column

• Specify the table where the student data is stored

• Use WHERE clause to filter the results based on student information
Answered by AI
Add your answer
Q3. Solid principles and design patterns
Add your answer

Q1. Asked to code palindrome
Add your answer
Q2. Code duplicate string from main string and get index of sub string
Ans. 
Code to find index of sub string in main string and duplicate the sub string
• Use a loop to iterate through the main string and check for the sub string

• If sub string is found, duplicate it and store the index

• Return the index of the duplicated sub string
Answered by AI
Add your answer

Q1. Manager asked me to code the count index of substring and sum of substring
Add your answer
Q2. Questions as HR informed, it was worst and all interviews were scheduled at night time.he was more technical than the second round team lead instead of asking manager round
Add your answer

Normal online code / frontend test

Q1. How would you build book my show
Ans. 
Designing and building a platform similar to BookMyShow involves creating a user-friendly interface for booking tickets for various events.
• Develop a user-friendly website and mobile app for users to browse and book tickets for movies, concerts, plays, etc.

• Implement a secure payment gateway for users to make online transactions.

• Integrate a database to store information about events, venues, tickets, and user bookings.

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

Q1. Solid principals, awareness of patterns
Add your answer

Q1. How would you build tinyurl like service, systems designs
Ans. 
To build a tinyurl-like service, design a system with a URL shortening algorithm, a database to store mappings, and a redirect service.
• Use a hashing algorithm to generate short URLs from long URLs (e.g. MD5, SHA-256).

• Store the mappings of short URLs to long URLs in a database (e.g. MySQL, Redis).

• Implement a redirect service that takes a short URL, looks up the corresponding long URL in the database, and redirects the u...read more
Answered by AI
Add your answer

Q1. Non-technical questions
Add your answer

Q1. Java springboot basic to intermediate question
Add your answer
Q2. Java stream questions
Add your answer

Q1. Easy level DSA questions
Add your answer
Q2. Project based questions
Add your answer

Q1. Easy array problem
Add your answer
Q2. Easy tree traversal problem
Ans. 
Implement tree traversal algorithm to visit each node in a tree structure
• Use depth-first search (DFS) or breadth-first search (BFS) to traverse the tree

• DFS can be implemented using recursion or a stack data structure

• BFS can be implemented using a queue data structure

• Example: Inorder traversal of a binary tree - left, root, right
Answered by AI
Add your answer

Q1. Trapping rain water
Add your answer
Q2. Path of longest sum
Ans. 
Find the path in a matrix with the longest sum of elements
• Start from the top-left corner of the matrix

• Move only right or down in the matrix

• Keep track of the sum of elements in each path

• Return the path with the longest sum
Answered by AI
Add your answer

1st round is aptitude and pesudocode

Q1. Mostly python questions
Add your answer
Q2. List questions and basic to mediumprogram
Add your answer

Q1. Discuss the project you are most proud of
Ans. 
Developed a mobile app for tracking personal fitness goals
• Used React Native to create a cross-platform app

• Implemented features such as goal setting, progress tracking, and workout logging

• Integrated with wearable devices like Fitbit for automatic data syncing
Answered by AI
Add your answer
Q2. What are ways to speed up SQL queries? List them in increasing order of complexity?
Ans. 
Ways to speed up SQL queries in increasing order of complexity
• Use indexes on columns frequently used in WHERE clauses

• Optimize queries by avoiding unnecessary joins and subqueries

• Use stored procedures to reduce network traffic and improve performance

• Consider denormalizing tables for frequently accessed data

• Use query optimization techniques like query caching and query hints
Answered by AI
Add your answer
Q3. Is Redis single-threaded or multi-threaded?
Ans. 
Redis is single-threaded.
• Redis is single-threaded, meaning it can only execute one command at a time.

• This design choice allows Redis to be extremely fast and efficient for certain use cases.

• However, it also means that Redis may not be the best choice for highly concurrent workloads.
Answered by AI
Add your answer
Q4. What sort of data types can be used as keys in Python?
Ans. 
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
• Strings are commonly used as keys in Python dictionaries.

• Integers and floats can also be used as keys.

• Tuples can be used as keys if they only contain immutable elements.

• Custom objects can be used as keys if they are hashable.

• Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Answered by AI
Add your answer
Q5. What types of indexing exist in SQL?
Ans. 
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
• Clustered index physically reorders the table based on the index key

• Non-clustered index creates a separate structure for the index

• Unique index ensures that all values in the index column are unique

• Composite index uses multiple columns for indexing
Answered by AI
Add your answer

Q1. Basic java fundamentals
Add your answer
Q2. Spring boot,sql
Add your answer

Q1. Some technical questions from manager
Add your answer
Q2. Some challenges or scenario based questions
Add your answer

Q1. Salary discussion mostly
Add your answer
Q2. Benifts that they offer with TR
Add your answer

Q1. What is the inheritance?
Ans. 
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can override or extend the functionality of the base class
Answered by AI
Add your answer
Q2. What are the types of joins in mysql
Ans. 
Types of joins in MySQL include inner join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer

Q1. How to handle multiple api's
Ans. 
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
• Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.

• Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.

• Consider implementing a caching layer to improve performance and reduce the number of requests to external
Answered by AI
Add your answer
Q2. What does strstr function do?
Ans. 
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
• Used in C programming language

• Syntax: char *strstr(const char *haystack, const char *needle)

• Example: char *str = strstr("hello world", "world")
Answered by AI
Add your answer