i
AVASOFT
Filter interviews by
I applied via campus placement at Coimbatore Institute of Technology, Coimbatore and was interviewed in Jul 2022. There were 3 interview rounds.
Just general topic discussion on the topic given
I am proficient in SQL and prefer Java for coding. I have worked on projects involving database design and optimization.
Proficient in SQL for database management
Prefer Java for coding
Worked on projects involving database design and optimization
Top trending discussions
I applied via Campus Placement
Question related to operating system and computer network
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
I applied via campus placement at Dayananda Sagar College of Engineering, Bangalore and was interviewed in Oct 2024. There were 4 interview rounds.
3 coding dsa question
Difficulty is On your luck
My friends got easy level
I got medium level
Some got hard questions as well
Ssh round , quant and logical
Tip: bring your calculator
I applied via Walk-in and was interviewed in Nov 2024. There were 5 interview rounds.
Normal online code / frontend test
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...
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...
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
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.
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.
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.
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...
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.
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); });
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
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...
posted on 8 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
OOPS is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOPS focuses on the concept of classes and objects
Encapsulation: bundling data and methods that operate on the data within a single unit
Inheritance: allows a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for diffe...
Comparable is an interface used for natural ordering, Comparator is an interface used for custom ordering. Abstract class can have method implementations, Interface cannot.
Comparable interface is used to define the natural ordering of objects. Example: String class implements Comparable interface for natural ordering based on alphabetical order.
Comparator interface is used to define custom ordering of objects. Example:...
Count occurrences of each character in a given string
Create an array to store the count of each character
Iterate through the string and increment the count of each character in the array
Return the array with counts for each character
Remove duplicates from an array of strings
Iterate through the array and store each element in a set to keep track of unique values
Create a new array with the unique values from the set
posted on 11 Aug 2024
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
SOLID principles help in creating maintainable, scalable, and flexible software.
SOLID principles help in creating software that is easier to maintain and extend.
Single Responsibility Principle (SRP) ensures that a class has only one reason to change, leading to more modular and cohesive code.
Open/Closed Principle (OCP) states that a class should be open for extension but closed for modification, allowing for easy chang...
Singleton design pattern ensures a class has only one instance and provides a global point of access to it.
Create a private static instance of the class within the class itself.
Provide a public static method to access the instance.
Ensure the constructor of the class is private to prevent instantiation from outside the class.
Example: Singleton pattern is commonly used in database connections to ensure only one connectio
Dependency injection is a design pattern where components are provided with their dependencies rather than creating them internally.
Dependency injection helps in achieving loose coupling between components.
It makes components easier to test by allowing for easier mocking of dependencies.
Use cases include injecting database connections, logging services, and external API clients into components.
Debugging a published dll involves using tools like Visual Studio debugger and logging mechanisms.
Use Visual Studio debugger to attach to the process using the published dll
Set breakpoints in the code to pause execution and inspect variables
Use logging mechanisms to track the flow of execution and identify issues
Check for any exceptions or errors thrown by the dll
Data seeding in Entity Framework involves pre-populating database tables with initial data. Mapping tables with entities involves defining relationships between database tables and entity classes.
Data seeding in Entity Framework can be done using the 'Seed' method in the 'Configuration' class of the DbContext.
To map tables with entities, use data annotations or Fluent API to define relationships between entities and da...
posted on 9 Oct 2024
Manual testing is important for exploratory testing, usability testing, and ad-hoc testing.
Manual testing allows for exploratory testing where testers can explore the application and identify unexpected issues.
Usability testing, which involves real users interacting with the software, is best done manually to capture user experience.
Ad-hoc testing, where testers randomly test the application without predefined test cas...
Testing a web application for an online shopping platform
Testing the functionality of adding items to the cart and checking out
Testing the payment gateway integration for secure transactions
Testing the search functionality to ensure accurate results are displayed
Testing the responsiveness of the website on different devices and browsers
posted on 5 Oct 2024
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
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.
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
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")
Software Engineer
215
salaries
| ₹1.8 L/yr - ₹9 L/yr |
Data Engineer
88
salaries
| ₹3.5 L/yr - ₹8 L/yr |
Software Developer
60
salaries
| ₹2.6 L/yr - ₹10.6 L/yr |
Servicenow Developer
51
salaries
| ₹4 L/yr - ₹7 L/yr |
QA Engineer
47
salaries
| ₹3 L/yr - ₹8 L/yr |
TCS
Infosys
Wipro
HCLTech