Care Health Insurance Underwriter Interview Questions and Answers

Do apply when advertisement came.Its prelims mains and interview process.

Quant reasoning english current affairs and financial awareness

Q1. Insurance related basic question
Add your answer
Q2. Current affairs related questions
Add your answer

Group discussion for my job selection

Q1. What is underwriting and how do you analyse the given details for better quotations
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. What is your family background?
Add your answer
Q5. Tell me about yourself.
Add your answer
Q6. Why are you looking for a change?
Add your answer

Related to insurance terms.

Q1. Asking about your role that how too handel .
Add your answer
Q2. Helath insurance underwriting question.
Add your answer

Q1. What do you know about insurance
Ans. 
Insurance is a financial product that provides protection against specific risks in exchange for payment of a premium.
• Insurance is a contract between an individual or entity and an insurance company.

• The individual or entity pays a premium to the insurance company in exchange for coverage against specific risks.

• Types of insurance include health insurance, life insurance, auto insurance, and property insurance.

• Insurance ...read more
Answered by AI
Add your answer

Q1. What do you like about HDFCergo
Add your answer

Q1. Difference between rank & dense rank
Ans. 
Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.
• Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

• For example, if there are two rows with the same value and rank 1, the n...read more
Answered by AI
Add your answer
Q2. Given two tables Tell how many values would be there for left right inner outer join
Ans. 
The number of values in different types of joins depends on the relationship between the tables.
• In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

• In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...read more
Answered by AI
Add your answer
Q3. Find the newest customer id for every product
Ans. 
Use SQL query to find the newest customer id for every product
• Use GROUP BY clause to group by product

• Use MAX() function to find the newest customer id for each product

• Join the tables if necessary
Answered by AI
Add your answer

Q1. Sql plsql and oracle
Add your answer

Q1. Sql plsql and oracle
Add your answer
Q2. Spa plsql and oracle
Add your answer