Avantha Business Solutions Interview Questions and Answers

There are two main sections: foundation and advanced. The foundation section consists of three subsections: quantitative, reasoning, and verbal. If you pass the foundation section but do not clear the advanced section, you will be considered for either the ninja role or the digital role during the interview process. The advanced section includes advanced aptitude questions and two coding questions.

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. 3 to 4 questions based on database
Add your answer
Q3. 2 easy coding questions
Add your answer
Q4. Questions based on technology that I knew
Add your answer
Q5. Situation based questions
Add your answer

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

Q1. Question related manufacturing domain
Add your answer
Q2. What are your job responsibilities at your current company?
Add your answer
Q3. Question related Erp tool
Add your answer

Q1. What is the shop floor process?
Add your answer
Q2. What are your job responsibilities in your current company?
Add your answer

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. What is your experience with salary discussions and negotiations?
Add your answer

Q1. Can you explain the Maven build lifecycle?
Ans. 
Maven build lifecycle consists of phases like compile, test, package, install, deploy.
• Maven build lifecycle consists of three main phases: clean, default, and site.

• Each phase consists of a series of goals that are executed in a specific order.

• Some common goals in Maven build lifecycle include compile, test, package, install, and deploy.

• The clean phase removes all files generated by the previous build.

• The default phase ...read more
Answered by AI
Add your answer
Q2. What is the code to reverse a sentence?
Ans. 
Code to reverse a sentence using array of strings.
• Split the sentence into an array of words

• Reverse the array

• Join the array back into a sentence
Answered by AI
Add your answer
Q3. What is static block in java?
Ans. 
Static block in Java is a block of code that is executed only once when the class is loaded.
• Static block is used to initialize static variables of a class.

• It is executed before the main method.

• Syntax: static { // code to be executed }

• Example: static { System.out.println("Static block executed"); }
Answered by AI
Add your answer
Q4. What is exclude and include in TestNG?
Ans. 
Exclude and include in TestNG are used to specify which test methods to run or skip during test execution.
• Exclude attribute is used to specify which test methods to skip during test execution

• Include attribute is used to specify which test methods to run during test execution

• Both attributes can be used in the testng.xml file or in the @Test annotation

• Example: @Test(groups = {"smoke"}, excludeGroups = {"regression"})
Answered by AI
Add your answer
Q5. What is code for reverse a digit?
Ans. 
To reverse a digit, convert it to a string and then reverse the string.
• Convert the digit to a string

• Use built-in functions to reverse the string

• Convert the reversed string back to a digit if needed
Answered by AI
Add your answer

It's walkin, so they conducted 1 technical mcqs round.

Q1. Multi threading
Add your answer
Q2. Internal working of hashmap
Ans. 
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap uses an array of buckets to store key-value pairs.

• Keys are hashed to determine the index in the array where the key-value pair will be stored.

• In case of hash collisions, a linked list or a balanced tree is used to store multiple key-value pairs in the same bucket.

• HashMap allows null keys...read more
Answered by AI
Add your answer
Q3. Spring batch related
Add your answer
Q4. Non repeating characters in a array
Ans. 
Function to find and return all non-repeating characters in an array of strings.
• Iterate through the array and count the occurrences of each character using a HashMap.

• Then iterate through the array again and check if the count of each character is 1, if so add it to the result list.

• Return the list of non-repeating characters.
Answered by AI
Add your answer
Q5. 3rd highest salary
Ans. 
To find the 3rd highest salary in a database, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query with 'ORDER BY salary DESC' to sort the salaries in descending order.

• Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and retrieve the third highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q6. Qualifier vs primary
Ans. 
A qualifier in Java is used to specify additional information about a primary, which is the main data type or variable.
• A primary in Java is the main data type or variable, while a qualifier provides additional information about the primary.

• Qualifiers can be used to modify the behavior or characteristics of a primary.

• For example, in Java, 'final' is a qualifier that can be used to make a variable constant.
Answered by AI
Add your answer
Q7. Controller vs restcontroller
Ans. 
The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.
• Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.

• @Controller is used to create web pages, while @RestController is used to return data in JSON or XML format.

• @RestController is a convenience annotati...read more
Answered by AI
Add your answer
Q8. Spring boot annotataions
Add your answer
Q9. Oops concepts with examples
Ans. 
OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

• Polymorphism: Ability for objects to be treated as instances of their paren...read more
Answered by AI
Add your answer
Q10. Spring batch configuration
Add your answer
Q11. They covered all java, spring and Microservices
Add your answer

Q1. Microservices architecture
Add your answer
Q2. How do Microservices communicate
Ans. 
Microservices communicate with each other through various communication protocols like HTTP, messaging queues, and gRPC.
• Microservices can communicate over HTTP using RESTful APIs.

• Messaging queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.

• gRPC is a high-performance, open-source RPC framework that can be used for communication between microservices.

• Service discovery mechanism...read more
Answered by AI
Add your answer
Q3. How to access the Microservice end point
Ans. 
Microservice endpoints can be accessed using HTTP requests with the appropriate URL
• Use HTTP methods like GET, POST, PUT, DELETE to interact with the microservice

• Construct the URL with the base URL of the microservice and the specific endpoint path

• Include any necessary headers or parameters in the request for authentication or data filtering
Answered by AI
Add your answer
Q4. Why we use microservices
Ans. 
Microservices allow for modular, scalable, and flexible software development by breaking down applications into smaller, independent services.
• Microservices enable easier maintenance and updates as each service can be developed, deployed, and scaled independently.

• They improve fault isolation, as failures in one service do not necessarily affect the entire application.

• Microservices promote agility and faster time-to-mark...read more
Answered by AI
Add your answer

Q1. Why do want to join eclerx?
Add your answer

Q1. Tell me about financial market?
Add your answer

Basics of mathematical ability and verbal ability

Q1. Introduction - explain projects
Add your answer
Q2. Data analytics explain
Add your answer

Q1. What are the different types of interfaces?
Ans. 
Different types of interfaces include user interfaces, hardware interfaces, and software interfaces.
• User interfaces: allow users to interact with the system, such as graphical user interfaces (GUI) and command-line interfaces (CLI)

• Hardware interfaces: connect hardware components to the system, such as USB, HDMI, and Ethernet ports

• Software interfaces: define how software components interact with each other, such as appl...read more
Answered by AI
Add your answer
Q2. What is the output of the program when the expression is evaluated as 0 divided by 7?
Ans. 
The output of the program when 0 is divided by 7 is 0.
• Division of 0 by any number results in 0.

• In programming languages, dividing by 0 usually results in an error or undefined behavior.
Answered by AI
Add your answer
Q3. What are coroutines, scope functions, and visibility modifiers?
Ans. 
Coroutines, scope functions, and visibility modifiers are key concepts in Kotlin programming for Android development.
• Coroutines are a way to perform asynchronous programming in a sequential manner. They allow for non-blocking operations.

• Scope functions are functions that allow you to execute a block of code within the context of an object. Examples include 'let', 'apply', 'run', 'also', and 'with'.

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

Q1. What is the MVVM (Model-View-ViewModel) architectural pattern?
Ans. 
MVVM is an architectural pattern that separates the user interface from the business logic and data handling in Android development.
• Model represents the data and business logic of the application.

• View is responsible for displaying the UI elements and sending user interactions to the ViewModel.

• ViewModel acts as a mediator between the Model and the View, handling the communication and data flow.

• MVVM helps in achieving se...read more
Answered by AI
Add your answer
Q2. What are the reasons for using that, and what are its pros and cons?
Ans. 
Using dependency injection in Android development can improve code maintainability and testability.
• Pros: easier to manage dependencies, promotes code reusability, facilitates unit testing

• Cons: initial setup can be complex, may introduce overhead in smaller projects

• Example: Using Dagger 2 for dependency injection in an Android project
Answered by AI
Add your answer
Q3. Questions related Dependency injection dagger-hilt / koin
Add your answer

Q1. What are the reasons for using the Border Gateway Protocol (BGP)?
Ans. 
BGP is used for routing and exchanging routing information between different autonomous systems.
• BGP allows for dynamic routing between different autonomous systems

• It provides redundancy and load balancing by choosing the best path for data traffic

• BGP helps in preventing network loops and ensuring efficient data routing

• It is commonly used by Internet Service Providers (ISPs) to exchange routing information

• BGP is essenti...read more
Answered by AI
Add your answer
Q2. What is a switch stack?
Ans. 
A switch stack is a group of network switches that are interconnected and operate as a single unit.
• Switch stack simplifies network management by allowing multiple switches to be managed as one entity.

• It provides high availability and redundancy by allowing one switch to take over if another fails.

• Switch stack can also increase network performance by load balancing traffic across multiple switches.

• Examples of switch sta...read more
Answered by AI
Add your answer
Q3. What are the configurations required in wireless networking?
Ans. 
Configurations required in wireless networking include SSID, security settings, encryption type, and channel selection.
• Set up a unique SSID to identify the network

• Choose appropriate security settings such as WPA2-PSK

• Select encryption type like AES for secure data transmission

• Optimize channel selection to avoid interference
Answered by AI
Add your answer
Q4. What are the different types of VPNs?
Ans. 
Different types of VPNs include remote access VPN, site-to-site VPN, and client-to-site VPN.
• Remote access VPN allows individual users to connect to a private network remotely.

• Site-to-site VPN connects multiple networks together over the internet.

• Client-to-site VPN allows individual devices to connect to a private network remotely.

• Other types include MPLS VPN, SSL VPN, and IPsec VPN.
Answered by AI
Add your answer
Q5. What is the purpose of native VLAN?
Ans. 
The purpose of native VLAN is to carry untagged traffic across a trunk link.
• Native VLAN is used for untagged traffic on a trunk link

• It allows devices that do not support VLAN tagging to communicate over the trunk link

• Native VLAN should be the same on both ends of the trunk link to avoid VLAN hopping attacks
Answered by AI
Add your answer