If you are looking to prepare for the Infosys technical interview for any of the roles (System Engineer Trainee (SET), Digital Specialist Engineer (DSE), or Specialist Programmer (SP)), then you need to ensure that you understand some core technical concepts.
The technical interview at Infosys will generally test your knowledge of programming, problem solving, understanding of computer science fundamentals and practical experience.
This article includes 34 important Infosys technical interview questions and answers for freshers covering common technical topics: OOPs, DBMS, SQL, Java, Python, operating systems, computer networks, data structures and algorithms (DSA), and project questions. Looking for HR and process questions too? Read our guide on Infosys interview questions for freshers.
Infosys OOPs Interview Questions
1. What is OOP (Object Oriented Programming)?
Object Oriented Programming (OOP) is a programming paradigm that is based on objects and classes. This helps you organise code in an easy to manage and reusable way.
OOP has four main principles:
- Encapsulation – This is wrapping data and functions into a single unit.
- Inheritance – This enables one class to inherit from another.
- Polymorphism – This allows one method to act differently based on the situation.
- Abstraction – This hides the implementation details.
2. What is the difference between a class and an object?
A class is a template for creating objects. An object is an instance of a class.
For example, Car could be a class while Red Car would be an object.
A class defines properties and methods, while an object uses them.
3. What is inheritance?
Inheritance is a concept in OOP that enables one class to inherit from another.
The class being inherited from is called the parent/base class. The class doing the inheriting is called the child/derived class.
This increases reusability of the code.
4. What is polymorphism?
Polymorphism means having many forms.
The 2 common types are:
- Compile time polymorphism – Method overloading.
- Run time polymorphism – Method overriding.
The method calculate() could have different actions dependent on the arguments or object calling it.
5. What is the difference between method overloading and method overriding?
Method overloading is when multiple methods exist with the same name but different parameters.
Method overriding is when a child class creates its own version of a method that already exists in the parent class.
Overloading is often associated with compile time polymorphism. Overriding allows for run time polymorphism.
Infosys DBMS Interview Questions
6. What is DBMS?
A Database Management System (DBMS) is a piece of software that is used to store, manage, retrieve and organise data.
Examples would be MySQL, Oracle Database, PostgreSQL, Microsoft SQL Server.
This helps keep data consistent, secure and accessible.
7. What is the difference between DBMS and RDBMS?
A DBMS is used to manage databases. An RDBMS is a type of DBMS that stores data in tables (rows and columns) and enables relationships between tables.
These commonly use SQL and allow for constraints like Primary Keys and Foreign Keys.
Examples would be MySQL, Oracle, PostgreSQL.
8. What is a primary key and foreign key?
A primary key is a column (or multiple columns) that uniquely identifies each row in a table. This cannot contain duplicates or NULL values.
A foreign key is a column (or multiple columns) that refers to another table’s candidate key (often primary key).
This helps with referential integrity.
9. What is database normalisation?
Normalisation is organising tables in a database to reduce duplication.
The common normal forms are:
- 1NF – All columns contain atomic values. No repeating groups.
- 2NF – 1NF and all non-key attributes depend on the full candidate key.
- 3NF – 2NF and no transitive dependencies on candidate keys for non-key attributes.
- BCNF – All determinants are candidate keys.
10. What are ACID properties in DBMS?
ACID properties ensure reliable transactions.
- Atomicity – Either the full transaction has been completed or nothing happens.
- Consistency – Database rules and constraints are followed.
- Isolation – Transactions running in parallel should not interfere.
- Durability – Changes made by transactions are durable once they have been committed.
Infosys SQL Interview Questions and Answers
11. What is SQL?
Structured Query Language (SQL) is used to interact with relational databases.
This helps users create tables, insert rows, update data, delete rows and retrieve data.
Common commands are SELECT, INSERT, UPDATE, DELETE, CREATE, DROP.
12. What is the difference between DELETE, DROP and TRUNCATE?
- DELETE – Deletes selected rows or all rows from a table. Can use a WHERE condition.
- TRUNCATE – Deletes all data from a table.
- DROP – Deletes the full table.
This will vary depending on the database.
13. What is the difference between WHERE and HAVING?
The WHERE clause is used to filter the rows.
The HAVING clause is used to filter groups.
For example:
SELECT department, COUNT(*)
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;
This will show all departments with more than 5 employees.
14. What are joins in SQL?
Joins are used to retrieve related data from multiple tables.
The main types are:
- INNER JOIN – Returns rows that match in both tables.
- LEFT JOIN – Returns all rows from the left table and any matching rows from the right table.
- RIGHT JOIN – Returns all rows from the right table and any matching rows from the left table.
- FULL OUTER JOIN – Returns all matching and non-matching rows.
15. Write a query to get the second highest salary.
To get the second highest salary you can do:
SELECT MAX(salary)
FROM employees
WHERE salary < (
SELECT MAX(salary)
FROM employees
);
The inner query gets the highest salary. The outer query gets the max salary below this.
This will return the second highest distinct salary.
Infosys Java and Python Interview Questions
16. What is the difference between Java and Python?
Java and Python are two of the most popular programming languages.
| Java | Python |
| Static typing | Dynamic typing |
| Explicit typing | Typing not required |
| Braces | Indentation |
| Usually compiled into byte code to run on JVM | Usually run using an interpreter |
| Often used in enterprise solutions | Often used in automation, data science, AI, web development |
Both can use OOP.
17. What is the difference between JDK, JRE and JVM?
- JDK (Java Development Kit) – Contains the tools needed to develop Java applications (compiler).
- JRE (Java Runtime Environment) – Contains the runtime components needed to run Java applications.
- JVM (Java Virtual Machine) – Runs the Java byte code.
The JDK is used for developing while the JVM runs the byte code.
18. What is the difference between arrays and linked lists?
Arrays store data in contiguous memory locations. You can directly access items using indexes.
Linked lists store data in nodes. Each node contains data and points to another node.
Arrays can be accessed quickly using indexes (constant time).
Linked lists require traversing to get to the data.
Inserting and deleting can be inefficient in an array if inserting in the middle.
Inserting and deleting can be very efficient in a linked list if the node is known.
19. What is exception handling?
Exception handling is a mechanism that allows us to catch runtime errors without halting the program.
In Java this can be done using keywords such as:
- try
- catch
- finally
- throw
- throws
In Python this is commonly done using try, except, else and finally.
20. What is the difference between lists and tuples in Python?
A list is a mutable collection of data.
A tuple is an immutable collection of data.
For example:
my_list = [10, 20, 30]
my_list[0] = 50
my_tuple = (10, 20, 30)
Lists are useful if you need to make changes to the data. Tuples are useful if you need a fixed collection.
Infosys Operating System Interview Questions
21. What is an operating system (OS)?
An operating system (OS) is system software that is used to manage hardware and software.
This acts as an intermediary between users, applications and hardware.
Examples are Windows, Linux, macOS, Android.
22. What is the difference between a process and a thread?
A process is an instance of a running program. This has its own address space.
A thread is the smallest unit of execution within a process. Threads in the same process usually share the process’s memory and resources.
Threads are usually less resource intensive.
23. What is a deadlock?
A deadlock occurs when two or more processes are waiting indefinitely for resources from each other.
There are four conditions that must be met for a deadlock to occur:
- Mutual Exclusion – At least one resource cannot be shared.
- Hold and Wait – A process is holding resources and waiting for more.
- No Preemption – Resources cannot be forcibly taken.
- Circular Wait – Processes form a circle waiting for each other’s resources.
24. What is virtual memory?
Virtual memory is a technique used to give processes their own address space. The OS and hardware translate virtual addresses to physical addresses.
This allows programs to run using an address space greater than the available RAM. Pages that are not used as much can be stored in secondary storage.
25. What is the difference between multitasking and multiprocessing?
Multitasking is the ability of an operating system to handle multiple tasks. This can be done by switching between tasks or running in parallel.
Multiprocessing is when two or more processing units/CPU cores are used to run processes in parallel.
Multitasking improves resource usage while multiprocessing can have parallel execution.
Infosys Computer Networks Interview Questions
26. What is a computer network?
A computer network is a group of connected devices.
This allows devices to share information, files and services such as the internet.
Examples are LAN, MAN and WAN.
27. What is the difference between TCP and UDP?
| TCP | UDP |
| Connection oriented | Connectionless |
| Reliable ordered delivery | Not guaranteed delivery or order. |
| Acknowledgements and retransmission. | No inbuilt retransmission. |
| More protocol overhead. | Less protocol overhead. |
| Used for applications such as HTTP (using TCP). | Used for applications such as DNS. |
28. What is the OSI model?
The OSI model is a conceptual model that has seven layers:
- Physical Layer
- Data Link Layer
- Network Layer
- Transport Layer
- Session Layer
- Presentation Layer
- Application Layer
Each layer performs specific tasks.
29. What is an IP address?
An IP address is a logical address given to a device/network interface to communicate in an IP network.
There are two versions:
- IPv4 – 32 bit address e.g. 192.168.1.1.
- IPv6 – 128 bit address e.g. 2001:db8::1.
This helps identify network interfaces and allows packets to be routed.
Infosys DSA Interview Questions (Data Structures and Algorithms)
30. What is a data structure?
A data structure is a way of storing data to make it easily accessible and modifiable.
Common data structures are:
- Array
- Linked List
- Stack
- Queue
- Tree
- Graph
- Hash Table
Using the correct data structure can improve performance in a program.
31. What is the difference between a stack and a queue?
Stacks work on a LIFO principle (Last In, First Out). The last item added is the first to be removed.
Queues work on a FIFO principle (First In, First Out). The first item added is the first to be removed.
Examples of stacks are undo and function calls. Examples of queues are task scheduling.
32. What is binary search?
Binary search is an efficient searching algorithm that can be applied to sorted data.
This works by continually halving the search space and comparing the value to the middle.
The time complexity of this is O(log n) compared to linear search which has a time complexity of O(n).
33. What is the difference between linear search and binary search?
Linear search searches through each element until it finds the value.
Binary search continually halves the search space.
| Linear Search | Binary Search |
| Unsorted data | Sorted data |
| Time complexity O(n) | Time complexity O(log n) |
| Searches sequentially | Removes half of search space. |
Infosys Project-Based Technical Interview Questions
Project questions are important as your interviewer may ask you about projects on your resume.
34. Tell me about your project and what your role was.
This is one of the important questions to prepare for your Infosys technical interview.
When answering this question, include the following points:
- Project Title – What was the name of your project and what was the aim?
- Problem Statement – What problem were you solving?
- Technologies Used – Which programming language, frameworks, database and tools did you use?
- Implementation – How did your project work?
- Contribution – Clearly state what modules/features you created.
- Challenges – What technical challenges did you overcome?
- Outcome – What was the outcome and what did you learn?
Be prepared to be asked about the code, database, architecture and technologies used.
Other Project Questions to Prepare
In addition to explaining your project, prepare answers to:
- Why did you choose this project?
- What was your individual contribution?
- What programming language did you use and why?
- What database did you use?
- How did you handle errors and exceptions?
- What challenges did you face?
- How would you improve this project in the future?
- Can you explain an important function/code?
- How did you test your project?
- What would happen if there was a large increase in users?
How to Prepare for the Infosys Technical Interview
Brush up on your programming fundamentals.
Variables, loops, functions, arrays, strings, recursion and basic programming concepts in your preferred language.
Practice SQL queries.
Focus on joins, aggregate functions, subqueries, GROUP BY, HAVING and simple queries.
Brush up on your core computer science topics.
Ensure you understand OOP, DBMS, operating systems and computer networks.
Practice some basic DSA questions.
Practice array, string, search, sort, stack, queue and linked list questions.
Brush up on your resume projects.
Be prepared to explain every technology and project on your resume. You may be asked detailed questions about what you actually contributed.
Practice explaining your answers.
Be clear and structured in your answers. If you don’t know the answer, be honest.
For more fresher jobs, internships and off-campus drives, visit CampusToDrive.
Infosys Technical Interview Questions: FAQs
What questions are asked in the Infosys technical interview for freshers?
Infosys technical interview questions for freshers usually cover OOP, DBMS, SQL, Java or Python, operating systems, computer networks, basic DSA and questions about your resume projects.
What are the most important topics to revise for the Infosys technical interview?
OOP, DBMS, SQL, Java/Python, Operating Systems, Computer Networks, DSA and project questions.
Does the Infosys technical interview include coding questions?
Depending on your role you may be asked to code. Practice some basic programs using arrays, strings, sorting, searching and logical problems.
Is Java or Python better to prepare for the Infosys interview?
You can prepare for either Java or Python. Choose whichever you are most proficient in. Ensure you understand the fundamentals and can write some basic programs.
Are project questions important in the Infosys technical interview?
Yes! You may be asked about your projects from your studies or personal life. Ensure you understand the architecture, implementation, database, technologies and your individual contribution.
Are the technical questions the same for SET, DSE and SP?
This can vary depending on your role. The depth of technical questions and coding may vary.




[…] to go deeper on the technical round? Read our detailed guide on Infosys technical interview questions and answers, covering OOPs, DBMS, SQL, Java, Python, OS, CN and […]