associate analyst interview questions shared by candidates
Whats the difference between inner join and outer join?
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.
The interview was a structured interview with manager following the paper outline. The manager inquired further to some of the questions along the way though mostly went one level deeper with followup questions. Most the questions that I remember were experience based with some personality based. No big deal the interview was relaxed and the role required dynamism and a strong person which almost seemed hypocritical.
watermelon of 10kg is there having 99 % water.If we keep in sun for sometime water evaporates and now in the resultant watermelon after evaporation 98% water is there.How many kgs of weight was lost ?
See Interview Questions for Similar Jobs
- Registered Nurse
- Account Executive
- Social Worker
- Sales Associate
- Pharmacy Technician
- Graphic Designer
- Security Guard
- Administrative Assistant
- Human Resource