Analyst Developer Interview Questions | Glassdoor

Analyst Developer Interview Questions

531

Analyst developer 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.

Given a m*n matrix with values -1 or 1, try to flip the values in a given row and a given line efficiently.

3 Answers

Describe a specific instance where you faced an ethical dilemma, were asked to do something unethical, or advised to lie about something. Describe how you handled the situation and why you handled it the way you did.

2 Answers

You have no real world experience with what this job requires. If presented with an assignment/project with real world demands and deadlines, how will you meet these needs?

2 Answers

Write a program that prints out all possible pairs that can be formed from 20 dancers.

2 Answers

Name one of the more efficient sorting algorithms

2 Answers

How does indexing work in a database? How is it implemented? what happens when user types ABC?

2 Answers

Swap two numbers while not using the temp variable.

3 Answers

Tell me how you see the company performing in the next 5 years.

1 Answer

Case study and puzzle

1 Answer
110 of 531 Interview Questions