Avantel Java Developer Interview Questions and Answers

It was not difficult ..it was good ..overall experience was good

Not too difficult ...array realated question were asked

Graph and Dynamic programming related 2 questions

Q1. Greedy algorithm Java related questions asked.
Add your answer

Q1. Except for Rafael aircraft, what else does India has to do with France.
Add your answer

First round was a DSA round. Interviewers were helpful.

Q1. It was a technical round with the team lead.
Add your answer

Q1. Bascic html and django questions
Add your answer

Waste of time and energy sql queries

Q1. Salary negotation and location details
Add your answer

There were 3 sections. 1st was aptitute 10 questions and 2nd section was technical 10 questions then 3rd section had 3 coding questions which were of easy level.

Q1. Questions related to OS and CN and Core java were asked.
Add your answer
Q2. A coding question was also asked to to find the second largest number.
Add your answer

Round duration - 70 Minutes
Round difficulty - Medium

This was an Online Coding+MCQ round where we had a total of 50 MCQ questions and 1 coding problem. The coding problem was of easy to medium level but was a bit implementation heavy.

Q1. Intersection of Linked List
You are given two Singly Linked List of integers, which are merging at some node of a third linked list.
Your task is to find the data of the node at which merging starts. If ...read more
Ans. 
Approach :


I) Using Hashing :
Basically, we need to find a common node of two linked lists. So we hash all nodes of the first list and then check the second list.

Note : Hash the nodes not the node value

1) Create an empty hash set.
2) Traverse the first linked list and insert all nodes' addresses in the hash set.
3) Traverse the second list. For every node check if it is present in the hash set. If we find a node in the has...read more
Answered by CodingNinjas
View 3 more answers

Round duration - 60 Minutes
Round difficulty - Medium

The interviewer asked 1 coding problem related to Sliding Window in this round and then the rest of the questions were preety much revolving around Computer Networks and OOPS.

Q1. Longest Substring Without Repeating Characters
Given a string 'S' of length 'L', return the length of the longest substring without repeating characters.
Example:
Suppose given input is ...read more
Ans. 
Approach : I solved it using 2-pointers and keeping a track of the frequency of the elements encountered in a freq array of size 26.

Steps :
1) Initiliase a freq array of size 26 where a=0, b=1 ...,z=25 .
2) Let s be our string and n = s.size()
3) Do , freq[s[0]]++;
4) Keep 2 pointers start and end where initially start=0 and end=1 also maintain a answer variable ans where initially ans=0
5) Now run a loop till end=1 and sta...read more
Answered by CodingNinjas
View 4 more answers
Q2. Networking Question
Explain what is DNS.
Ans. 
DNS is the Domain Name System. It is considered as the devices/services directory of the Internet. It is a decentralized and hierarchical naming system for devices/services connected to the Internet. It translates the domain names to their corresponding IPs.
Answered by CodingNinjas
Add your answer
Q3. Networking Question
Explain why MAC addresses are required despite having IP addresses
Ans. 
MAC addresses and IP addresses operate on different layers of the internet protocol suite. MAC addresses are used to identify machines within the same broadcast network on layer 2, while IP addresses are used on layer 3 to identify machines throughout different networks.

Even if your computer has an IP address, it still needs a MAC address to find other machines on the same network (especially the router/gateway to the ...read more
Answered by CodingNinjas
Add your answer
Q4. OOPS Question
How does C++ support Polymorphism?
Ans. 
C++ is an Object-oriented programming language and it supports Polymorphism as well:

Compile Time Polymorphism: C++ supports compile-time polymorphism with the help of features like templates, function overloading, and default arguments.

Runtime Polymorphism: C++ supports Runtime polymorphism with the help of features like virtual functions. Virtual functions take the shape of the functions based on the type of object in
Answered by CodingNinjas
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This round had questions revolving around Computer Networks and Operating Systems.

Tip : Concepts related to Computer Networks is quite frequently asked in Cisco interviews . So its better to remain equipped with all the fundamental concepts. I prepared all the core subjects from my notes and for revision I would suggest the guided paths of Coding Ninjas , they are very useful for quick revision and also the questions over there are very frequently asked in interviews.

Q1. Networking Question
What is the ARP protocol?
Ans. 
ARP is Address Resolution Protocol. It is a network-level protocol used to convert the logical address i.e. IP address to the device's physical address i.e. MAC address. It can also be used to get the MAC address of devices when they are trying to communicate over the local network.
Answered by CodingNinjas
Add your answer
Q2. Networking Question
What happens when you enter Google.com on the web browser.
Ans. 
1) The browser extracts the domain name from the URL.

2) The browser queries DNS for the IP address of the URL. Generally, the browser will have cached domains previously visited, and the operating system will have cached queries from any number of applications. If neither the browser nor the OS have a cached copy of the IP address, then a request is sent off to the system's configured DNS server. The client machine kno...read more
Answered by CodingNinjas
Add your answer
Q3. OS Question
What are the different types of semaphores ?
Ans. 
Answer :
There are two main types of semaphores i.e. counting semaphores and binary semaphores.

1) Counting Semaphores :
These are integer value semaphores and have an unrestricted value domain. These semaphores are used to coordinate the resource access, where the semaphore count is the number of available resources. If the resources are added, semaphore count automatically incremented and if the resources are removed, t...read more
Answered by CodingNinjas
Add your answer
Q4. OS Question
What is thrashing in OS?
Ans. 
Answer :
1) It is generally a situation where the CPU performs less productive work and more swapping or paging work.
2) It spends more time swapping or paging activities rather than its execution.
3) By evaluating the level of CPU utilization, a system can detect thrashing.
4) It occurs when the process does not have enough pages due to which the page-fault rate is increased. 5) It inhibits much application-level processi...read more
Answered by CodingNinjas
Add your answer

Q1. Find the min and max from List of Integers using java 8 streams.
Ans. 
Find min and max from List of Integers using Java 8 streams.
• Use the `stream()` method on the List to create a stream of integers.

• Use the `min()` method to find the minimum value.

• Use the `max()` method to find the maximum value.
Answered by AI
Add your answer
Q2. Find 2nd largest element using java 8 streams from list of integers.
Ans. 
Find 2nd largest element using Java 8 streams from a list of integers.
• Sort the list of integers in descending order using streams.

• Skip the first element to get the second largest element.
Answered by AI
Add your answer
Q3. Given a Product class and some ArrayList data Find which products has price greater than 200 using java 8 streams?. Find which products having maximum price?
Add your answer
Q4. Increase a value of List of Integers by *2 and written new list.
Ans. 
Increase the values of a list of integers by 2 and create a new list.
• Iterate through the list of integers

• For each integer, add 2 to its value

• Create a new list with the updated values
Answered by AI
Add your answer
Q5. What are the java new features?
Ans. 
Java has introduced several new features in recent versions.
• Java 8 introduced lambda expressions, which allow for functional programming.

• Java 8 also introduced the Stream API for processing collections of data.

• Java 9 introduced the module system, which provides better encapsulation and modularity.

• Java 10 introduced local variable type inference, allowing the omission of explicit type declarations.

• Java 11 introduced the...read more
Answered by AI
Add your answer
Q6. @Components vs @Repository
Ans. 
The @Component and @Repository annotations are used in Spring Framework for different purposes.
• Both annotations are used to define beans in the Spring container.

• @Component is a generic stereotype annotation for any Spring-managed component.

• @Repository is a specialization of @Component used for DAO classes.

• The @Repository annotation provides additional exception translation for data access exceptions.

• Using @Repository i...read more
Answered by AI
Add your answer
Q7. @SpringBootApplication
Add your answer
Q8. @Entity explain?
Ans. 
The @Entity annotation is used in Java to mark a class as an entity, which represents a table in a relational database.
• The @Entity annotation is part of the Java Persistence API (JPA) and is used in object-relational mapping (ORM) to map Java objects to database tables.

• It is typically used in conjunction with other JPA annotations like @Table, @Column, and @Id.

• The @Entity annotation is used to define the entity name, s...read more
Answered by AI
Add your answer
Q9. How the database is configure?
Ans. 
The database is configured by setting up the necessary parameters and configurations to ensure proper functioning and performance.
• Database configuration involves defining the database schema, tables, and relationships.

• It includes setting up indexes and constraints for data integrity.

• Configuring database security measures like user access control and permissions.

• Tuning database performance by optimizing query execution ...read more
Answered by AI
Add your answer
Q10. What is Dockerfile?
Ans. 
Dockerfile is a text file that contains instructions to build a Docker image.
• Dockerfile is used to automate the creation of Docker images.

• It specifies the base image, dependencies, environment variables, and commands to run.

• Each instruction in the Dockerfile creates a new layer in the image.

• Dockerfile can be version controlled and shared to ensure consistent builds.

• Example: FROM ubuntu:latest RUN apt-get update && apt-...read more
Answered by AI
Add your answer
Q11. Explain CI CD and your project deployment.
Ans. 
CI/CD is a software development practice that enables frequent and automated code integration, testing, and deployment.
• CI/CD stands for Continuous Integration and Continuous Deployment.

• It involves automating the process of integrating code changes, running tests, and deploying the application.

• CI/CD helps in reducing manual errors, improving code quality, and increasing development speed.

• Tools like Jenkins, GitLab CI/CD...read more
Answered by AI
Add your answer
Q12. What is mutable classes in java? How to create?
Ans. 
Mutable classes in Java are classes whose state can be modified after creation.
• Mutable classes allow changing their internal state

• They can have mutable fields or methods that modify their state

• To create a mutable class, define fields with non-final modifiers

• Provide public methods to modify the state of the class
Answered by AI
Add your answer

Q1. Yet to sChedule
Add your answer

It is consisting of 5 questions,and each question carry 20 marks.difficulaty level of the question is easy to moderate.

Q1. They were asking mainy DSA, project,and internship
Add your answer