Analyst Developer Interview Questions
3K
Analyst Developer 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
Given 9 ball with only one differ in weight, how to find out by measuring them only twice?
4 Answers↳
The above is so stupid...even Galileo knew that couldn't happen...and that was over 300 years ago... Less
↳
In theory, if you do the experiment in air, it is possible.
↳
Take 3 balls each. Weigh by keeping 3 on one side and three on other and keep the remaining 3 aside. 1. If the weigh comes as equal u know the ball with diff in weight is in the three kept aside. So again weigh by keeping one of the three on one side and one on other . If equal the third one is the one that differs in weight else ur weighing machine will tell u the one which differs in weight. 2. If initial weighing is not equal follow step one for the weigh which shows the diff Less
Most of them were basic questions. One was " Write down Java classes and methods that you required for a Transaction" "How do you convey a Technical banking transaction to a street man"
3 Answers↳
how do you convey a technical banking transaction to a street man? Can someone answer this?! Less
↳
so what are the classes and methods required for a transaction?
↳
I think every one knew it.
From which maximum floor can you throw an egg without breaking it?
3 Answers↳
Can you be more specific on ....breaking "it"? Does it mean the floor or egg?
↳
That is the trick here. The "it" refers to the floor here. So no matter how many floors above you go, an egg would never break the floor when it hits. Less
↳
through which recruiter/staffing agency did you apply?
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↳
R: given row, C: given column for i = 0 to m: Matrix(i, C) *= -1 for j = 0 to n: Matrix(R, j) *= -1 Matrix(R, C) *= -1 Less
↳
you can get even more efficiency if you go down to the bit level, since multiplication is expensive. python code follows: let's call the matrix M, and the given row and column r,c respectively for i in range(0,m): M[i][c] = ~M[i][c] + 1 for j in range(0,n): M[i][r] = ~M[i][r] + 1 Less
↳
for(i=0;i
How would you check how many instances of a process is running given part of a name of that process? Had no idea how to answer this.
2 Answers↳
Use a command with a pipe in it (Linux).
↳
ps -ef | grep *file_name*
Difference between delete and truncate, questions based on skills mentioned in resume
2 Answers↳
Truncate for remove any row or any object from table, Delete for removing table permanently. Less
↳
Truncate: 1. It is DDL Command. 2. Doesn't delete specific record. 3. Where keyword not supported. 4. Permanent Deletion. 5. Rollback not possible. 6. It is fast. 7. Reset Identity Property. Delete: 1. It is DML Command. 2. Possible to delete specific record 3. Where keyword is supported. 4. Temporary Deletion. 5. Roll back possible. 6. It is slow. 7. It is Reset identity property. Less