Infosys Technology Analyst Interview Questions and Answers

A switch is a networking device that connects devices within a local area network (LAN) and forwards data packets between them.

• Switches operate at the data link layer of the OSI model.

• They use MAC addresses to forward data to the correct destination.

• Switches increase network performance by reducing collisions and segmenting traffic.

• Examples of switches include Cisco Catalyst series, Netgear ProSAFE series, and TP-...read more

Angular performance improvements involve optimizing code, reducing load times, and minimizing rendering cycles.

• Use lazy loading to only load components when needed

• Optimize change detection by using OnPush strategy

• Minimize DOM manipulation by using ngZone

• Implement server-side rendering for faster initial page load

• Use AOT (Ahead-of-Time) compilation to reduce bundle size

Boxing is the process of converting a value type to a reference type, while unboxing is the process of converting a reference type to a value type.

• Boxing is implicit, while unboxing is explicit.

• Boxing involves converting a value type to an object type, while unboxing involves extracting the value type from the object type.

• Boxing creates a new reference type object on the heap, while unboxing retrieves the original...read more

Analytic functions in SQL are used to perform calculations across a set of rows related to the current row.

• Common analytic functions include ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG.

• They can be used to calculate running totals, moving averages, and identify duplicates in a dataset.

• Analytic functions are typically used with the OVER() clause to define the window of rows to be used in the calculation.

Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.

• Rank leaves gaps between ranks if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each distinct row, while dense rank function is used to assign consecutive ranks to each distinct row

• Example: If we have values 10, 20, 20, 30 - Rank would assign ranks as 1, 2,...read more

Kersal server is a type of server used for hosting websites and applications.

• Kersal server is known for its reliability and performance.

• It is often used by businesses to host their websites and applications.

• Kersal server offers features like high uptime, security, and scalability.

• Examples of Kersal server providers include AWS, Google Cloud, and Microsoft Azure.

Dependency injection is a design pattern in which components are given their dependencies rather than creating them internally.

• Dependency injection helps in achieving loose coupling between classes.

• It allows for easier testing and maintenance of code.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

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