Skip to contentSkip to footer

Software Engineer 1 Interview Questions

Salaries
Interviews

3,923 software engineer 1 interview questions shared by candidates

SQL concepts
avatar

SSE-1

Interviewed at Aurigo Software Technologies

4.7★
Jul 16, 2020

SQL concepts

Assume there exists an employee table. An employee reports to a manager. Given such a table, how will store the data in table such that, i can get hierarchy of an employee till CEO in a single query. For example if an employee is a software engineer. Assume his hierarchy would be upto CEO can be manager -> VP -> CEO. Tell an efficient way to store the above data, so that hierarchy can be retrieved in a single step.
avatar

Software Development Engineer-1

Interviewed at Freshworks

3.3★
Mar 24, 2018

Assume there exists an employee table. An employee reports to a manager. Given such a table, how will store the data in table such that, i can get hierarchy of an employee till CEO in a single query. For example if an employee is a software engineer. Assume his hierarchy would be upto CEO can be manager -> VP -> CEO. Tell an efficient way to store the above data, so that hierarchy can be retrieved in a single step.

Viewing 3611 - 3620 interview questions

Glassdoor has 3,923 interview questions and reports from Software engineer 1 interviews. Prepare for your interview. Get hired. Love your job.