Infosys Interview Questions, Process, and Tips

Q1. Introduce yourself
Ans. 
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in conducting market research and analyzing trends

• Skilled in creating detailed reports and presentations for stakeholders

• Proficient in using data analysis tools such as Excel and SQL
Answered by AI
Add your answer
Q2. Defference between Implicit And Explicit enhancement
Ans. 
Implicit enhancements are enhancements that are automatically applied to a program without any explicit coding, while explicit enhancements are enhancements that are manually added to a program through coding.
• Implicit enhancements are activated by SAP without any additional coding from the developer.

• Explicit enhancements require the developer to manually add code to enhance the program.

• Implicit enhancements are often u...read more
Answered by AI
Add your answer
Q3. What defferet type of enhancement and explain each
Ans. 
Different types of enhancements include functional, performance, security, and usability enhancements.
• Functional enhancements improve the core functionality of a system or product.

• Performance enhancements focus on improving speed, efficiency, and scalability.

• Security enhancements aim to protect the system from potential threats and vulnerabilities.

• Usability enhancements enhance the user experience and make the system m
Answered by AI
Add your answer
Q4. How to debug backgroud job
Ans. 
Debugging background jobs involves checking logs, monitoring job status, and using debugging tools.
• Check the logs for any error messages or warnings

• Monitor the job status to see if it is running or stuck

• Use debugging tools like debugger or profiler to analyze the code execution

• Check for any dependencies or external factors affecting the job
Answered by AI
Add your answer
Q5. How debug smartforms
Ans. 
Debugging smartforms involves identifying and fixing errors in the form design or code.
• Check for syntax errors in the smartform code

• Verify data binding and field mappings

• Use debugging tools like breakpoints and watchpoints

• Test the smartform with sample data to identify issues

• Consult documentation or seek help from experienced developers
Answered by AI
Add your answer
Q6. Which bapi you have used
Ans. 
I have used the BAPI_MATERIAL_GET_DETAIL to retrieve material details in SAP system.
• BAPI_MATERIAL_GET_DETAIL is used to fetch material master data in SAP

• It can be used to retrieve information such as material description, unit of measure, and plant data

• Example: BAPI_MATERIAL_GET_DETAIL('MaterialNumber')
Answered by AI
Add your answer
Q7. What is file handling
Ans. 
File handling is the process of managing and manipulating files on a computer system.
• File handling involves tasks such as creating, reading, writing, and deleting files.

• It also includes operations like opening and closing files, as well as moving and copying files.

• Examples of file handling functions include fopen(), fread(), fwrite(), and fclose() in programming languages like C or Python.
Answered by AI
Add your answer
Q8. Which FM is used to upload data
Ans. 
The FM used to upload data is 'UPLOAD_DATA'
• The FM 'UPLOAD_DATA' is commonly used in SAP systems to upload data from external sources

• It is often used in data migration projects or when bulk data needs to be imported into the system

• The 'UPLOAD_DATA' FM typically requires input parameters such as file path, data format, and target table
Answered by AI
Add your answer
Q9. TMG events senario question
Add your answer
Q10. How ro make table feild case sensitive
Ans. 
To make a table field case sensitive, you can change the collation of the column to a case-sensitive collation.
• Change the collation of the column to a case-sensitive collation like Latin1_General_CS or SQL_Latin1_General_CP1_CS_AS

• For example, ALTER TABLE table_name ALTER COLUMN column_name COLLATE Latin1_General_CS_AS
Answered by AI
Add your answer
Q11. Why we need to use BSPI instead od Update qury
Ans. 
BSPI is used instead of Update query for real-time data processing and to ensure data consistency.
• BSPI (Business Service Provider Interface) is used for real-time data processing in SAP systems.

• BSPI ensures data consistency by providing a standardized way to update data across different systems.

• Update queries can be risky for real-time data processing as they may lead to data inconsistencies.

• BSPI allows for better erro...read more
Answered by AI
Add your answer

Q1. Introduce yourself
Ans. 
I am a detail-oriented business analyst with experience in data analysis and process improvement.
• Experienced in data analysis and reporting

• Skilled in process improvement and optimization

• Strong attention to detail and problem-solving skills
Answered by AI
Add your answer
Q2. What is the defference between Explicit and implicit enhancement
Ans. 
Explicit enhancements are modifications made directly to a standard SAP object, while implicit enhancements are modifications made using enhancement points provided by SAP.
• Explicit enhancements involve directly modifying the standard SAP object code.

• Implicit enhancements involve using enhancement points provided by SAP to add custom code.

• Explicit enhancements can be risky as they may be overwritten during system upgrad...read more
Answered by AI
Add your answer
Q3. Explain Customer Exit requirements on which u worked
Ans. 
Customer Exit requirements involve defining conditions under which a customer can end their relationship with a company.
• Identifying reasons why customers may want to exit the relationship

• Defining the process for customers to formally request an exit

• Determining any penalties or fees associated with exiting

• Ensuring data privacy and security during the exit process

• Developing strategies to retain customers before they exit
Answered by AI
Add your answer
Q4. Different type of FM
Ans. 
FM stands for Facilities Management, which includes various types such as Hard FM and Soft FM.
• Hard FM involves physical assets like buildings and equipment maintenance.

• Soft FM focuses on non-physical assets like cleaning, security, and catering services.

• Other types include Integrated FM, Total FM, and Strategic FM.

• Examples: Hard FM - HVAC maintenance, Soft FM - janitorial services.
Answered by AI
Add your answer
Q5. How to create BAPI
Ans. 
BAPIs are created using transaction code BAPI in SAP system.
• BAPIs are created using transaction code BAPI in SAP system.

• BAPIs are defined using Function Modules in SAP.

• BAPIs are used to integrate SAP systems with external systems.

• BAPIs can be created for both standard SAP functions and custom functions.
Answered by AI
Add your answer
Q6. Tcode for code optimization
Ans. 
Tcode for code optimization is SE30 in SAP
• SE30 is a transaction code in SAP used for performance trace and analysis

• It helps in identifying performance bottlenecks in ABAP code

• SE30 provides detailed analysis of runtime, database, and memory consumption
Answered by AI
Add your answer
Q7. How to optimize code
Ans. 
Code optimization involves improving code efficiency and performance.
• Identify and remove unnecessary code

• Use efficient data structures and algorithms

• Minimize the number of function calls

• Optimize loops and conditional statements

• Use caching and memoization techniques

• Profile and analyze code for bottlenecks
Answered by AI
Add your answer
Q8. Tcode for ADOBE Form
Ans. 
The Tcode for ADOBE Form is SFP.
• Tcode SFP is used to create and maintain Adobe Forms in SAP systems.

• Adobe Forms are used for designing and formatting business documents like invoices, purchase orders, etc.
Answered by AI
Add your answer
Q9. Have you worked on Module Pool
Ans. 
Yes, I have worked on Module Pool in SAP ABAP development.
• I have experience creating interactive screens using Module Pool programming in SAP ABAP.

• I have worked on designing screens with input fields, buttons, and logic to process user input.

• I have implemented navigation between screens and data validation in Module Pool.

• I have integrated Module Pool programs with backend ABAP logic for data processing.

• I have experienc...read more
Answered by AI
Add your answer
Q10. Tcodes related to IDOC
Add your answer
Q11. What is the use of Commite statement
Ans. 
Commit statement is used to permanently save changes made in a transaction in a database.
• Commits all changes made in a transaction to the database

• Permanently saves the changes

• Ends the transaction and makes the changes visible to other transactions
Answered by AI
Add your answer
Q12. On which repprys u have worked
Add your answer

Q1. Why there is gap of 1 year after completing your graduation to getting job
Ans. 
To gain practical experience and skills through internships, certifications, and volunteer work before securing a full-time job.
• Took time to gain practical experience through internships, certifications, and volunteer work

• Focused on developing skills and knowledge in relevant areas

• Used the gap year to explore different career options and industries

• Took time to travel or pursue personal interests before committing to a
Answered by AI
Add your answer
Q2. Preferred location
Ans. 
I am open to relocation for the right opportunity.
• Open to relocation for career growth

• Interested in exploring new cities

• Flexible with location preferences
Answered by AI
Add your answer
Q3. Salary discussion
Add your answer

Q1. What is paython
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is an interpreted language, meaning code is executed line by line.

• It supports multiple programming paradigms like object-oriented, imperative, and functional programming.

• Python has a large standard library and a thriving community with numerous third-party libraries.

• Popular frameworks like Django and Flask are built using Python...read more
Answered by AI
Add your answer
Q2. What is oops concepts
Ans. 
Object-oriented programming concepts that focus on classes and objects.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation details and showing only the necessary features.
Answered by AI
Add your answer

Aptitude test questions

Q1. What is machine learning
Ans. 
Machine learning is a branch of artificial intelligence that involves developing algorithms and models that can learn from and make predictions or decisions based on data.
• Machine learning is a subset of artificial intelligence that focuses on developing algorithms that can learn from and make predictions or decisions based on data.

• It involves training models on large datasets to recognize patterns and make predictions ...read more
Answered by AI
Add your answer
Q2. Machine learning example
Ans. 
An example of machine learning is training a model to predict customer churn in a telecom company.
• Collect and preprocess data on customer behavior and churn

• Split data into training and testing sets

• Choose a machine learning algorithm (e.g. logistic regression)

• Train the model on the training data

• Evaluate the model's performance on the testing data

• Use the model to predict customer churn in the future
Answered by AI
Add your answer

Aptitude test questions

Q1. What is artificial intelligence
Ans. 
Artificial intelligence is the simulation of human intelligence processes by machines, especially computer systems.
• AI involves machines performing tasks that typically require human intelligence, such as visual perception, speech recognition, decision-making, and language translation.

• Machine learning is a subset of AI that allows machines to learn from data and improve their performance over time.

• Examples of AI include...read more
Answered by AI
Add your answer
Q2. Type of artificial intelligence
Ans. 
There are three types of artificial intelligence: narrow AI, general AI, and superintelligent AI.
• Narrow AI, also known as weak AI, is designed for a specific task or set of tasks, such as facial recognition or language translation.

• General AI, also known as strong AI, is able to perform any intellectual task that a human can do.

• Superintelligent AI is hypothetical and would surpass human intelligence in every way.

• Example...read more
Answered by AI
Add your answer

Q1. Some deep question on stream API of Java8
Add your answer
Q2. Two program questions -> Anagram String and find first non repeating character from a string
Add your answer

Q1. Questions on Product development phases
Add your answer
Q2. Questions on Agile methodologies
Add your answer

Q1. How snowflake differs from industry competetors? What is the extra edge?
Ans. 
Snowflake offers a unique architecture that separates storage and compute, providing scalability, flexibility, and cost-effectiveness.
• Snowflake's architecture separates storage and compute, allowing for independent scaling of each component.

• Snowflake uses virtual warehouses to allocate compute resources on-demand, optimizing performance and cost.

• Snowflake's multi-cluster shared data architecture enables seamless collab...read more
Answered by AI
Add your answer
Q2. 3 Sql problem statements with basic problem statement. Concepts like view table, window function, sequence generation, Rank transformation.
Add your answer
Q3. Difference between time travel and fail safe.
Ans. 
Time travel refers to the ability to query historical data in Snowflake, while fail safe refers to the system's ability to maintain data integrity and availability in case of failures.
• Time travel allows users to query data as it existed at a specific point in the past, using the TIMESTAMP parameter in queries.

• Fail safe mechanisms in Snowflake ensure data integrity and availability by automatically handling system failu...read more
Answered by AI
Add your answer
Q4. Difference between live feed and extract.
Ans. 
Live feed is real-time data while extract is historical data.
• Live feed is data that is constantly updated in real-time.

• Extract is historical data that is extracted at a specific point in time.

• Live feed is commonly used for monitoring real-time events, while extract is used for analysis of past data.

• Examples: Twitter feed is live data, while a monthly sales report is an extract.
Answered by AI
Add your answer
Q5. Difference between Join and data Blending
Ans. 
Join combines data from two or more tables based on a related column, while data blending combines data from different sources without a direct relationship.
• Join is used to combine data from multiple tables based on a common column.

• Data blending is used to combine data from different sources without a direct relationship.

• Join requires a common column to match records, while data blending does not require a common colum...read more
Answered by AI
Add your answer

Q1. What is the difference between static and dynamic calls?
Ans. 
Static calls are resolved at compile time, while dynamic calls are resolved at runtime.
• Static calls are resolved at compile time based on the declared type of the object being called.

• Dynamic calls are resolved at runtime based on the actual type of the object being called.

• Static calls are faster but less flexible, while dynamic calls are slower but more flexible.

• Example: In a static call, the method to be called is det...read more
Answered by AI
Add your answer
Q2. How to get control over job execution?
Ans. 
Control over job execution can be achieved through job scheduling, monitoring, and automation.
• Use job scheduling tools like Control-M or CA Workload Automation to manage job execution.

• Monitor job progress and status using tools like IBM Tivoli Monitoring or Nagios.

• Automate job execution and error handling with scripts or custom programs.

• Implement job dependencies to ensure proper sequencing and execution.

• Set up alerts
Answered by AI
Add your answer
Q3. What is a cursor in the context of databases, and what purposes does it serve?
Ans. 
A cursor in databases is a pointer that allows for traversal and manipulation of query results.
• A cursor is used to retrieve and process individual rows returned by a query.

• It allows for sequential access to query results, enabling operations like fetching, updating, and deleting rows.

• Cursors are commonly used in programming languages like SQL to work with result sets.

• For example, in a banking application, a cursor can ...read more
Answered by AI
Add your answer
Q4. How can null variables be handled in COBOL DB2 programs?
Ans. 
Null variables in COBOL DB2 programs can be handled using NULL indicators and COALESCE function.
• Use NULL indicators to check if a variable is null before processing it.

• Use COALESCE function to replace null values with a default value.

• Handle null variables carefully to avoid runtime errors.
Answered by AI
Add your answer

Q1. What is the waterfall model in software development?
Ans. 
The waterfall model is a linear sequential software development process where progress flows in one direction like a waterfall.
• Involves distinct phases such as requirements, design, implementation, testing, and maintenance.

• Each phase must be completed before moving on to the next phase.

• Changes are difficult to implement once a phase is completed.

• Example: Traditional software development approach where requirements are ...read more
Answered by AI
Add your answer
Q2. What is the Agile framework?
Ans. 
Agile framework is a project management approach that emphasizes flexibility, collaboration, and incremental development.
• Agile framework involves breaking down projects into smaller tasks called sprints

• It promotes frequent communication and collaboration among team members

• Allows for flexibility and adaptability to changes in requirements

• Examples of Agile frameworks include Scrum, Kanban, and Extreme Programming
Answered by AI
Add your answer

Q1. Discussion on CTC, work location and project.
Add your answer

The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your internship experience?
Ans. 
I completed a 6-month internship at a tech company, where I worked on network infrastructure projects.
• Assisted in setting up and configuring network devices such as routers and switches

• Troubleshooted network issues and implemented solutions

• Collaborated with team members on various IT projects

• Participated in meetings with clients to discuss project requirements
Answered by AI
Add your answer
Q3. Given a puzzle to solve
Add your answer
Q4. What can you tell me about your major projects?
Ans. 
I have worked on various major projects including designing and implementing network infrastructure, developing automation scripts, and optimizing system performance.
• Designed and implemented a new network infrastructure for a large company, improving network speed and reliability

• Developed automation scripts to streamline system monitoring and maintenance tasks, saving time and reducing errors

• Optimized system performanc...read more
Answered by AI
Add your answer
Q5. What is the latest news you have heard regarding technology?
Ans. 
The latest news I heard regarding technology is the release of the new iPhone 13 with improved camera features.
• Apple recently announced the release of the iPhone 13 series with upgraded camera capabilities.

• The new iPhone 13 models come with improved low-light performance and cinematic mode for videos.

• Apple also introduced the A15 Bionic chip for enhanced performance and battery life.
Answered by AI
Add your answer

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Ans. 
Use SQL query with MAX function to retrieve person with highest salary.
• Use SELECT statement to retrieve data

• Use MAX function to find the highest salary

• Use WHERE clause to filter out the person with highest salary
Answered by AI
Add your answer
Q2. Can you describe the projects you have worked on?
Ans. 
I have worked on projects involving network infrastructure upgrades, cloud migration, and cybersecurity enhancements.
• Upgraded network infrastructure to improve performance and reliability

• Migrated on-premise systems to the cloud for increased scalability and cost savings

• Implemented cybersecurity measures such as firewalls and intrusion detection systems

• Developed disaster recovery plans to ensure business continuity in c
Answered by AI
Add your answer
Q3. Write a query to merge 2 tables?
Ans. 
Merge 2 tables using SQL query
• Use the JOIN keyword to combine rows from both tables based on a related column

• Specify the columns to be selected from each table

• Use different types of joins like INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL JOIN based on the requirement
Answered by AI
Add your answer
Q4. Tell me about the internship that you have done?
Ans. 
I completed a system engineering internship at XYZ Company, where I worked on designing and implementing network infrastructure.
• Worked on configuring routers and switches

• Assisted in troubleshooting network issues

• Collaborated with team members on project planning and execution
Answered by AI
Add your answer
Q5. Behavioural questions
Add your answer