Associate Business Analyst Interview Questions | Glassdoor

Associate Business Analyst Interview Questions

134

Associate business analyst interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

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

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.

How do you deal with stress *heh heh*?

1 Answer

define IPO

1 Answer

Nothing that was of help to future interviewers...what version numbers my programs were, a lot of detail oriented things that seemed largely irrelevant.

1 Answer

Why EMC? Why IT?

1 Answer

The usual "What are your weaknesses?" is a tough question.

1 Answer

If you were a tree, what kind of tree would you be?

1 Answer

If you are holding a callable bond is it your right or obligation to deliver the bond if it is called.

1 Answer

Difference between inner joints and outer joints ?

1 Answer

Most difficult was the case study portion. It was a technical case study on issues that could be presented in data for a web-analytics tool.

1 Answer
110 of 134 Interview Questions