AXA Business Services Data Analyst Interview Questions and Answers

Basic 10 apti question

Basic 5 python question

Basic 5 SQL question

Q1. They asked two python program.
Add your answer

Q1. They asked one SQL question
Add your answer

Q1. Just question based on my resume.
Add your answer

Q1. Tell me about your self?
Add your answer
Q2. What is SQL and diffrent joins in SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
• SQL is a standard programming language for managing and manipulating relational databases.

• Different types of joins in SQL include inner join, outer join, left join, and right join.

• Inner join returns rows when there is at least one match in both tables.

• Ou...read more
Answered by AI
Add your answer
Q3. How to separate portion before @ and after @ from mail using python?
Ans. 
Use Python to separate portion before and after @ in an email address.
• Use the split() method to separate the email address into two parts based on the @ symbol.

• Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

• Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Answered by AI
Add your answer
Q4. What is the rank, Dense Rank and Row Number?
Ans. 
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
• Rank function assigns a unique rank to each row based on the specified column values.

• Dense Rank function assigns a unique rank to each row without any gaps.

• Row Number function assigns a sequential integer to each row in the result set.
Answered by AI
Add your answer

Q1. Regularizaion, model improvemnts
Add your answer
Q2. Hyperparameter tuning
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Tell me a time when you had to deal with a failure, how you tackled it
Add your answer

Q1. Whats is supervised learning
Ans. 
Supervised learning is a type of machine learning where the model is trained on labeled data to make predictions or decisions.
• Uses labeled data for training

• Predicts outcomes based on input features

• Examples include regression and classification algorithms
Answered by AI
Add your answer
Q2. What is unsupervised learning
Ans. 
Unsupervised learning is a type of machine learning where the model is trained on unlabeled data without any predefined output labels.
• No predefined output labels are provided for the training data

• The model must find patterns and relationships in the data on its own

• Common techniques include clustering and dimensionality reduction

• Examples: K-means clustering, Principal Component Analysis (PCA)
Answered by AI
Add your answer

Q1. 1) Formula for Precision and recall
Ans. 
Precision = TP / (TP + FP), Recall = TP / (TP + FN)
• Precision is the ratio of correctly predicted positive observations to the total predicted positive observations

• Recall is the ratio of correctly predicted positive observations to the all observations in actual class

• Example: If a model predicts 100 positive cases, out of which 80 are actually positive, precision = 80/100, recall = 80/total actual positive cases
Answered by AI
Add your answer
Q2. 2) Difference between R2 and adjusted R2
Ans. 
R2 measures the proportion of variance explained by the model, while adjusted R2 adjusts for the number of predictors in the model.
• R2 is the proportion of variance in the dependent variable that is predictable from the independent variables.

• Adjusted R2 penalizes the addition of unnecessary predictors in the model, providing a more accurate measure of the model's goodness of fit.

• R2 can increase even when adding irreleva...read more
Answered by AI
Add your answer

Q1. Sql indexing. window function.
Add your answer
Q2. Many other sql questins were there
Add your answer

Q1. 5 year goal. where do you see yourself.
Add your answer

Q1. About my self and my educational background
Ans. My name is poonam Sharma . I have a good knowledge of computer .i have completed my HSC and SSC exam from UP board. Have completed my TY from Mahatma Gandhi Kashi Vishwanath
Answered Anonymously
Add your answer
Q2. About my work experience
Add your answer
Q3. I am fresher but I have a good knowledge of computer
Add your answer
Q4. About my marriage status
Add your answer
Q5. My hobby , and my future plans
Ans. My hobby is studying and my future plans is becoming IAS,IPS officer
Answered Anonymously
Add your answer