i2e Consulting Interview Questions and Answers for Freshers

The process of loans involves application, approval, disbursement, and repayment.

• Application: Borrower submits loan application with required documents.

• Approval: Lender reviews application, checks creditworthiness, and decides whether to approve or deny.

• Disbursement: If approved, funds are disbursed to borrower.

• Repayment: Borrower makes scheduled payments to repay the loan amount.

• Examples: Personal loans, home loans, c

Defect life cycle is the process of identifying, reporting, fixing, retesting, and closing defects in a software application.

• Defect identification: Defects are identified by testers during testing.

• Defect reporting: Testers report defects in a defect tracking tool.

• Defect fixing: Developers fix the reported defects.

• Defect retesting: Testers retest the fixed defects to ensure they are resolved.

• Defect closing: Once the def

Sanity testing is a quick test to check if the software is stable, smoke testing is a subset of sanity testing focusing on critical functionalities, and regression testing is retesting after code changes.

• Sanity testing is a narrow and deep testing to ensure that the most critical functionalities work correctly after changes.

• Smoke testing is a broad and shallow testing to ensure that the basic functionalities work befor...read more

Different types of https methods in api testing include GET, POST, PUT, DELETE, PATCH, OPTIONS, HEAD.

• GET - Used to retrieve data from the server

• POST - Used to submit data to the server

• PUT - Used to update existing data on the server

• DELETE - Used to delete data on the server

• PATCH - Used to partially update data on the server

• OPTIONS - Used to check what HTTP methods are supported by the server

• HEAD - Used to retrieve head

OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.

• OOPs focuses on creating objects that contain data and methods to manipulate that data.

• It involves concepts like inheritance, encapsulation, polymorphism, and abstraction.

• Example: Inheritance allows a class to inherit properties and methods from another class, promoting code reusability.

Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.

• Allows a class to reuse code from another class

• Promotes code reusability and reduces redundancy

• Derived class inherits members from base class

• Example: Class Car can inherit properties and methods from class Vehicle

Types of inheritance in .NET include single, multiple, multilevel, hierarchical, and hybrid inheritance.

• Single inheritance: A class can inherit from only one base class.

• Multiple inheritance: A class can inherit from multiple base classes (not supported in C#).

• Multilevel inheritance: A class can inherit from a derived class, creating a hierarchy of classes.

• Hierarchical inheritance: Multiple classes can inherit from a si...read more

Primary key uniquely identifies each record in a table, while unique key ensures each value in a column is unique.

• Primary key does not allow NULL values, while unique key allows one NULL value.

• A table can have only one primary key, but multiple unique keys.

• Primary key is automatically indexed, while unique key may or may not be indexed.

• Example: Primary key for a 'Students' table could be 'StudentID', while unique key c

Structured Query Language (SQL) is a standard language for managing and manipulating databases.

• SQL is used to communicate with databases to perform tasks like querying data, updating records, and creating tables.

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE, and CREATE.

• SQL is not case-sensitive, but it is conventionally written in uppercase for keywords and lowercase for table and column names.

Printing odd numbers from a given list or range.

• Iterate through the list or range of numbers

• Check if each number is odd by using the modulo operator (%)

• Print the odd numbers