Skip to contentSkip to footer

Senior Interview Questions

Salaries
Interviews

342,212 senior 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 1231 - 1240 interview questions

Glassdoor has 342,212 interview questions and reports from Senior interviews. Prepare for your interview. Get hired. Love your job.