Infosys Interview Questions, Process, and Tips

Template is a single document or file, while template stack is a collection of templates organized in a hierarchy.

• Template is a standalone document or file used as a starting point for creating new documents.

• Template stack is a collection of templates organized in a hierarchy, where each template can inherit properties from templates above it.

• Template stack allows for easier management and consistency in document creat...read more

Values can be passed to a program through command line arguments, environment variables, configuration files, and user input.

• Command line arguments: Values can be passed to a program when it is executed from the command line.

• Environment variables: Values can be passed to a program through environment variables set in the operating system.

• Configuration files: Programs can read values from configuration files to customiz...read more

To find the 5th highest value of salary in the employee table, you can use SQL query with the ORDER BY and LIMIT clauses.

• Use SQL query with ORDER BY clause to sort the salaries in descending order

• Use LIMIT 4,1 to skip the first 4 highest salaries and get the 5th highest salary

Sort an array of strings based on a substring

• Use a custom comparator function to sort the array based on a specific substring

• Implement the comparator function to compare substrings of each string in the array

• Example: Sort array ['apple', 'banana', 'cherry'] based on substring 'an' -> ['banana', 'cherry', 'apple']

In COBOL, parm parameters can be accepted using the ACCEPT statement. The declaration structure includes the PICTURE clause.

• Use ACCEPT statement to accept parm parameter in COBOL

• Declare parm parameter using PICTURE clause in COBOL

• Example: ACCEPT parm-parameter

• Example: 01 parm-parameter PIC X(10)

Global variables are accessible throughout the entire program, while local variables are only accessible within a specific function or block of code.

• Global variables are declared outside of any function or block.

• Local variables are declared within a function or block and are only accessible within that function or block.

• Global variables can be accessed and modified by any part of the program.

• Local variables have limite...read more

Third party procurement process involves categorizing items for efficient usage and tracking.

• Item categories help in organizing and tracking purchases from third-party vendors.

• Usage of item categories ensures proper allocation of resources and budgeting.

• Examples of item categories include office supplies, IT equipment, and marketing materials.

Functional requirement gathering gaps can lead to issues in support projects. SAP SD Consultants play a crucial role in bridging these gaps.

• SAP SD Consultants need to ensure all functional requirements are clearly documented and understood by all stakeholders.

• They should actively engage with business users to gather detailed requirements and translate them into SAP SD solutions.

• Regular communication and collaboration w...read more

Open to relocation for the right opportunity

• Willing to relocate for the right job and career advancement

• Prefer locations with good work-life balance and opportunities for personal growth

• Flexible with location based on job requirements and company culture

I am a dedicated QA Engineer with 5 years of experience in testing web and mobile applications.

• Experienced in manual and automated testing

• Proficient in using testing tools like Selenium and Jira

• Strong understanding of software development lifecycle

• Excellent problem-solving skills

• Certified in ISTQB Foundation Level

I have 5 years of automation experience using tools like Selenium, Appium, and JUnit.

• Developed automated test scripts for web applications using Selenium WebDriver

• Implemented mobile automation testing using Appium for iOS and Android apps

• Utilized JUnit for unit testing and integration testing of Java applications

• Integrated automation tests into CI/CD pipelines for continuous testing

• Experience with test automation frame

I am a dedicated QA Engineer with 5 years of experience in testing web and mobile applications.

• Experienced in manual and automated testing

• Proficient in using testing tools such as Selenium and Jira

• Strong understanding of software development lifecycle

• Excellent problem-solving skills

• Certified in ISTQB Foundation Level

I am a dedicated QA Engineer with 5 years of experience in testing web and mobile applications.

• Experienced in manual and automated testing

• Proficient in using testing tools like Selenium and Jira

• Strong understanding of software development lifecycle

• Excellent problem-solving skills

• Certified in ISTQB Foundation Level

Use a self-join query to delete duplicates from the same table.

• Use a self-join query to identify the duplicate records based on a unique identifier column.

• Delete the duplicate records using the DELETE statement with the self-join condition.

Query to display 5th max salary in a table

• Use the RANK() function to assign a rank to each salary

• Filter the results to only show the row with rank 5

• Order the salaries in descending order to get the 5th max salary

A cursor is a pointer to a result set for a SQL query. It allows you to iterate through the rows of the result set.

• Cursors are used in PL/SQL to process individual rows returned by a query.

• Attributes of a cursor include %NOTFOUND, %FOUND, %ROWCOUNT, and %ISOPEN.

• Example: OPEN cursor_name; FETCH cursor_name INTO variable; CLOSE cursor_name;

Exception handling is a mechanism to handle errors or unexpected events in a program.

• Syntax: BEGIN -- code block EXCEPTION -- exception handling block END;

• Exceptions can be predefined or user-defined

• Common predefined exceptions include NO_DATA_FOUND, TOO_MANY_ROWS, etc.

• User-defined exceptions can be declared using the EXCEPTION keyword

Performance tuning is the process of optimizing the speed and efficiency of a system or application.

• Identifying and resolving bottlenecks in the system

• Optimizing SQL queries and database design

• Improving code efficiency and reducing resource usage

• Monitoring system performance and making adjustments as needed

Merge statement in PL/SQL combines insert and update operations based on a condition.

• Use MERGE INTO statement followed by target table name

• Specify USING clause with source table or subquery

• Define ON condition to match rows for update or insert

• Use WHEN MATCHED THEN UPDATE SET for update operation

• Use WHEN NOT MATCHED THEN INSERT VALUES for insert operation

Triggers are PL/SQL blocks that are automatically executed when certain events occur on a table.

• Triggers can be used to enforce business rules, audit changes, or maintain data integrity.

• Syntax: CREATE OR REPLACE TRIGGER trigger_name BEFORE/AFTER INSERT/UPDATE/DELETE ON table_name FOR EACH ROW BEGIN -- trigger logic here END;