Infosys Consultant Interview Questions, Process, and Tips

Q1. Tell me about PO
Ans. 
PO stands for Purchase Order, a document issued by a buyer to a seller indicating types, quantities, and agreed prices for products or services.
• PO is a legally binding contract between the buyer and seller.

• It helps in tracking and managing orders, ensuring timely delivery of goods or services.

• POs are commonly used in business transactions to streamline the purchasing process.

• Example: A company issues a PO to a supplier...read more
Answered by AI
Add your answer
Q2. Tell me about PR
Add your answer

Q1. Current job roles and responsibilities
Add your answer

Q1. Explain architecture
Ans. 
Architecture refers to the design and structure of buildings or structures.
• Architecture involves planning, designing, and constructing buildings or structures

• It includes consideration of aesthetics, functionality, and sustainability

• Architects use various tools and techniques such as CAD software and building materials

• Examples of architecture include skyscrapers, bridges, and houses
Answered by AI
Add your answer
Q2. Talk about experience
Add your answer

Simple easy to do few general aptitude questions

Q1. Straight questions were asked from the cv
Add your answer
Q2. Tell me about yoursef
Add your answer
Q3. Why do you want to join infosys
Add your answer

Q1. Explain RAC in Oracle DB
Ans. 
RAC stands for Real Application Clusters, a feature in Oracle DB that allows multiple instances to access a single database simultaneously.
• RAC enables high availability by providing failover and load balancing capabilities.

• It allows for scalability by adding more nodes to the cluster.

• RAC requires shared storage, such as a SAN or NAS, to store database files accessible by all instances.

• Each node in the RAC cluster runs ...read more
Answered by AI
Add your answer
Q2. What is dataguard
Ans. 
DataGuard is a disaster recovery and high availability solution provided by Oracle for Oracle databases.
• DataGuard ensures data protection, high availability, and disaster recovery for Oracle databases.

• It involves creating standby databases that can be used in case of primary database failure.

• DataGuard can be configured in various modes such as Maximum Availability, Maximum Performance, and Maximum Protection.

• It allows ...read more
Answered by AI
Add your answer
Q3. Explain about awr reports
Ans. 
AWR reports are performance reports generated by Oracle database to analyze database performance.
• AWR reports provide detailed information on database performance over a period of time

• They include statistics on CPU usage, memory usage, I/O, and SQL statements

• AWR reports help identify performance bottlenecks and tune the database for optimal performance
Answered by AI
Add your answer
Q4. Different modes of datguard
Ans. 
Different modes of Data Guard include Maximum Performance, Maximum Availability, and Maximum Protection.
• Maximum Performance mode focuses on minimizing performance impact on the primary database

• Maximum Availability mode focuses on ensuring high availability of the standby database

• Maximum Protection mode focuses on ensuring zero data loss in case of a primary database failure
Answered by AI
Add your answer
Q5. Hardest issue faced
Ans. 
Managing a team with conflicting personalities and work styles
• Addressing communication issues between team members

• Implementing team-building activities to improve collaboration

• Providing individualized support and feedback to team members

• Resolving conflicts and mediating disagreements

• Adjusting management style to accommodate different personalities
Answered by AI
Add your answer

Quantitative reasoning

Tech abuse topic and electric vehicles