Infosys Consulting Interview Questions, Process, and Tips

Developed a web-based student information system for a university

• Used PHP and MySQL for backend development

• Implemented user authentication and authorization

• Designed a responsive UI using Bootstrap framework

I am doing well, thank you.

• I am feeling healthy and energetic.

• I am excited about the opportunity to interview for the Consultant position.

• I have prepared thoroughly for this interview and am confident in my abilities.

• I am looking forward to discussing my qualifications and experiences with you.

SAP is an enterprise resource planning software that helps businesses manage various aspects of their operations.

• SAP stands for Systems, Applications, and Products in Data Processing.

• It is a software suite that integrates different modules to support various business functions.

• SAP FICO (Financial Accounting and Controlling) is a module within SAP that focuses on financial management and accounting processes.

• SAP provide...read more

General accounting refers to the process of recording, summarizing, and reporting financial transactions of an organization.

• General accounting involves recording all financial transactions of a company, such as sales, purchases, expenses, and payments.

• It includes the preparation of financial statements, such as the balance sheet, income statement, and cash flow statement.

• General accounting ensures compliance with accou...read more

Chart of accounts is a list of all the accounts used by an organization to record financial transactions.

• Chart of accounts is a structured list of general ledger accounts.

• It provides a framework for organizing financial transactions and generating financial statements.

• Each account in the chart of accounts represents a unique category of transactions.

• Accounts are classified into different groups such as assets, liabilit...read more

SAP stands for Systems, Applications, and Products in Data Processing.

• SAP is a software company that provides enterprise resource planning (ERP) solutions.

• SAP software is used by businesses to manage their operations and finances.

• SAP has various modules such as FICO, MM, SD, HR, etc. that cater to different business needs.

• SAP FICO is a module that deals with financial accounting and controlling.

• SAP is widely used in in...read more

JVM stands for Java Virtual Machine. It is responsible for executing Java bytecode.

• JVM is a part of the Java Runtime Environment (JRE)

• It interprets compiled Java code and executes it on the computer

• JVM provides platform independence to Java programs

• It manages memory allocation and garbage collection

• JVM also provides security by enforcing Java's security model

Function overloading is the ability to have multiple functions with the same name but different parameters.

• Functions with the same name but different parameters can be defined in the same scope

• The compiler determines which function to call based on the number and types of arguments passed

• Overloading can improve code readability and reduce code duplication

Query to display female count from emp table

• Use SELECT COUNT(*) to count the number of rows

• Use WHERE clause to filter for female employees

• Use the gender column in the emp table

Primary key is a unique identifier for a record in a database table.

• Primary key ensures data integrity by preventing duplicate records.

• It is used to establish relationships between tables in a database.

• Primary key can be a single column or a combination of columns.

• Examples of primary key include social security number, email address, etc.

3NF is a database normalization technique that eliminates redundant data.

• Each non-key attribute is dependent on the primary key

• No transitive dependencies between non-key attributes

• Reduces data redundancy and improves data integrity

• Example: A table with customer details and their orders can be normalized to 3NF