i
Infosys
Filter interviews by
Partitioning in Oracle allows tables, indexes, and index-organized tables to be subdivided into smaller, more manageable pieces.
Partitioning improves query performance by allowing operations to be performed on individual partitions instead of the entire table.
Types of partitioning include range, list, hash, and composite partitioning.
Example: Creating a range partitioned table based on a date column to store data for e
SQL queries on various basic concepts
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Inheritance in C# allows a class to inherit properties and behavior from another class.
Allows a class to reuse code from another class
Derived class inherits members from base class
Supports single and multiple inheritance through interfaces
I applied via Job Portal
Infosys interview questions for designations
I applied via Campus Placement
Get interview-ready with Top Infosys Interview Questions
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
DBMS stands for Database Management System. It is a software that manages databases, allowing users to store, retrieve, and manipulate data efficiently.
DBMS helps in creating, updating, and managing databases.
It provides a structured way to store and organize data.
DBMS ensures data integrity and security.
Examples of DBMS include MySQL, Oracle, and Microsoft SQL Server.
A mutating error occurs when a program attempts to modify a data structure while iterating over it.
Occurs when a program tries to modify a collection (e.g. array, list) while iterating through it
Can lead to unexpected behavior or errors in the program
Common in languages like Python, where modifying a list while iterating over it can cause a mutating error
I applied via LinkedIn and was interviewed in Dec 2023. There was 1 interview round.
HashMap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.
HashMap is part of the Java Collections framework.
It uses hashing to store and retrieve elements efficiently.
Each key in a HashMap must be unique.
Example: HashMap
Data structures are different in terms of their implementation, efficiency, and usage in solving specific problems.
Different data structures have different ways of organizing and storing data, such as arrays, linked lists, trees, and graphs.
Each data structure has its own set of operations that can be performed efficiently, such as searching, inserting, deleting, and sorting.
Choosing the right data structure is crucial...
I applied via Naukri.com
Filter employee objects from a list using Java streams.
Use stream() method to convert the list to a stream.
Use filter() method to specify the condition for filtering employee objects.
Use collect() method to collect the filtered employee objects into a new list.
Java program to sort a list of strings
Use Collections.sort() method to sort the list of strings
Create a list of strings and add elements to it
Call Collections.sort() method on the list to sort it
What people are saying about Infosys
Some of the top questions asked at the Infosys Technology Analyst interview -
The duration of Infosys Technology Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 220 interviews
5 Interview rounds
based on 4.3k reviews
Rating in categories
Technology Analyst
55.8k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50.6k
salaries
| ₹2.8 L/yr - ₹9 L/yr |
System Engineer
39.5k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.8k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.8k
salaries
| ₹4.5 L/yr - ₹17 L/yr |
TCS
Wipro
Cognizant
Accenture