ICON Plc SAS Programmer Trainee Interview Questions and Answers

It was an aptitude test

Q1. It was technical test
Add your answer
Q2. Sort an array with numbers
Ans. 
Use a sorting algorithm like quicksort or mergesort to rearrange the numbers in ascending or descending order.
• Implement a sorting algorithm like quicksort, mergesort, or bubblesort to rearrange the numbers in the array.

• Ensure the algorithm is efficient and handles edge cases like empty arrays or arrays with duplicate numbers.

• Test the sorting function with different arrays to verify its correctness.

• Example: [5, 2, 9, 1,
Answered by AI
Add your answer

Basic and advanced concepts of JavaScript / NodeJS covered.

Q1. Why are you looking for job change
Ans. 
Looking for new challenges and growth opportunities in a dynamic work environment.
• Seeking opportunities for career advancement

• Interested in working on new technologies and projects

• Desire for a more collaborative team environment

• Looking for a company with a strong focus on innovation and development
Answered by AI
Add your answer
Q2. What are your salary expectations
Ans. 
My salary expectations are in line with industry standards for a Senior Software Engineer with my level of experience.
• Research industry standards for Senior Software Engineer salaries in the local area

• Consider my years of experience, skills, and qualifications when determining salary expectations

• Be prepared to negotiate based on the overall compensation package offered
Answered by AI
Add your answer

Q1. 1. Is string a value type of reference type? 2. Big O - for loop, binary search, hash table lookup 3. Can you use object as a key in a dictionary? - answer is yes, using GetHashCode 4. Get 7th highest sal...read more
Add your answer
Q2. Design a employee-Manager class. Write method to display employee organizational hierarchy like we see in Microsoft Teams Org tab
Ans. 
Design an employee-Manager class and write a method to display employee organizational hierarchy.
• Create an Employee class with attributes like name, id, managerId, etc.

• Create a Manager class that inherits from Employee class and has a list of employees under them.

• Write a method to display the hierarchy using recursion.

• Use a data structure like a dictionary to store the employees and their managers.

• Consider edge cases l
Answered by AI
Add your answer
Q3. Get 7th highest salary without CTE
Ans. 
Get 7th highest salary without CTE
• Use subquery to get distinct salaries

• Order the salaries in descending order

• Use LIMIT and OFFSET to get the 7th highest salary
Answered by AI
Add your answer
Q4. Delegates, significance of it in C#
Ans. 
Delegates are a type-safe function pointers in C# used to encapsulate methods and pass them as arguments.
• Delegates allow for event-driven programming

• Delegates can be used to implement callbacks

• Delegates can be chained together to create a multicast delegate

• Delegates can be used to implement the observer pattern

• Delegates can be used to implement the command pattern
Answered by AI
Add your answer

Q1. All the asp.net and MVC questions need.
Add your answer

Q1. Singleton in java code. multithreading, spring boot questions.
Add your answer
Q2. SQL queries for finding highest salary
Ans. 
SQL queries to find highest salary
• Use the MAX() function to find the highest salary

• Combine with the SELECT statement to retrieve the corresponding employee details

• Use the ORDER BY clause to sort the results in descending order

• Use the LIMIT clause to limit the number of results returned
Answered by AI
View 1 more answer

Q1. Self and other tools
Add your answer
Q2. Jenkins Linux Ansible git AWS
Add your answer

Q1. SQL interview question
Add your answer
Q2. Stored Procedure and function differences
Ans. 
Stored procedures are precompiled and stored in the database, while functions are compiled and stored in memory.
• Stored procedures are precompiled and stored in the database for reuse.

• Functions are compiled and stored in memory for faster execution.

• Stored procedures can return multiple values, while functions return a single value.

• Functions can be called from within a stored procedure, but stored procedures cannot be ca
Answered by AI
Add your answer
Q3. SQL query flow and window function they will ask
Add your answer