i
Infosys
Filter interviews by
I applied via Company Website
No, we cannot use commit or roll back within a trigger.
Triggers are automatically committed or rolled back as part of the transaction that fired them.
Using commit or rollback within a trigger can lead to unpredictable behavior and is not recommended.
Materialized views store the results of a query and can be refreshed to update the data.
Materialized views store the results of a query in a table-like structure
They can be refreshed manually or automatically based on a schedule
Refresh options include full, fast, and force refresh
Example: CREATE MATERIALIZED VIEW mv_name AS SELECT * FROM table_name;
Use CONNECT BY LEVEL to print numbers from 1 to 10 in Oracle SQL
Use CONNECT BY LEVEL to generate rows from 1 to 10
Select the generated numbers in the query
Context switching is the process of storing and restoring the state of a CPU so that multiple processes can share the same CPU.
Context switching allows the CPU to switch from one process to another, enabling multitasking.
In Oracle PLSQL, collection types are used to store multiple values in a single variable.
Examples of collection types in PLSQL include arrays, nested tables, and associative arrays.
Analytical functions are used to perform calculations across a set of rows related to the current row.
Analytical functions are used to calculate aggregate values based on a group of rows.
They can be used to calculate running totals, moving averages, rank, percentiles, etc.
Examples include functions like ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD(), SUM() OVER(), AVG() OVER().
Set operators are used to combine the result sets of two or more SELECT statements. UNION ALL keeps duplicates.
Set operators include UNION, UNION ALL, INTERSECT, and MINUS
UNION ALL retains duplicate rows from the result sets
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
I am a passionate Angular Developer with 5 years of experience in building responsive web applications.
5 years of experience in Angular development
Strong knowledge of HTML, CSS, and JavaScript
Experience in building responsive web applications
Familiarity with RESTful APIs and version control systems like Git
Attributes in HTML provide additional information about an element and are defined within the element's start tag.
Attributes are used to modify the behavior or appearance of an HTML element.
They are specified within the opening tag of an element using name-value pairs.
Examples include 'href' in an anchor tag (<a href='https://www.example.com'>) and 'src' in an image tag (<img src='image.jpg'>).
Flexbox is a layout model in CSS that allows for dynamic and responsive design of web pages.
Flexbox is used to create flexible layouts that can adapt to different screen sizes and orientations.
It allows for easy alignment and distribution of elements within a container.
Flexbox properties include display: flex, flex-direction, justify-content, align-items, and flex-grow.
Example: display: flex; justify-content: center; a
Developed a web application for managing inventory and sales for a retail store.
Used Angular framework for front-end development
Implemented CRUD operations for managing products and sales
Integrated with backend APIs for data retrieval and storage
Methods to transfer data between components in Angular include Input and Output properties, ViewChild, Services, and Event Emitters.
Using Input and Output properties to pass data from parent to child components and emit events from child to parent components.
Using ViewChild to access child components and their properties directly from the parent component.
Using Services to create a shared service that can be injected i...
I am a passionate Angular Developer with 5 years of experience in building responsive web applications.
5 years of experience in Angular development
Strong knowledge of HTML, CSS, and JavaScript
Experience in building responsive web applications
Familiarity with RESTful APIs and version control systems like Git
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
I am a Senior Android Developer with 5+ years of experience in developing mobile applications for various industries.
Developed and maintained multiple Android applications from concept to deployment
Proficient in Java, Kotlin, and Android SDK
Experience with RESTful APIs, third-party libraries, and version control systems like Git
Strong problem-solving skills and ability to work in a team environment
Familiar with Agile d
Higher order function is a function that can take other functions as parameters or return functions as results.
Higher order functions can be passed as arguments to other functions.
Higher order functions can return functions as results.
Examples include map, filter, and reduce functions in functional programming.
The inline keyword is used in Kotlin to suggest that a function should be inlined at the call site.
Used to eliminate the overhead of function calls by copying the function code directly at the call site
Helps in improving performance by reducing the function call overhead
Should be used for small functions or lambdas to avoid unnecessary function call overhead
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and iterative development.
Agile methodology focuses on delivering working software in short, iterative cycles called sprints.
It values customer collaboration and responding to change over following a strict plan.
Key principles include individuals and interactions over processes and tools, working software over comprehensive d...
Infosys interview questions for popular designations
Get interview-ready with Top Infosys Interview Questions
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Program to count consecutive characters in a string
Iterate through the string and compare each character with the next one
Maintain a count for each character and append to the output string when a different character is encountered
Example: input 'aabbccc' -> output 'a2b2c3'
Dynamic xpath is a way to locate elements on a web page based on changing attributes or positions.
Use functions like contains(), starts-with(), or ends-with() to create dynamic xpaths
Avoid using indexes in xpaths as they can change with page updates
Consider using unique attributes or text within the element to create a reliable xpath
PUT is used to update or replace an entire resource, while PATCH is used to update specific fields of a resource.
PUT is idempotent, meaning multiple identical requests will have the same effect as a single request.
PATCH is not necessarily idempotent, as multiple identical requests may have different effects.
PUT requires the client to send the entire updated resource, while PATCH only requires the client to send the spe
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
I am a highly motivated and experienced Senior Associate Consultant with a strong background in project management and client relations.
Over 5 years of experience in consulting industry
Managed multiple projects simultaneously, exceeding client expectations
Skilled in data analysis and presentation
Excellent communication and interpersonal skills
I am currently working on a project in the finance domain, specifically focusing on risk management for a large investment bank.
Developing risk models to assess potential losses in different market scenarios
Analyzing historical data to identify trends and patterns in market behavior
Collaborating with traders and portfolio managers to understand their risk appetite and constraints
Code logic to find duplicate numbers in an array
Iterate through the array and store each element in a hash set
If an element is already in the hash set, it is a duplicate
Return the set of duplicate numbers found
Conflicts in a git merge can be resolved by manually editing the conflicting files and then committing the changes.
Use 'git status' to identify the conflicting files
Open the conflicting files in a text editor and resolve the conflicts manually
Use 'git add' to stage the resolved files
Commit the changes using 'git commit'
Object creation is not possible for abstract classes because they cannot be instantiated directly.
Abstract classes are meant to be used as base classes for other classes to inherit from.
They contain abstract methods that must be implemented by the child classes.
Attempting to create an object of an abstract class will result in a compilation error.
Example: abstract class Shape { abstract void draw(); }
Exception handling in Java is used to handle runtime errors and prevent program crashes.
Purpose is to handle runtime errors and prevent program crashes
Allows for graceful handling of unexpected situations
Helps in separating error-handling code from regular code
Improves code readability and maintainability
Examples: try-catch blocks, throw keyword, finally block
LinkedList is a linear data structure that stores elements in a sequential order, while HashSet is a collection that does not allow duplicate elements.
LinkedList maintains the insertion order of elements, while HashSet does not guarantee any specific order.
LinkedList allows duplicate elements, while HashSet does not allow duplicates.
LinkedList uses pointers to connect elements, while HashSet uses a hash table for stori...
No, method overloading is not possible within a private class in Java.
Method overloading is achieved by having multiple methods in the same class with the same name but different parameters.
Private methods are not visible outside the class, so overloading them would not be useful.
If you need to achieve method overloading, the methods should be public or protected.
Dependency injection is a design pattern in which an object receives other objects that it depends on.
Constructor injection: Dependencies are provided through a class constructor.
Setter injection: Dependencies are set through setter methods.
Interface injection: Dependencies are set through an interface.
Example: In constructor injection, a class may have a constructor that takes the dependencies as parameters.
Dependency injection in Spring Boot allows objects to be injected into a class, promoting loose coupling and easier testing.
In Spring Boot, dependency injection is achieved through @Autowired annotation.
Dependencies are managed by the Spring container and injected into classes at runtime.
Constructor injection, setter injection, and field injection are common ways to inject dependencies in Spring Boot.
Example: @Autowire...
You can call a private method in another class by using reflection in Java.
Use the getDeclaredMethod() method from the Class class to get the private method
Set the accessibility of the private method to true using the setAccessible() method
Invoke the private method using the invoke() method
TreeMap in Java uses Red-Black tree for implementation.
TreeMap in Java uses Red-Black tree for implementation
Red-Black tree is a self-balancing binary search tree
Red-Black tree ensures logarithmic time complexity for operations like get, put, remove
Inversion of control is a design principle where the control flow of a program is inverted, with the framework or container calling the code instead of the code calling the framework.
Inversion of control allows for decoupling of components, making the code more modular and easier to maintain.
Common examples of inversion of control include dependency injection and event-driven programming.
Inversion of control is often u...
Difference between @RestController and @RequestMapping
RestController is a specialized version of @Controller that includes @ResponseBody by default
@RequestMapping is used to map web requests to specific handler methods
RestController is typically used for RESTful web services, while @RequestMapping can be used for any type of web request handling
HTTP requests in Java backend flow from client to server through various layers like servlets, filters, and controllers.
Client sends HTTP request to server
Request is received by servlet container (e.g. Tomcat)
Servlet container forwards request to appropriate servlet based on URL mapping
Servlet processes request and generates response
Response is sent back to client
Multiple catch blocks can be used to handle different types of exceptions in a try-catch block.
Multiple catch blocks can be used to handle different types of exceptions separately.
Each catch block can specify a different type of exception to catch.
The catch blocks are evaluated in order, so the most specific exception types should be caught first.
Using multiple catch blocks can make the code more readable and maintaina
Inheritance in Java allows a class to inherit properties and behaviors from another class.
Create a new class using the 'extends' keyword followed by the name of the class you want to inherit from
Use super keyword to call the constructor of the parent class
Child class can override methods from the parent class
Dependency injection is a design pattern used to remove hard-coded dependencies and make components more reusable and testable.
Allows for easier testing by injecting dependencies rather than hard-coding them
Promotes reusability of components by decoupling them from their dependencies
Improves maintainability by making it easier to swap out dependencies without changing the component's code
Streams represent a sequence of elements and support functional-style operations, while collections are data structures that store and manipulate groups of objects.
Streams are used for processing sequences of elements, while collections are used for storing and manipulating groups of objects.
Streams support functional-style operations like filter, map, reduce, while collections provide methods like add, remove, get.
Str...
To create a Spring Boot application, you can use Spring Initializr to generate a project with necessary dependencies and configurations.
Go to https://start.spring.io/
Select the project metadata like group, artifact, dependencies, etc.
Click on 'Generate' to download the project zip file.
Extract the zip file and import the project into your IDE.
Start coding your application logic.
Starter dependencies in Spring Boot are pre-configured dependencies that help in quickly setting up a Spring Boot project.
Starter dependencies are included in the pom.xml file of a Spring Boot project to provide necessary dependencies for specific functionalities.
They help in reducing the manual configuration required to set up a Spring Boot application.
Examples of starter dependencies include spring-boot-starter-web f...
A B-tree index is a data structure used in databases to efficiently store and retrieve data in sorted order.
B-tree indexes are commonly used in database management systems to speed up data retrieval operations.
They are balanced tree data structures that allow for efficient insertion, deletion, and search operations.
B-tree indexes are particularly useful for range queries and sequential access.
Example: In a database tab...
A trigger in SQL is a special type of stored procedure that is automatically executed when certain events occur in a database.
Triggers can be used to enforce business rules, maintain referential integrity, and automate repetitive tasks.
There are two main types of triggers in SQL: BEFORE triggers and AFTER triggers.
An example of a trigger is a BEFORE INSERT trigger that automatically sets a default value for a column if
ACID properties are a set of properties that guarantee the reliability of database transactions.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that either all operations in a transaction are completed successfully or none are.
Consistency ensures that the database remains in a consistent state before and after the transaction.
Isolation ensures that the concurrent execution of transac...
Types of joins in SQL include inner join, outer join (left, right, full), cross join, and self join.
Inner join: returns rows when there is a match in both tables based on the join condition.
Outer join: returns all rows from one table and only matching rows from the other table.
Left outer join: returns all rows from the left table and the matched rows from the right table.
Right outer join: returns all rows from the righ...
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by eliminating duplicate data
Normalization ensures data integrity by enforcing relationships between tables
There are different levels of normalization such as 1NF, 2NF, 3NF, and BCNF
Query to print CustomerID, CustomerName, OrderStatus, and TotalAmount excluding orders placed in August.
Join Customer and Order tables on CustomerID
Filter out orders placed in August using WHERE clause
Select CustomerID, CustomerName, OrderStatus, and TotalAmount columns
Retrieve data from a given URL using Java and Angular code.
Use Java's HttpURLConnection class to make a GET request to the URL and retrieve the data.
In Angular, use HttpClient module to send a GET request to the URL and fetch the data.
Parse the retrieved data in both Java and Angular to extract the required information.
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Dec 2024. There were 2 interview rounds.
Aptitude test consists of topics like percentages ,profits and loss like this they covered all the topics there is verbal ability also
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
Multiple MCQ questions and 1 coding test
I have worked on various projects ranging from e-commerce platforms to data visualization tools.
Developed a responsive e-commerce website using Angular, HTML, CSS, and Bootstrap.
Implemented data visualization features using D3.js for a financial analytics tool.
Integrated RESTful APIs to fetch and display real-time data in a dashboard application.
Optimized performance by implementing lazy loading and code splitting tech...
I have worked on Angular versions 2, 4, 6, 8, 10, and 12.
Worked on Angular 2, which introduced components, modules, services, and directives.
Experience with Angular 4, which focused on making the framework faster and smaller.
Familiar with Angular 6, which introduced Angular Elements and Angular CLI v6.
Proficient in Angular 8, which brought improvements in Ivy rendering engine and differential loading.
Hands-on experienc...
Sort and remove duplicates from an array of strings in JavaScript.
Use the Array.prototype.sort() method to sort the array.
Use the Set object to remove duplicates from the sorted array.
Convert the Set back to an array using the spread operator.
What people are saying about Infosys
Interview experience
based on 37.8k reviews
Rating in categories
Hyderabad / Secunderabad,
Chennai
+13-8 Yrs
Not Disclosed
Technology Analyst
56.2k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50k
salaries
| ₹2.8 L/yr - ₹9.2 L/yr |
System Engineer
39.2k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.4k
salaries
| ₹6.2 L/yr - ₹17 L/yr |
TCS
Wipro
Cognizant
Accenture