Associate Analyst Interview Questions
5K
Associate Analyst interview questions shared by candidates
Whats the difference between inner join and outer join?
2 Answers↳
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
↳
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
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
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
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
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.
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
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
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