Tata AIA Life Insurance Manager Interview Questions and Answers for Freshers

Q1. BM interview. Self introduction. About company details. Job profile. Job description
Add your answer

About pnb. Methamatics test, general knowledge

Q1. Self introduction, about privious company experience,
Add your answer

Q1. I'm looking for BM possition
Add your answer
Q2. I'm capable to handle a team and drive them to achieve sales targets which is assigned by the management team
Add your answer
Q3. Good knowledge about insurance business
Add your answer
Q4. Working with agency channel and recruiting a great Distribution.
Add your answer
Q5. To Qualifying and inteligent sales managers i have
Add your answer
Q6. I am capable to handle objection and questions and answers all the queries
Add your answer

Q1. Technical Discussion about Product
Add your answer

Q1. Technical & General Discussion about possible product migration
Add your answer

Q1. Generic HR questions
Add your answer

Q1. The output of 4 joins and how the processing happens?
Ans. 
The output of 4 joins is a result set that combines data from multiple tables based on specified conditions.
• Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Processing of joins involves matching rows from the tables based on the specified join condition.

• The output of 4 joins would involve combining data ...read more
Answered by AI
Add your answer
Q2. Spark Parameters calculation
Add your answer
Q3. Self Joins between the table with CTE
Ans. 
Self joins between tables with CTE are used to join a table to itself using Common Table Expressions.
• Self joins are used when you need to compare rows within the same table.

• CTE is used to create a temporary result set that can be referenced multiple times in a query.

• Example: SELECT e1.employee_id, e2.manager_id FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Answered by AI
Add your answer
Q4. Optimizations in Spark
Ans. 
Optimizations in Spark involve tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
• Tune configurations for memory and parallelism

• Partition data to distribute workload evenly

• Use efficient transformations like map, filter, and reduce

• Cache intermediate results to avoid recomputation
Answered by AI
Add your answer

Q1. Explain your project and your role
Add your answer
Q2. Data Model Interview questions
Add your answer
Q3. Problem Solving Approach on few scenarios
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. What is marginal costing
Ans. 
Marginal costing is a technique of costing in which only variable costs are considered for decision making.
• Marginal costing helps in determining the contribution margin of a product or service.

• It is useful in short-term decision making such as pricing, make or buy decisions, etc.

• Fixed costs are not considered in marginal costing as they are assumed to remain constant.

• It is also known as direct costing or variable costi...read more
Answered by AI
Add your answer
Q2. What is term plan in insurance
Ans. 
Term plan is a type of life insurance policy that provides coverage for a specific period of time.
• Term plan provides financial protection to the policyholder's family in case of their untimely demise

• Premiums for term plans are generally lower compared to other types of life insurance policies

• Term plans do not offer any maturity benefits if the policyholder survives the policy term

• Policyholders can choose the policy ter...read more
Answered by AI
View 1 more answer

Q1. What is internal audit
Ans. 
Internal audit is an independent, objective assurance and consulting activity designed to add value and improve an organization's operations.
• Internal audit evaluates the effectiveness of an organization's risk management, control, and governance processes.

• It provides recommendations for improvement and helps the organization accomplish its objectives.

• Examples of internal audit activities include financial audits, opera...read more
Answered by AI
Add your answer

Q1. General questions aksed no details interview
Add your answer
Q2. Reason for change and more abt job
Add your answer

Q1. Yes more questions asked
Add your answer

Q1. Experience related
Add your answer