Software Engineer

It was an easy application of Kadane's Algorithm.

Tip : Memorise the basic SQL queries.

Inner Join :
 

1) It returns the combined tuple between two or more tables.
2) Used clause INNER JOIN and JOIN.
3) When any attributes are not common then it will return nothing.
4) If tuples are more. Then INNER JOIN works faster than OUTER JOIN.
5) It is used when we want detailed information about any specific attribute.

SQL Syntax :
 

select *
from table1 INNER JOIN / JOIN table2
ON table1.column_name = table2.column_name;

Outer Join :
 

1) It returns the combined tuple from a specified table even if the join condition fails.
2) Used clause LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, etc.
3) It does not depend upon the common attributes. If the attribute is blank then there is already placed NULL.
4) Generally, The OUTER JOIN is slower than INNER JOIN. But except for some special cases.
5) It is used when we want to complete information.
 

SQL Syntax :
 

select *
from table1 LEFT OUTER JOIN / RIGHT OUTER JOIN /
FULL OUTER JOIN / FULL JOIN table2 ON
table1.column_name = table2.column_name;

Tip 1 : The cross questioning can go intense some time, think before you speak.

Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.
 

Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, which team you are mentoring. How all is the work environment etc.

Tip 4 : Since everybody in the interview panel is from tech background, here too you can expect some technical questions. No coding in most of the cases but some discussions over the design can surely happen.