Aceolution India Senior Software Engineer Interview Questions and Answers

Q1. Java 8, Stream API
Add your answer
Q2. Dependency Injection in Spring
Ans. 
Dependency Injection in Spring is a design pattern where objects are passed their dependencies rather than creating them internally.
• In Spring, dependencies are injected into a class through constructor injection, setter injection, or field injection.

• This helps in achieving loose coupling between classes and makes the code more testable and maintainable.

• Example: @Autowired annotation in Spring is used for dependency inj
Answered by AI
Add your answer

Q1. My Experience in IT
Ans. 
I have over 8 years of experience in IT, specializing in software development and project management.
• Developed web applications using Java, Spring, and AngularJS

• Led a team of developers in implementing a new CRM system for a large client

• Managed multiple projects simultaneously, ensuring on-time delivery and client satisfaction
Answered by AI
Add your answer

Q1. Java questions and basics of testing
Add your answer

Q1. What are decorators in Python What is the use of __name == __main__ Django related questions
Ans. 
Decorators in Python are functions that modify the behavior of other functions or methods. __name__ == __main__ is used to check if a Python script is being run directly or imported as a module.
• Decorators are used to add functionality to existing functions without modifying their code.

• They are defined using the @decorator syntax before the function definition.

• Example: @staticmethod decorator in Python is used to define...read more
Answered by AI
Add your answer

Q1. Joins in SQL, Window functions Coding question Django ORM questions
Add your answer

Q1. Salary related questions
Add your answer

Q1. Basic java and rest full API, multithreading and stream
Add your answer

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Aptitude + Coding Test

Q1. What are Services in Angular? How to Provide Services in Angular? Scenario Based Questions
Add your answer

Q1. Mainly Scenario based questions. How to get element in Typescript in Angular. How to pass data between two web components? How Web workers work?
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. What are your salary expectations?
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This round had 1 very simple coding problem followed by some questions from Java and Spring.

Q1. 
Excel Column Number Conversion
Given a column title as it appears in an Excel sheet, your task is to return its corresponding column number.
Example:
Input:
S = "AB"
Output:
28
Explanation:
The seq...read more
Ans. 
Approach :

The process is very much similar to binary to decimal conversion. In this case, the base of the given system is to be taken as 26. Also, in this system 1 is represented as ‘A’, 2 is represented as ‘B’ and so on till 26 is represented as ‘Z’

For example-
CDA can be converted as 3*26*26 + 4*26 + 1
= 26(3*26 + 4) + 1
= 26(0*26 + 3*26 + 4) + 1

AB can be converted as 1*26 + 2

TC : O(N), where N = length of the input str
Answered Anonymously
Add your answer
Q2. What is a lambda expression in Java, and how does it relate to a functional interface?
Ans. 
Lambda expression is a type of function without a name. It may or may not have results and parameters. It is known as an anonymous function as it does not have type information by itself. It is executed on-demand. It is beneficial in iterating, filtering, and extracting data from a collection.


As lambda expressions are similar to anonymous functions, they can only be applied to the single abstract method of Functional I...read more
Answered Anonymously
Add your answer
Q3. What are Java 8 streams?
Ans. 
A stream is an abstraction to express data processing queries in a declarative way.

A Stream, which represents a sequence of data objects & series of operations on that data is a data pipeline that is not related to Java I/O Streams does not hold any data permanently.
The key interface is "java.util.stream.Stream" . It accepts Functional Interfaces so that lambdas can be passed. Streams support a fluent interface or
Answered Anonymously
Add your answer
Q4. What do you understand by autowiring in Spring Boot, and can you name the different modes of autowiring?
Ans. 
The Spring container is able to autowire relationships between the collaborating beans. That is, it is possible to let Spring resolve collaborators for your bean automatically by inspecting the contents of the BeanFactory.

Different modes of bean auto-wiring are : 

1) no : This is default setting which means no autowiring. Explicit bean reference should be used for wiring.

2) byName : It injects the object dependency...read more
Answered Anonymously
Add your answer
Q5. What does the @SpringBootApplication annotation do internally?
Ans. 
The @SpringBootApplication annotation is equivalent to using @Configuration, @EnableAutoConfiguration, and @ComponentScan with their default attributes. Spring Boot enables the developer to use a single annotation instead of using multiple. But, as we know, Spring provided loosely coupled features that we can use for each annotation as per our project needs.
Answered Anonymously
Add your answer
Q6. What are the basic annotations that Spring Boot offers?
Ans. 
The primary annotations that Spring Boot offers reside in its "org.springframework.boot.autoconfigure" and its sub-packages. Here are a couple of basic ones :

@EnableAutoConfiguration – to make Spring Boot look for auto-configuration beans on its classpath and automatically apply them.

@SpringBootApplication – used to denote the main class of a Boot Application. This annotation combines @Configuration, @EnableAutoConfigu...read more
Answered Anonymously
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This round focused more on Multithreading concepts from Java and also some core concepts from OOPS.

Q1. What is a thread in Java?
Ans. 
Threads are basically the lightweight and smallest unit of processing that can be managed independently by a scheduler. Threads are referred to as parts of a process that simply let a program execute efficiently with other parts or threads of the process at the same time. Using threads, one can perform complicated tasks in the easiest way. It is considered the simplest way to take advantage of multiple CPUs available i...read more
Answered Anonymously
Add your answer
Q2. What are the start() and run() methods of the Thread class in Java?
Ans. 
start() : In simple words, the start() method is used to start or begin the execution of a newly created thread. When the start() method is called, a new thread is created and this newly created thread executes the task that is kept in the run() method. One can call the start() method only once.


run() : In simple words, the run() method is used to start or begin the execution of the same thread. When the run() method is...read more
Answered Anonymously
Add your answer
Q3. What is the difference between the Thread class and the Runnable interface when creating a thread in Java?
Ans. 
The Thread can be created by using two ways : 

1) By extending the Thread class
2) By implementing the Runnable interface

However, the primary differences between both the ways are given below :

1) By extending the Thread class, we cannot extend any other class, as Java does not allow multiple inheritances while implementing the Runnable interface; we can also extend other base class(if required).

2) By extending the T...read more
Answered Anonymously
Add your answer
Q4. What is the difference between an abstract class and an interface in OOP?
Ans. 
The differences between Abstract Class and Interface are as follows :

Abstract Class :

1) Abstract classes have a default constructor and it is called whenever the concrete subclass is instantiated.

2) It contains Abstract methods as well as Non-Abstract methods.

3) The class which extends the Abstract class shouldn’t require the implementation of all the methods, only Abstract methods need to be implemented in the concret...read more
Answered Anonymously
Add your answer
Q5. What is the garbage collector in Java?
Ans. 
1) Garbage Collection in Java is a process by which the programs perform memory management automatically.

2) The Garbage Collector(GC) finds the unused objects and deletes them to reclaim the memory. 

3) In Java, dynamic memory allocation of objects is achieved using the new operator that uses some memory and the memory remains allocated until there are references for the use of the object.

4) When there are no refer...read more
Answered Anonymously
Add your answer
Q6. Can you explain the SOLID principles in Object Oriented Design?
Ans. 
The SOLID principle is an acronym of the five principles which is given below :

1) Single Responsibility Principle (SRP)
2) Open/Closed Principle
3) Liskov’s Substitution Principle (LSP)
4) Interface Segregation Principle (ISP)
5) Dependency Inversion Principle (DIP)


Uses of SOLID design principles :

1) The SOLID principle helps in reducing tight coupling.

2) Tight coupling means a group of classes are highly dependent on one ...read more
Answered Anonymously
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

This was a System Design Round where I was asked a LLD question to design a URL Shortener followed by a very standard question of LRU Cache. Overall this round went well and the interviewer was also quite satisfied by my answers.

Q1. Design a URL shortener.
Ans. 
Tip 1 : Firstly, remember that the system design round is extremely open-ended and there’s no such thing as a standard answer. Even for the same question, you’ll have a totally different discussion with different interviewers.


Tip 2 : Before you jump into the solution always clarify all the assumptions you’re making at the beginning of the interview. Ask questions to identify the scope of the system. This will clear the...read more
Answered Anonymously
Add your answer
Q2. 
LRU Cache Design Problem Statement
Design and implement a data structure for a Least Recently Used (LRU) cache that supports the following operations:
• get(key) - Retrieve the value associated with the...read more
Ans. 
Structure of an LRU Cache :

1) In practice, LRU cache is a kind of Queue — if an element is reaccessed, it goes to the end of the eviction order.

2) This queue will have a specific capacity as the cache has a limited size. Whenever a new element is brought in, it is added at the head of the queue. When eviction happens, it happens from the tail of the queue.

3) Hitting data in the cache must be done in constant time, whic...read more
Answered Anonymously
Add your answer