Real Interview Questions:
Here I have segregated the questions based on Interview rounds (L1, L2, L3 and L4 (HR discussion)) or difficulty Levels. L1 discussion is conducted to screen the candidate, if selected in L1, the Interviewer will proceed with L2 and L3 rounds, it depends on company to company
L1:
1. What is meant by CLR, CTS and CLS in Asp.Net
2. Briefly discuss OOPs concepts
3. Difference between Method Hiding and Method Overriding
4. When to use Abstract class and interface (Definite question)
5. What is polymorphism and its types
6. Uses of SOLID principles
7. What is the Difference between ViewBag, ViewData and TempData or How to maintain View State in MVC
8. Routing in Asp.Net
9. Differences between WebApi and MVC
10. Describe SOAP and Restful services
11. Filters in MVC and explain the sequence of execution
12. ActionResult return types in MVC
13. Return types in WebApi
L2:
1. Write a pseudo-code, describing all SOLID Principles
2. How to achieve loosely coupled architecture
3. Questions related to validation in MVC such as Data Annotations or Model validation
4. Conventional vs attribute-based routing in MVC
5. Model binding in Razor Views, shared folder vs Views folder
6. Use of Global.aspax file in Dot Net
7. What are Extension Methods
8. How to implement Partial Views
9. How to implement Session TimeOut and Redirect to URL
10. Use of @ActionLink and @URI in Razor Views
11. How do uncommit committed code changes in Git?
12. What is stashing?
13. Use of "this" keyword
14. Sealed class vs Static class
15. ExcecuteQuery vs ExceuteNonQuery
16. Delegates in C# and When to use them
17. Managed code vs Unmanaged code. How to dispose of unmanaged code.
18. Finally keyword vs Finalize
Programming questions:
1. Sort the given array (use any sorting algorithm)
2. Print unique values in an array using C#
3. Print duplicate elements in an array
4. Check if a number is a prime number or not in fewer iterations
Some SQL questions:
1. Data Types in SQL Server, Difference between char and varchar datatype
2. decimal vs money datatype
3. Is SELECT keyword a DML or DDL statement
4. Store Procedures vs Functions
5. What are Indexes and when to use them
6. What is meant by SURROGATE KEYS
7. Difference between Primary Key and Unique Key
8. Can we have multiple primary keys
Scripting questions:
1. Delete duplicate rows in a table
2. Print comma-separated courses for individual Student
3. Given the students, subject and student marks table, display the student records who passed the exam (criteria mark in each subject greater than 35)
4. Write queries for all types of joins.
L3:
1. How to implement Repository Pattern in Asp.Net
2. Approaches in Entity Framework
3. Implement pseudo ADO.Net code (use SQL Reader, SqlDataAdapter)
4. What is meant by Authentication and how to implement it.
5. What is meant by Authorization and how to implement it.
6. How to implement Global Exception Handling
7. Write a code using Dependence Inversion principles
8. How to implement Dependency Injection using Unity.config
9. Different layers in Asp .Net solution (Controller layer, Business Layer (middle layer), Data Access Layer)
10. Write a code for a singleton design pattern
11. What are overridden methods in Filters, Discuss various methods in Action Filters
12. How to implement session Timeout in Asp .Net
13. Thread vs Task. When to use parallel programming
14. How to avoid race conditions when using threads (Ans: use join and start)
15. How to implement authentication using JWT or OpenID, OAuth bearer token in Asp .Net
16. How to integrate swagger in the Asp .Net solution
17. What are different ways to implement exception handling.
SQL Questions:
1. What is an indexer, or cursor in an SQL server
2. What are magic tables
3. What are Triggers and When to use them.
4. Rank vs Dense Rank
5. Types of Functions in SQL server
6. Difference between CTE and View
Programming questions:
1. Reverse array using O(1)?
2. Display array elements without using loops (Ans: use string.join)
3. Write a code to print pair of values in an array whose sum is equal to the target
4. Find the closest element in an array when the target element is given
5. Pattern printing question, basic * patterns
6. Find the target element in an array in O(n)
7. Given an array [1,2,[3,4,[5,6], 7], 8,9], print the numbers. (Typescript solution is available).
Note: L4 is mostly HR or project discussion. If you prepare all the above questions well, this will help you crack all the service-based and few product-based companies.
No comments:
Post a Comment