The Travelers Companies Interview Questions and Answers

10,18,28,40,54,70, ? Ans 88

Q1. The upper house of Indian Parliament is known as - The Rajya sabha
Add your answer
Q2. The SAARC secretariat is located at - Kathmandu
Add your answer
Q3. Largest Indian fish is- Ans: Whale Shark
Add your answer
Q4. WTO came into existence in the year - Ans: 1995
Add your answer

6,11,21,36,56,?
Ans 81

Q1. How important an honest person for the organisation's real growth?
Add your answer
Q2. Should there be retirement if the person is fit?
Add your answer
Q3. Should not there be the pension for an honest employee after atleast 5years of one's job with the organisation?
Add your answer

Q1. What factors influenced your decision to choose this company?
Add your answer
Q2. What is the total number of employees in the company?
Add your answer

Q1. Any insurance company work with you
Add your answer
Q2. What are your salary expectations?
Add your answer

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. What do you know about macro?
Add your answer
Q2. What do you know about Power BI and PowerPoint presentations?
Add your answer

Q1. What is your level of experience in your field?
Add your answer
Q2. What are your salary expectations?
Add your answer

Q1. Claim process is bad
Ans. 
The claim process can be improved by streamlining procedures and increasing transparency.
• Implementing a digital platform for submitting and tracking claims can improve efficiency.

• Providing clear guidelines and instructions to claimants can reduce confusion and errors.

• Regularly reviewing and updating the claim process based on feedback can help address any issues.

• Training staff members on the claim process can ensure co
Answered by AI
Add your answer
Q2. Very bad experience
Add your answer
Q3. Even after I targeted 50% business, the company terminated me in a single day and withheld my salary for 45 days in full and final settlement. Emp cod Pnbmetlife - 8036724
Add your answer
Q4. Very bad experience with HR and management team
Add your answer
Q5. I will become unemployed due to sudden loss of job
Add your answer

Q1. Tell me about yourself.
Ans. 
Experienced professional with a background in project management and team leadership.
• Over 5 years of experience in project management

• Strong leadership skills demonstrated through successful team management

• Proven track record of delivering projects on time and within budget

• Excellent communication and interpersonal skills

• Passionate about driving results and exceeding expectations
Answered by AI
Add your answer
Q2. Why should we hire you?
Ans. 
I have a proven track record of successfully managing teams and projects, with strong leadership and communication skills.
• I have X years of experience in project management

• I have successfully led a team of Y individuals to achieve Z goals

• I possess strong communication and interpersonal skills, which are essential for effective team management
Answered by AI
Add your answer
Q3. What are your salary expectations?
Ans. 
I am looking for a competitive salary that reflects my experience and skills.
• Research industry standards for Associate Manager salaries

• Consider cost of living in the area

• Factor in your years of experience and qualifications

• Be prepared to negotiate based on benefits package
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced professional with a background in project management and team leadership.
• Over 5 years of experience in project management

• Strong leadership skills demonstrated through successful team management

• Proven track record of delivering projects on time and within budget

• Excellent communication and problem-solving abilities

• Passionate about driving results and fostering a collaborative work environment
Answered by AI
Add your answer
Q2. Tell me about family background?
Ans. 
My family background is diverse and has greatly influenced my values and work ethic.
• My parents are both immigrants, which has taught me the importance of hard work and perseverance.

• I come from a large family with strong ties to our cultural traditions.

• Growing up, I learned the value of education and the importance of supporting one another.

• My family has always been supportive of my career goals and encouraged me to pur
Answered by AI
Add your answer