Intercontinental Exchange interview questions

Q1. Pillars of OOPs with real life example, Explain difference between Abstraction and Encapsulation. Can you explain Diamond problem related to inheritance. Q2. Difference between synchronous and asynchronous programming, difference between thread and task, If we create two threads and one of those throws exception while executing can the main thread handle it ? Can it be handled if we create tasks instead ? Q3. Can you explain various design patterns and implement Singleton design pattern Q4. Can you explain how Garbage collection works. Different generations of garbage collections. Using keyword in c# and its advantage for garbage collection. Q5. Can you explain difference between REST and SOAP, what are different types of HTTP verbs and their usage, difference between PUT and PATCH, what are route tables and which data structure do they use, what are Filters (authentication, authorization) ? Q6. can you explain SOLID principles Q7. Given a list of strings, group string by 1st character and then sort groups alphabetically Q8. What are steps to improve sql query performance, difference between sql functions and stored procedures when to use which ? what are index and what are views and their use. Q9. Given 2 tables, 1 having 100 employee records and having salary info for 95 employee, can you write a query to get all employee that don't have salary records Q10. write a code to print n numbers of Fibonacci series Q11. Can you explain extension methods and write one for Int data type Q12. IEnumerable vs IQuerable, FirstOrDefault vs SingleOrDefault methods

Database Queries Unix QA