Infosys Interview Questions, Process, and Tips for Experienced

Object-oriented programming concept that focuses on organizing code into objects with properties and behaviors.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Inheritance: Allowing a class to inherit properties and methods from another class.

• Polymorphism: Ability for objects to take on different forms or behaviors based on their data type.

• Abstraction: Hiding complex implementation d...read more

Slowly Changing Dimensions (SCD) are used in data warehousing to track changes to data over time. Types include Type 1, Type 2, and Type 3.

• Type 1 SCD: Overwrites old data with new data, losing historical information.

• Type 2 SCD: Creates a new record for each change, preserving historical data.

• Type 3 SCD: Tracks changes by adding columns to the existing record, allowing for limited historical analysis.

Use the GROUP BY clause with COUNT() function to find duplicates in SQL.

• Use GROUP BY clause with COUNT() function to group the records by the columns you want to check for duplicates

• Filter the results by using HAVING clause to only show records with count greater than 1

• Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1;

Test Case is a detailed set of conditions and steps to be followed to validate a particular functionality, while Test Scenario is a high-level description of the functionality to be tested.

• Test Case is detailed and specific, while Test Scenario is high-level and general.

• Test Case includes steps, expected results, and test data, while Test Scenario is more of an overview.

• Test Case is used for detailed testing, while Tes...read more

Bug life cycle is the process of a bug from identification to resolution in software testing.

• Bug is identified by tester

• Bug is reported in bug tracking tool

• Bug is assigned to developer

• Developer fixes the bug

• Bug is retested by tester

• Bug is closed if fixed or reopened if not

SDLC stands for Software Development Life Cycle, a process used to design, develop, and test software applications.

• SDLC is a systematic process for building software applications.

• It includes phases like planning, design, development, testing, deployment, and maintenance.

• Examples of SDLC models include Waterfall, Agile, and DevOps.

• Each phase in SDLC has specific goals and deliverables to ensure the quality of the softwa

STLC stands for Software Testing Life Cycle, which is a series of steps performed in a specific sequence to ensure the quality of software.

• STLC is a process followed by software testers to ensure the quality of the software being developed.

• It includes phases like requirement analysis, test planning, test design, test execution, and test closure.

• Each phase has specific activities and deliverables that need to be complet...read more

Subcon process refers to subcontracting process where a company outsources part of its manufacturing process to a third-party vendor.

• Subcon process involves sending raw materials to a subcontractor for processing or assembly.

• The subcontractor then returns the finished goods to the company.

• The company pays the subcontractor for the services rendered.

• Subcon process helps companies focus on core competencies and reduce co...read more

To write a custom exception in Java, create a new class that extends Exception or a subclass of Exception.

• Create a new class that extends Exception or a subclass of Exception.

• Add a constructor to the custom exception class to pass a message to the superclass constructor.

• Throw the custom exception using the 'throw' keyword in your code.

• Handle the custom exception using try-catch blocks or propagate it up the call stack.

HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.

• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to find the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To retrieve a value, the key is hashed again to find th...read more