ICICI Prudential Life Insurance Software Developer Interview Questions and Answers

Profit loss , number system, code decode

Q1. What is DDL, DML, DQL
Ans. 
DDL stands for Data Definition Language, DML stands for Data Manipulation Language, and DQL stands for Data Query Language.
• DDL is used to define the structure of database objects such as tables, indexes, and views.

• DML is used to manipulate data in the database, such as inserting, updating, and deleting records.

• DQL is used to retrieve data from the database using queries.

• Examples: CREATE TABLE is a DDL statement, INSERT...read more
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

Q1. C#,Asp.net ,SQL server,Asp.net MVC
Add your answer