Nextgen Information Services Interview Questions
366
Nextgen Information Services interview questions shared by candidates
Summer Analyst was asked...21 September 2020
Senior Software Engineer was asked...27 January 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?
2 Answers↳
In MySQL, SELECT name FROM employee ORDER BY SUBSTRING_INDEX(name, " ", 1);
↳
Trick one is question 2 answer look like this ( SQL Server) SELECT employee.name FROM employee order by SUBSTRING(Name, CHARINDEX(' ', Name) + 1, LEN(Name)) Less
Tech Support was asked...17 November 2017
Collections Specialist was asked...9 June 2016
Tell us about yourself? Do you know the difference between co-pay's and coinsurance's?
2 Answers↳
Copay is flat amount coinsurance is usually based on a percentage
↳
Copay is flat amount coinsurance is usually based on a petcentage
CEO was asked...9 April 2018
Product Owner was asked...27 December 2022
Summer Internship was asked...4 February 2023
Data Steward was asked...31 March 2023
very standard questions such as questions with regards to my experience to ensure qualification, salary expectations, etc.
1 Answers↳
walked them through my experience chronologically.
Analyst was asked...13 September 2023
Tell me about yourself, why next gen, and certain questions about experiences there was a hireview or online recording that was like 8 questions and it was kind of long but not too difficult
1 Answers↳
well
Director was asked...10 January 2024