Engineer 1 Interview Questions

1,033 engineer 1 interview questions shared by candidates

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.4
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 951 - 960 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 1,033 interview questions and reports from Engineer 1 interviews. Prepare for your interview. Get hired. Love your job.