Associate Analyst Interview Questions | Glassdoor.co.in

Associate Analyst Interview Questions

794

Associate analyst interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

Join Queries in SQL

4 Answers

You can use multiple tables in your single SQL query. The act of joining inMySQL refers to smashing two or more tables into a single table. You can use JOINS in the SELECT, UPDATE and DELETE statements to join theMySQL tables. We will see an example of the LEFT JOIN also which is different from the simple MySQL JOIN.

SQL. Join (Inner, Left, Right and FullJoins) A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.

SQL. Join (Inner, Left, Right and FullJoins) A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.

Ok Suppose My Daughter said to me that in 2016 , her age is same as the last two digits of her birthday year and then her Grandfather came into the room and he also said the same thing that his age is also the same as last two digits of his birthday year. Find out what is age of Daughter and her Grandfather

5 Answers

Do you have any questions for us?

3 Answers

are you comfortable in relocating and working in night shift?

2 Answers

they asked me about the flexibility like if i was ready to work in rotational shifts?

2 Answers

Why do you want to be in Caterpillar?

2 Answers

Ok , Let's have some problem . There are 3 ants on an equilateral triangle and they can move in either direction , what is the probability that they will never intersect and what is the probability that any two of them will intersect.

2 Answers

How will you measure the stability of an company and quantitative skills were also tested in this process. More focus was on the technical side of the candidate so that they could find his skils .

2 Answers

basic Algorithms used in data science like different regression and classification algorithms. Their applications in real world.

2 Answers

In case inteviews you have to analyse bar graphs cures pie charts and interrelate them and data and then calculate and present your solutions Guestimate - how many mcdonalds outlet are there in indore Puzzle - Torch and bridge problem geeks for geeks General- values lying between -3sigma to +3sigma in a normal distribution curve(since he was senior in all daa's :P) Behavioural - when was the last time you got into a problem and how you came out of it

2 Answers
110 of 794 Interview Questions