Sr Engineer Interview Questions

113,933 sr engineer interview questions shared by candidates

Question related Department to employees ( SQL table design) and queries. Employee Table Columns are id , name , mgr_id ( name is firstname space lastName) Department table looks like name ,head ( where head is mgr_id ) Questions are 1) Write an SQL query to list the full name of every employee, alphabetized by first name. 2)Write an SQL query to list the full name of every employee, alphabetized by last name. 3)Write an SQL query to list the full name of every employee along with the full name of his/her manager. 4)Write an SQL query to list the full name of every employee in the Sales department. 5)Write an SQL query to list the full name of every employee along with name of his/her department. 6)Is there a better design for a database that supports the queries described in questions above? If so, describe it. If not, why not?
avatar

Senior Software Engineer

Interviewed at NextGen Healthcare

3.1
Jan 27, 2012

Question related Department to employees ( SQL table design) and queries. Employee Table Columns are id , name , mgr_id ( name is firstname space lastName) Department table looks like name ,head ( where head is mgr_id ) Questions are 1) Write an SQL query to list the full name of every employee, alphabetized by first name. 2)Write an SQL query to list the full name of every employee, alphabetized by last name. 3)Write an SQL query to list the full name of every employee along with the full name of his/her manager. 4)Write an SQL query to list the full name of every employee in the Sales department. 5)Write an SQL query to list the full name of every employee along with name of his/her department. 6)Is there a better design for a database that supports the queries described in questions above? If so, describe it. If not, why not?

asking first about registration in Saudi Council of Engineers thene did I worded in the same field as consultant how many years of experience did I wish to relocate then technical question about the job then how much I am expecting as basic salary the resumed salary did not mach thier budget
avatar

Senior Mechanical Engineer

Interviewed at Khatib & Alami

3.9
Aug 6, 2016

asking first about registration in Saudi Council of Engineers thene did I worded in the same field as consultant how many years of experience did I wish to relocate then technical question about the job then how much I am expecting as basic salary the resumed salary did not mach thier budget

Viewing 541 - 550 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 113,933 interview questions and reports from Sr engineer interviews. Prepare for your interview. Get hired. Love your job.