ICICI Lombard General Insurance Company Software Developer Interview Questions and Answers

Q1. Oops concept and c# basic questions for freshers and sql basics
Add your answer
Q2. What is .net framework
Ans. 
.NET Framework is a software framework developed by Microsoft that provides a runtime environment for building and running applications.
• .NET Framework is a platform for developing and running applications on Windows.

• It includes a large library of pre-built code and a runtime environment for executing applications.

• It supports multiple programming languages such as C#, VB.NET, and F#.

• It provides features like memory mana...read more
Answered by AI
Add your answer
Q3. Stored procesure insert update syntax
Add your answer
Q4. Oops questions inheritance constructors
Add your answer
Q5. Joins in sql and types
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• There are different types of joins in SQL: inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and the matching rows from the right table.

• Right join returns all the rows from the right table and the matching ...read more
Answered by AI
Add your answer

Q1. Basic oops concepts
Add your answer
Q2. Web api questions
Add your answer

Q1. What lib list ?
Ans. 
A list of libraries used in software development.
• Common libraries like React, Angular, jQuery

• Backend libraries like Express, Django, Spring

• Database libraries like Sequelize, SQLAlchemy, Hibernate
Answered by AI
Add your answer
Q2. What is Physical file
Ans. 
A physical file is a file stored on a physical storage device, such as a hard drive or solid-state drive.
• Physical files are stored on physical storage devices like hard drives or SSDs.

• They can be accessed and manipulated by software applications.

• Examples include text documents, images, videos, and executable programs.
Answered by AI
Add your answer

Q1. What is batch job
Ans. 
A batch job is a program that processes a large amount of data in a single run without user interaction.
• Batch jobs are typically scheduled to run at specific times, often during off-peak hours.

• They are commonly used for tasks such as data processing, report generation, and system maintenance.

• Examples of batch job tools include cron in Unix/Linux systems and Task Scheduler in Windows.
Answered by AI
Add your answer
Q2. What is interctive job
Ans. 
An interactive job is a task or project that requires active participation and engagement from the user.
• Interactive jobs involve real-time feedback and communication between the user and the system.

• Examples include video games, online surveys, and interactive websites.

• Users have control over the outcome of the task based on their input and decisions.
Answered by AI
Add your answer

Q1. What is pointer
Ans. 
A pointer is a variable that stores the memory address of another variable.
• Pointers are used to access and manipulate memory directly.

• They are commonly used in programming languages like C and C++.

• Example: int *ptr; // declares a pointer to an integer variable
Answered by AI
Add your answer

There were 5 sections which included one coding question, MCQs and one question on SQL

Q1. Introduce yourself
Add your answer
Q2. Two sum coding question with time and space complexity
Add your answer
Q3. Strong manipulation question with time and space complexity
Add your answer
Q4. What is a process and thread? (OS)
Ans. 
A process is an instance of a program running on a computer, while a thread is a unit of execution within a process.
• A process has its own memory space, while threads within the same process share memory.

• Processes are independent of each other, while threads within the same process can communicate with each other more easily.

• Processes are heavyweight in terms of resource consumption, while threads are lightweight.

• Exampl...read more
Answered by AI
Add your answer
Q5. OOPS based questions on polymorphism and the others
Add your answer
Q6. Why is the lid of the manhole round and not any other shape?
Ans. 
A round manhole lid cannot fall through the opening it covers, unlike other shapes.
• Round shape is the only shape that cannot fall through its own opening

• Round shape is easier to move and position compared to other shapes

• Round shape is more structurally sound and can support heavy loads evenly
Answered by AI
Add your answer

Q1. Introduce yourself
Add your answer
Q2. OSI model and what are the ones that are used particularly while real software development process takes place
Ans. 
The OSI model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven layers.
• The OSI model consists of seven layers: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• In real software development, layers commonly used are the Application layer, Transport layer, and sometimes the Network layer.

• For example, when developing a web applica...read more
Answered by AI
Add your answer
Q3. Favourite subject asked and questions were asked based on that.
Add your answer
Q4. Will I be able to work on multiple tech stacks?
Add your answer

Q1. Self introduction
Add your answer
Q2. If I'm holding any other offers
Add your answer
Q3. Professional background of my parents
Add your answer