Chubb Interview Questions, Process, and Tips

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

5 coding questions, 2-medium and 3 easy - medium

Q1. Linked List Concept
Add your answer
Q2. DSA: prime no. or not optimal approach
Ans. 
Optimal approach for checking if a number is prime or not using DSA
• Optimal approach for checking prime numbers is to iterate up to square root of the number

• Use trial division method to check divisibility by numbers up to square root of the number

• Time complexity of this approach is O(sqrt(n))
Answered by AI
Add your answer
Q3. Class, object with real time examples
Ans. 
A class is a blueprint for creating objects, which are instances of the class. Objects have attributes and behaviors.
• Classes define the structure and behavior of objects.

• Objects are instances of classes and have their own unique attributes and behaviors.

• Example: Class 'Car' with attributes like 'color' and behaviors like 'drive'. Object 'myCar' is an instance of 'Car' with color 'red' and can drive.

• Example: Class 'Pers...read more
Answered by AI
Add your answer
Q4. SQL types of normal forms
Ans. 
SQL normal forms are levels of organization for relational databases to reduce redundancy and improve data integrity.
• First normal form (1NF) - Eliminate repeating groups and ensure each column contains atomic values.

• Second normal form (2NF) - Meet 1NF requirements and have all non-key attributes fully functionally dependent on the primary key.

• Third normal form (3NF) - Meet 2NF requirements and have no transitive depend...read more
Answered by AI
Add your answer

Q1. About Projects and contribution in that
Add your answer
Q2. Managerial Questions
Add your answer

Q1. General selenium interview questions
Add your answer
Q2. Project explanation and details about the projects worked on
Ans. 
I have worked on various projects in the field of software testing, including automation testing, performance testing, and regression testing.
• Automation testing using tools like Selenium and Appium

• Performance testing using JMeter to analyze system performance under different load conditions

• Regression testing to ensure new code changes do not negatively impact existing functionality
Answered by AI
Add your answer

Valid paranthesis question and 1 selenium question

Q1. Asked about the experience and projects
Add your answer
Q2. CI CD pipelines
Add your answer