Aegon Life Insurance Interview Questions and Answers

5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min

Q1. How do you seperate name from emails for example *****,***** etc.. We need to get name form those mails in sql
Ans. 
Use SQL string functions like SUBSTRING and CHARINDEX to separate name from emails.
• Use CHARINDEX to find the position of the '@' symbol in the email address.

• Use SUBSTRING to extract the characters before the '@' symbol as the name.

• Consider handling cases where there are multiple names or special characters in the email address.
Answered by AI
Add your answer
Q2. There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matc...read more
Ans. 
Calculate the number of matches won and lost by each team based on the given data in the matches table.
• Group the data by team and count the number of matches won and lost for each team.

• Use the winner column to determine the outcome of each match.

• Create a query to calculate the number of matches won and lost for each team.

• Example: Team A won 2 matches and lost 1 match.

• Example: Team B won 1 match and lost 2 matches.
Answered by AI
Add your answer
Q3. Table a has 1, 1,0,0,null and table b has 1,0,null,null. Resultant rows for all joins
Ans. 
The resultant rows for all joins between table a and table b with given values.
• Inner join: 1

• Left join: 1, 1, 0, 0, null

• Right join: 1, 0, null, null

• Full outer join: 1, 1, 0, 0, null, null
Answered by AI
Add your answer
Q4. Explain primary and secondary indexing. And more questions on indexing
Add your answer

Q1. Explain about your projects
Ans. 
I have worked on various projects involving data analysis, visualization, and predictive modeling.
• Developed predictive models to forecast sales trends and customer behavior

• Created interactive dashboards using Tableau for data visualization

• Performed data cleaning and preprocessing to ensure accuracy and consistency

• Utilized machine learning algorithms such as regression and clustering for analysis

• Collaborated with cross-...read more
Answered by AI
Add your answer
Q2. Follow up questions on projects
Add your answer
Q3. Write a query to seperate first name, midle name and last name from full name in sql
Ans. 
Use SUBSTRING_INDEX function in SQL to separate first name, middle name, and last name from full name.
• Use SUBSTRING_INDEX function to extract first name by specifying space as delimiter

• Use SUBSTRING_INDEX function to extract last name by specifying space as delimiter and -1 as position

• Use combination of SUBSTRING_INDEX and REPLACE functions to extract middle name if present
Answered by AI
Add your answer

Q1. L1 Manager Round Basic Question about Previous JOB & Task and your achivements & check fit Role
Add your answer

Q1. L2 Manager Round Technical about Insurance & Business Understanding about Data & Fitment Check along with Grooming .
Add your answer

Q1. HR Round & Fitment & Salary Releated .
Add your answer

Q1. What are your achievements in relation to your previous employers?
Add your answer
Q2. What is your key role in achieving the objectives?
Add your answer

After 3 sections of aptitude, English and core subjects, there were two coding problems both based on string one was easy and other was medium.

Q1. Explain the projects in your resume
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines
• Utilized HTML, CSS, JavaScript for front-end development

• Used PHP and MySQL for back-end functionality

• Implemented user authentication and authorization features

• Integrated calendar and notification system for task reminders
Answered by AI
Add your answer
Q2. Explain the backend side of your project
Ans. 
The backend of my project is responsible for handling server-side logic and data processing.
• Implemented RESTful APIs for communication between frontend and backend

• Used Node.js and Express for server-side scripting

• Utilized MongoDB for database management

• Implemented authentication and authorization using JWT tokens
Answered by AI
Add your answer
Q3. How did you implement concepts of OOP in your projects
Ans. 
I implemented concepts of OOP in my projects by creating classes, objects, inheritance, encapsulation, and polymorphism.
• Used classes to represent real-world entities

• Implemented inheritance to reuse code and create a hierarchy of classes

• Utilized encapsulation to hide data and restrict access to it

• Applied polymorphism to allow objects of different classes to be treated as objects of a common superclass
Answered by AI
Add your answer
Q4. How to handle duplicate entries in the database
Ans. 
Duplicate entries in the database can be handled by using unique constraints, deduplication scripts, or merging duplicate records.
• Use unique constraints in the database schema to prevent duplicate entries.

• Implement deduplication scripts to regularly scan and remove duplicate records.

• Merge duplicate records by updating one record with the information from the other duplicate record.
Answered by AI
Add your answer
Q5. Write a code to tell whether a string is palindrome or not
Ans. 
Code to check if a string is a palindrome or not
• Create a function that takes a string as input

• Remove all non-alphanumeric characters and convert to lowercase

• Compare the string with its reverse to check if it's a palindrome
Answered by AI
Add your answer