Infosys Interview Questions, Process, and Tips

Q1. Sap bw consultant
Ans. 
Based on requirement identified data source replicated into BW and if required made some enhancements. Knowledge on customized Data Sources using ABAP CDS Views and Data
Answered Anonymously
View 1 more answer
Q2. Sap bw4hana
Ans. 
Knowledge on customized Data Sources using ABAP CDS Views and Data sources enhancements in different areas like SAP SD and FICO
Answered Anonymously
View 1 more answer

Q1. Sap abap consultant
Ans. 
Knowledge on SAP ABAP CDS Views, Extended CDS View, Applied annotations based on requirement, arithmetic functions, case statements and where conditions
Answered Anonymously
View 1 more answer
Q2. Sap abap cds
Add your answer

Q1. Abap enhancement is in just basic
Add your answer
Q2. S4h
Add your answer

About ourself and what about me

Q1. Nth higest salary query in sql
Add your answer
Q2. Constraints
Add your answer
Q3. Delete drop truncate
Add your answer
Q4. Identity column
Add your answer
Q5. Ref and out
Add your answer
Q6. Polymorphism code
Add your answer
Q7. Inheritance, interface, abstract class,access modifiers, solid principles,design patterns
Add your answer
Q8. Remove duplicates from an array
Ans. 
Remove duplicates from an array of strings
• Create a Set to store unique elements

• Iterate through the array and add each element to the Set

• Convert the Set back to an array to get the unique elements
Answered by AI
Add your answer

Q1. Core Java questions
Add your answer
Q2. 3 Coding problems to solve
Add your answer

Q1. Worst thing was he started asking Devops questions to a Java Developer.
Add your answer
Q2. Why is your current company not utilizing a technology that I am familiar with, despite my ability to answer all related questions accurately?
Ans. 
Current company may have different priorities, budget constraints, existing systems, or may not see the immediate need for the technology.
• Different priorities: Company may be focusing on other projects or technologies that are deemed more important at the moment.

• Budget constraints: Implementing new technology can be costly and the company may not have the budget for it.

• Existing systems: Company may already have systems...read more
Answered by AI
Add your answer

An aptitude test is an assessment used to measure a person's abilities, skills, or potential in various areas. These tests are commonly used for academic evaluations, job placements, and competitive exams.

Types of Aptitude Tests

1. Numerical Reasoning – Assesses mathematical skills, data interpretation, and problem-solving ability.


2. Verbal Reasoning – Measures comprehension, grammar, and logical deduction from written material.


3. Logical Reasoning – Evaluates pattern recognition, sequences, and problem-solving skills.


4. Abstract Reasoning – Tests ability to analyze patterns, shapes, and logical sequences.


5. Spatial Reasoning – Measures ability to visualize objects and manipulate shapes in space.


6. Mechanical Reasoning – Evaluates understanding of physics, mechanics, and technical concepts.


7. Situational Judgment Test (SJT) – Assesses decision-making and problem-solving in workplace scenarios.


8. Data Interpretation – Involves analyzing charts, graphs, and tables for insights.


9. Personality Tests – Measures behavioral traits, work style, and psychological attributes.



Purpose of Aptitude Tests

Hiring & Recruitment – Used by employers to assess job fit.

Academic Assessments – Common in college entrance exams (SAT, GRE, GMAT).

Career Guidance – Helps individuals identify suitable career paths.

Promotions & Training – Used within companies for internal promotions.


How to Prepare for an Aptitude Test?

Practice past question papers.

Improve time management skills.

Strengthen basic math, logic, and verbal reasoning.

Use online mock tests and study guides.


Do you need details on a specific aptitude test?

An aptitude test is an assessment used to measure a person's abilities, skills, or potential in various areas. These tests are commonly used for academic evaluations, job placements, and competitive exams.

Types of Aptitude Tests

1. Numerical Reasoning – Assesses mathematical skills, data interpretation, and problem-solving ability.


2. Verbal Reasoning – Measures comprehension, grammar, and logical deduction from written material.


3. Logical Reasoning – Evaluates pattern recognition, sequences, and problem-solving skills.


4. Abstract Reasoning – Tests ability to analyze patterns, shapes, and logical sequences.


5. Spatial Reasoning – Measures ability to visualize objects and manipulate shapes in space.


6. Mechanical Reasoning – Evaluates understanding of physics, mechanics, and technical concepts.


7. Situational Judgment Test (SJT) – Assesses decision-making and problem-solving in workplace scenarios.


8. Data Interpretation – Involves analyzing charts, graphs, and tables for insights.


9. Personality Tests – Measures behavioral traits, work style, and psychological attributes.



Purpose of Aptitude Tests

Hiring & Recruitment – Used by employers to assess job fit.

Academic Assessments – Common in college entrance exams (SAT, GRE, GMAT).

Career Guidance – Helps individuals identify suitable career paths.

Promotions & Training – Used within companies for internal promotions.


How to Prepare for an Aptitude Test?

Practice past question papers.

Improve time management skills.

Strengthen basic math, logic, and verbal reasoning.

Use online mock tests and study guides.


Do you need details on a specific aptitude test?

Could you clarify what specific coding test you're referring to? There are many different types of coding tests, such as:

- **Technical interviews** from companies like Google, Amazon, or Microsoft
- **Online platforms** like LeetCode, HackerRank, or CodeSignal
- **University coding challenges** or competitive programming contests

Let me know what you're looking for, and I can provide details accordingly!

Could you clarify what you mean by "GD"? In many contexts, GD stands for **Group Discussion**, often used in recruitment or academic settings. If that's what you're referring to, here are some common details about Group Discussions (GD):

### Purpose:
- **Evaluate communication skills**: The GD is typically used to assess how well you express your thoughts and articulate them in a group.
- **Teamwork and leadership**: It's a good way to see how you collaborate with others, share ideas, and potentially lead the conversation.
- **Problem-solving ability**: In many cases, a GD will focus on current affairs or hypothetical situations to evaluate how well you analyze and come up with solutions.

### Format:
- **Topic Assignment**: Participants are given a topic (usually related to current affairs, technology, business, etc.).
- **Duration**: The GD might last from 15 to 30 minutes, depending on the group size.
- **Group Size**: Typically involves 6 to 10 participants.

### Common Evaluation Criteria:
1. **Communication Skills**: Clarity, confidence, and articulation.
2. **Team Interaction**: Listening skills, respecting others’ views, and contributing effectively.
3. **Knowledge**: Awareness of the topic and the ability to make relevant points.
4. **Leadership & Initiative**: Taking charge when needed or encouraging others to participate.
5. **Problem-Solving Ability**: Offering logical, well-thought-out solutions or perspectives.

### Tips for a Successful GD:
1. **Prepare for common topics**: Stay updated on current affairs and popular business trends.
2. **Participate actively**: Speak up, but don’t dominate the discussion. Allow others to express their views as well.
3. **Stay calm and composed**: Don’t interrupt others, and be respectful.
4. **Structure your thoughts**: Try to present your points logically, with examples when possible.
5. **Be a good listener**: Acknowledge other participants' ideas and build upon them.

Is this what you were referring to, or is there a different context for "GD"? Let me know if you need further clarification!

Q1. Question on LIST_AGGR
Add your answer
Q2. Question on dynamic SQL ,what is a bind variable
Add your answer
Q3. Question on constraints ,do we can delete a child table column having connection with foreign key with parent table
Add your answer
Q4. Triggers : do we can use commit or roll back with in trigger ?
Ans. 
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.
Answered by AI
Add your answer
Q5. Materialized views and how to refresh
Ans. 
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;
Answered by AI
Add your answer
Q6. Print 1 to 10 using sql
Ans. 
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
Answered by AI
Add your answer
Q7. What is Context switching ? And about collection types ...
Ans. 
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.
Answered by AI
Add your answer
Q8. Tell me about Analytical functions you worked on ?
Ans. 
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().
Answered by AI
Add your answer
Q9. What are Set operators ,which one keep duplicates among them
Ans. 
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
Answered by AI
Add your answer