Infosys Technical Lead Interview Questions, Process, and Tips

Q1. Types of indexes and use of them
Ans. 
Indexes in databases help improve query performance by allowing faster data retrieval.
• Types of indexes include B-tree, hash, and bitmap indexes.

• B-tree indexes are commonly used for range queries.

• Hash indexes are useful for equality queries.

• Bitmap indexes are efficient for low cardinality columns.

• Indexes should be used judiciously to avoid overhead during data modification.
Answered by AI
Add your answer

Q1. Basic things about SQL, Python,AWS
Add your answer

Canditates should be share screen and type algorithm and codings

Q1. Discussion about salary
Add your answer

Q1. Basics like about yourself and few technical concepts in java
Add your answer

Q1. Only 1 round for top tier companies
Add your answer

Q1. Concept s of C++ and programs on polymorphism
Ans. 
Polymorphism in C++ allows objects of different classes to be treated as objects of a common superclass.
• Polymorphism is achieved through function overloading and overriding.

• Function overloading allows multiple functions with the same name but different parameters.

• Function overriding involves redefining a base class function in a derived class.

• Example: virtual functions in C++ enable polymorphism by allowing derived cla
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer

Q1. Tell me one of your tough situations and how did you handle it
Add your answer

It was a regular exp related question