Skip to contentSkip to footer

Senior Software Engineer Interviews

Salaries
Interviews

Senior Software Engineer Interview Questions

"Senior software engineers are the most experienced member of a software team and usually carry the most responsibility and authority of that team. Because of this, interviews will be designed to find candidates who have expert knowledge of the field and years of experience as a software engineer. Expect to be asked tough technical questions and to give examples of previous projects that you have worked on."

67,191 senior software 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?

Viewing 361 - 370 interview questions

Glassdoor has 67,191 interview questions and reports from Senior software engineer interviews. Prepare for your interview. Get hired. Love your job.