Accelya Solutions India Limited Software Development Engineer 1 Interview Questions and Answers

Finding all unique pairs of BST

Given stream of numbers , return yes/no - for a series of numbers if each number is present or not

Q1. Fully Optimized SQL Query for some scenario
Add your answer
Q2. Joins vs Subqueries
Ans. 
Joins are used to combine rows from two or more tables based on a related column, while subqueries are nested queries used to return data for the main query.
• Joins are used to retrieve data from multiple tables based on a related column.

• Subqueries are used to return data for the main query by nesting a query within another query.

• Joins are typically more efficient than subqueries for retrieving data from multiple tables.

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

Question related to operating system and computer network

Q1. Traverse all child nodes in tree
Ans. 
Traverse all child nodes in a tree data structure
• Use depth-first or breadth-first traversal algorithms

• Recursively visit each child node starting from the root node

• Consider using a stack or queue data structure for traversal

• Example: Traverse all nodes in a binary tree
Answered by AI
Add your answer

Q1. Question related to cloud and oops
Add your answer

Q1. Question related to my background and how web site work
Add your answer

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

Mainly 4 Questions
1-2 MCQ
3: Create a class deriving from IReptile and return an object of HatchEgg which has Hatch Method. Hatch Method should return same IReptile object.
4) Sorting IDs in dictionary

Q1. The Interviewer was Very Rude and he doesn't care about the Requirements of Hiring a candidate. he was constantly asking about Other Companies Architectures and The things you did in them. instead of havin...read more
Add your answer
Q2. SOLID, Interfaces , Boxing/Unboxing
Add your answer

Q1. Find longest palindromic substring in a given string.
Ans. 
Use dynamic programming to find the longest palindromic substring in a given string.
• Iterate through the string and expand around each character to find palindromes.

• Store the length of the longest palindrome found so far.

• Return the substring based on the start and end indices of the longest palindrome.
Answered by AI
Add your answer
Q2. How to serialize and deserialise a tree
Ans. 
To serialize and deserialize a tree, use a recursive approach to traverse the tree and store the data in a suitable format.
• Use pre-order traversal to serialize the tree by storing the node values in a list or string.

• For deserialization, reconstruct the tree by recursively building nodes from the serialized data.

• Consider using JSON or XML format for serialization to easily store and retrieve tree structure.
Answered by AI
Add your answer
Q3. Find if a given regex (containing ., * and lower case english chars) matches a given string.
Ans. 
Use regex library to match given regex with string.
• Use a regex library like re in Python to match the given regex with the string.

• Check if the regex matches the string using the library functions.

• Handle cases where the regex contains special characters like . and * appropriately.
Answered by AI
Add your answer
Q4. Explain about throttling and implement throttle function.
Ans. 
Throttling is a technique used to control the rate of requests sent to a server.
• Throttling helps prevent server overload by limiting the number of requests processed at a time.

• Implementing a throttle function involves setting a maximum request rate and delaying excess requests.

• Example: Implementing a throttle function in a web application to limit the number of API calls made to a third-party service.

• Example: Throttlin...read more
Answered by AI
Add your answer

Q1. Find squares of elements in a sorted array and return the sorted response.
Ans. 
Sort the squares of elements in a sorted array and return the sorted response.
• Iterate through the array and square each element.

• Store the squared values in a new array.

• Sort the new array and return it.
Answered by AI
Add your answer
Q2. Write a short promise example and implement your own promise
Ans. 
A promise is a commitment to do something in the future, typically used for asynchronous operations in JavaScript.
• Promises are used to handle asynchronous operations in JavaScript.

• They represent a value that may be available now, in the future, or never.

• Promises have three states: pending, fulfilled, or rejected.

• Example: new Promise((resolve, reject) => { setTimeout(() => resolve('Done!'), 1000); });
Answered by AI
Add your answer
Q3. Explain event loop, what are different types of queues in event loop
Ans. 
Event loop is a mechanism that allows for asynchronous execution of code by managing the order of events in a single thread.
• Event loop continuously checks the call stack for any functions that need to be executed, and processes them in a non-blocking manner.

• Different types of queues in event loop include microtask queue (Promise callbacks), macrotask queue (setTimeout, setInterval callbacks), and animation frame queue
Answered by AI
Add your answer
Q4. What is virtual DOM and why its faster
Ans. 
Virtual DOM is a lightweight copy of the actual DOM, used to improve performance by minimizing direct manipulation of the real DOM.
• Virtual DOM is a concept used in frameworks like React to optimize rendering performance.

• Changes are first made to the virtual DOM, which is then compared to the real DOM to identify the minimal updates needed.

• This approach reduces the number of actual DOM manipulations, resulting in faster...read more
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. 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