ArcelorMittal MES Developer (.NET) interview questions

He asked me the following questions: What are properties in C# and why do we need them? Do you know any design patterns? Which one have you used in your project and why? How would you create a method that can accept parameters of any type and then determine the parameter type? Write a program to reverse an array in length/2 iterations without using the built-in reverse function. What is a View in SQL and why do we use it? What is the difference between stored procedures and functions? How would you design a payment gateway Pay() method for different payment methods using method overloading? (The interviewer wanted to check my practical understanding of method overloading.) Introduce yourself and rate your proficiency in .NET and SQL. (This was asked at the beginning of the interview.) Overall, the interview focused on practical understanding, reasoning behind concepts, and real-world application of programming principles rather than theoretical definitions.