Find jobs for associate analyst

Associate analyst Interview Questions

4K

Associate Analyst interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
World Wide Technology
Associate Business Intelligence Analyst Developer was asked...October 28, 2011

Whats the difference between inner join and outer join?

2 Answers

Specified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table. Less

Inner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the Key Less

Gallup

What do you think about when you are alone in your car?

32 Answers

I try not to be distracted and pay attention to the road.

Sex. Do you want me to go into more detail on that?

I hope I will never have to work at HR and have to create smart unexpected questions. Less

Show More Responses
XL Dynamics

Tell me about your family

4 Answers

After how many days of online test they will contact us for hr round

After how many days of online test they will contact us for hr round

They take 10 15 business days

Show More Responses
Ugam

Join Queries in SQL

4 Answers

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. Less

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. Less

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. Less

Show More Responses
Deloitte

Explain software development life cycle.

4 Answers

how did you apply for the position?

how did you apply for the position?

Through college, it was a campus placement.

Show More Responses
Zifo RnD Solutions

asked every word in my resume

4 Answers

Apptitude

helpful

orchestrated

Show More Responses
Johnson Brothers

How do you handle stress?

3 Answers

I take a minute an breath in deep an exhale a few time an try to think of something that makes me happy Less

Fairly good.

take a deep breath and evaluate situation.

Enova

There are 3 ants on each side of a triangle. If they are all moving the same speed, what is the probability that 2 or more of the ants run into each other?

3 Answers

There are 4 different options for movement Its 50% 1ant cw 2 ant ccw 2ant cw 1 ant ccw All ants cw All ants ccw 2 of these options result in colisions 50% chance Less

This is an interesting read: bit.ly/faang100

75%... 2^3 = 8 possible options for the ants to walk. The only way none of them collide is if they all move in the same direction either clockwise or counter clockwise. Therefore, 6/8 options will result in the ants converging. Less

Wells Fargo

What are the accountimg rules

3 Answers

Real account debit what comes in credit what goes out Personal account debit the receiver credit the giver Nominal account debit all expenses and losses credit all incomes and gains Less

3 golden rules

Real account debit what comes in Credit what goes out Personal account debit the receiver Credit the giver Nominal account debit all expenses and losses Credit all incomes and gains Less

Fractal

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.

3 Answers

2 out of 8 times they will not be colliding, as they all will be moving in same direction. So 6/8 times they will collide. 0.25 is the probability that they will not collide provided the triangle is equilateral and all ants are moving in the same speed. Less

1. Probability of no collision No collision will happen only if all the ants move clockwise or anti-clockwise. An ant can move only in 2 directions, therefore, the probability of an ant moving in one direction = 0.5 For three ants, 0.5*0.5*0.5 = 1/8 (for clockwise) Similarly for anti- clockwise = 1/8 For no collision, either ants will move together in clockwise or anti-clockwise direction Therefore, 1/8 + 1/8 = 2/8 or 0.25 There is a 25% chance that there will be no collision and 75 % chance that any two of them will intersect. Less

0.5 they can intersect 0.5 they cannot intersect

Viewing 1 - 10 of 4,158 Interview Questions

See Interview Questions for Similar Jobs