ICICI Lombard General Insurance Company Software Developer Interview Questions and Answers

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

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. Difference b/w map and array in CPP. What are generators in Python. What is Polynomial Regression? Normalisation in DBMS.
Ans. 
Map and array in CPP are both data structures, but map is a key-value pair container while array is a collection of elements with a fixed size.
• Map in CPP is a container that stores elements in key-value pairs, allowing fast lookups based on keys.

• Array in CPP is a collection of elements of the same data type, stored in contiguous memory locations.

• Generators in Python are functions that allow you to iterate over a sequen...read more
Answered by AI
Add your answer
Q2. Realtional Algebra in DBMS
Ans. 
Relational Algebra is a procedural query language used to query databases in DBMS.
• Relational Algebra is used to perform basic operations like selection, projection, join, etc. on relations.

• It helps in retrieving specific information from databases based on certain conditions.

• Examples of operations in Relational Algebra include Union, Intersection, Difference, Cartesian Product, etc.
Answered by AI
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

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

Practice everyday

Just share your basic thought about the topic but dont shout on Gd.

Q1. Basic questions they try to know whats your thought about currnent affairs and JD.
Add your answer
Q2. All about general insurance
Add your answer

Q1. Why should we hire you?
Add your answer