Skip to contentSkip to footer

Associate Programmer Analyst Interview Questions

Salaries
Interviews

22,437 associate programmer analyst interview questions shared by candidates

Draw an ER diagram on the white board. I was given two table names (customer and account). I had to figure out what fields would typically be in these tables. Then I was asked to write one query to fetch data from the tables. I can't remember it specifically but I had to use an inner join. The weird questions: if you have a triangle with a person at each corner of the triangle, and they are moving in all directions, what is the probability that they will collide? And if you are in a pitch black room with a sock drawer of 20 blue and 20 green socks, what is the minimum number of times you have to reach inside to GUARANTEE a matching pair of socks the same color?
avatar

Analyst Applications Programmer

Interviewed at Bank of America

3.9★
Dec 8, 2016

Draw an ER diagram on the white board. I was given two table names (customer and account). I had to figure out what fields would typically be in these tables. Then I was asked to write one query to fetch data from the tables. I can't remember it specifically but I had to use an inner join. The weird questions: if you have a triangle with a person at each corner of the triangle, and they are moving in all directions, what is the probability that they will collide? And if you are in a pitch black room with a sock drawer of 20 blue and 20 green socks, what is the minimum number of times you have to reach inside to GUARANTEE a matching pair of socks the same color?

Viewing 571 - 580 interview questions

Glassdoor has 22,437 interview questions and reports from Associate programmer analyst interviews. Prepare for your interview. Get hired. Love your job.