1 - 500DotNetInterviewQuestionsList2022xlsm

	B	C	D	F	H	K	L
1
2
3
4
5	Topic	Question	Prepared?	Answer Key
6	OOPS & C# - Main Concepts	What are the main concepts of OOPS? What are classes and objects?	NO	View Answer		NO
7	OOPS & C# - Main Concepts	What is Inheritance? Why Inheritance is important?	NO	View Answer		YES
8	OOPS & C# - Main Concepts	What are the different types of Inheritance?	NO	View Answer
9	OOPS & C# - Main Concepts	How to prevent a class from being Inherited?	NO	View Answer		Total	200
10	OOPS & C# - Main Concepts	What is Abstraction?	NO	View Answer		Marks remaining	800
11	OOPS & C# - Main Concepts	What is Encapsulation?	NO	View Answer		Maximum marks	1000
12	OOPS & C# - Main Concepts	What is Polymorphism and what are its types?	NO	View Answer
13	OOPS & C# - Main Concepts	What is Method Overloading? In how many ways a method can be overloaded?	NO	View Answer
14	OOPS & C# - Main Concepts	What is the difference between Overloading and Overriding?	NO	View Answer
15	OOPS & C# - Main Concepts	What is the difference between Method Overriding and Method Hiding?	NO	View Answer
16	OOPS & C# - Main Concepts	What are the advantages and limitations of OOPS?	NO	View Answer
17	OOPS & C# - Abstract Class & Interface	What is the difference between an Abstract class and an Interface (atleast 4)?	NO	View Answer	Prepared 20% - Starting Point
18	OOPS & C# - Abstract Class & Interface	When to use Interface and when Abstract class?	NO	View Answer	Prepared 70% - CONGRATS! Now you are ready for any Interview (Mark "Prepared" column Yes to move forward)
19	OOPS & C# - Abstract Class & Interface	Why to even create Interfaces?	NO	View Answer
20	OOPS & C# - Abstract Class & Interface	Do Interface can have a Constructor?	NO	View Answer
21	OOPS & C# - Abstract Class & Interface	Can you create an instance of an Abstract class or an Interface?	NO	View Answer
22	OOPS & C# - General	What are Access Specifiers? What is the default access modifier in a class?	NO	View Answer
23	OOPS & C# - General	What is Boxing and Unboxing?	NO	View Answer
24	OOPS & C# - General	What is the difference between “String” and “StringBuilder”? When to use what?	NO	View Answer
25	OOPS & C# - General	What are the basic string operations in C#?	NO	View Answer
26	OOPS & C# - General	What are Nullable types?	NO	View Answer
27	OOPS & C# - General	Explain Generics in C#? When and why to use them?	NO	View Answer
28	OOPS & C# - Exception Handling	How to implement Exception Handling in C#?	NO	View Answer
29	OOPS & C# - Exception Handling	Can we execute multiple Catch blocks?	NO	View Answer
30	OOPS & C# - Exception Handling	What is a Finally block and give an example when to use it?	NO	View Answer
31	OOPS & C# - Exception Handling	Can we have only “Try” block without “Catch” block?	NO	View Answer
32	OOPS & C# - Exception Handling	What is the difference between “throw ex” and “throw”?	NO	View Answer
33	OOPS & C# - Loops & Collections	What are the Loop types in C#?	NO	View Answer
34	OOPS & C# - Loops & Collections	What is the difference between “continue” and “break” statement?	NO	View Answer
35	OOPS & C# - Loops & Collections	What is the difference between Array and ArrayList (atleast 2)?	NO	View Answer
36	OOPS & C# - Loops & Collections	What is the difference between Arraylist and Hashtable?	NO	View Answer
37	OOPS & C# - Loops & Collections	What are Collections in C# and what are their types?	NO	View Answer
38	OOPS & C# - Loops & Collections	What is IEnumerable in C#?	NO	View Answer
39	OOPS & C# - Loops & Collections	What is the difference between IEnumerable and IEnumerator in C#?	NO	View Answer
40	OOPS & C# - Loops & Collections	What is the difference between IEnumerable and IQueryable in C#? Why to use IQueryable in sql queries?	NO	View Answer
41	OOPS & C# - Methods & Delegates	What is the difference between “out” and “ref” parameters?	NO	View Answer
42	OOPS & C# - Methods & Delegates	What is the purpose of “params” keyword?	NO	View Answer
43	OOPS & C# - Methods & Delegates	What is a Constructor and what are its types?	NO	View Answer
44	OOPS & C# - Methods & Delegates	When to use Private constructor?	NO	View Answer
45	OOPS & C# - Methods & Delegates	What are Extension Methods in C#? When to use them?	NO	View Answer
46	OOPS & C# - Methods & Delegates	What you mean by Delegate? When to use them?	NO	View Answer
47	OOPS & C# - Methods & Delegates	What are Multicast Delegates?	NO	View Answer
48	OOPS & C# - Methods & Delegates	What are Anonymous Delegates in C#?	NO	View Answer
49	OOPS & C# - Methods & Delegates	What are the differences between Events and Delegates?	NO	View Answer
50	OOPS & C# - Important Keywords	What is “this” keyword in C#? When to use it?	NO	View Answer
51	OOPS & C# - Important Keywords	What is the purpose of “using” keyword in C#?	NO	View Answer
52	OOPS & C# - Important Keywords	What is the difference between “is” and “as” operators?	NO	View Answer
53	OOPS & C# - Important Keywords	What is the difference between “Readonly” and “Constant” variables (atleast 3)?	NO	View Answer
54	OOPS & C# - Important Keywords	What is “Static” class? When to use it?	NO	View Answer
55	OOPS & C# - Important Keywords	What is the difference between “var” and “dynamic” in C#?	NO	View Answer
56	OOPS & C# - Important Keywords	What is Enum keyword used for?	NO	View Answer
57	.NET Framework - Basics & Garbage Collection	What are the important components of .NET framework? What are their roles?	NO	View Answer
58	.NET Framework - Basics & Garbage Collection	What is an Assembly? What are the different types of assembly in .NET?	NO	View Answer
59	.NET Framework - Basics & Garbage Collection	What is GAC?	NO	View Answer
60	.NET Framework - Basics & Garbage Collection	What is Garbage Collection(GC)?	NO	View Answer
61	.NET Framework - Basics & Garbage Collection	What are Generations in garbage collection?	NO	View Answer
62	.NET Framework - Basics & Garbage Collection	What is the difference between “Dispose” and “Finalize”?	NO	View Answer
63	.NET Framework - Basics & Garbage Collection	What is the difference between “Finalize” and “Finally” methods?	NO	View Answer
64	.NET Framework - Basics & Garbage Collection	Can we force Garbage Collector to run?	NO	View Answer
65	.NET Framework - Threading	What is the difference between Process and Thread?	NO	View Answer
66	.NET Framework - Threading	Explain Multithreading?	NO	View Answer
67	.NET Framework - Threading	What is the difference between Threads and Tasks? (atleast 3)	NO	View Answer
68	.NET Framework - Threading	What is the Async and Await in task?	NO	View Answer
69	.NET Framework - Others	What is Reflection?	NO	View Answer
70	.NET Framework - Others	What is Serialization?	NO	View Answer
71	.NET Framework - Others	What is meant by Globalization and Localization?	NO	View Answer
72	.NET Framework - Others	What are Window Services?	NO	View Answer
73	SQL - Basics	What is the difference between DBMS and RDBMS?	NO	View Answer
74	SQL - Basics	What is a Constraint is SQL? What are its types.	NO	View Answer
75	SQL - Basics	What is the difference between Primary key and Unique key?	NO	View Answer
76	SQL - Basics	What are Triggers and types of triggers?	NO	View Answer
77	SQL - Basics	What is a View?	NO	View Answer
78	SQL - Basics	What is the difference between Having clause and Where clause?	NO	View Answer
79	SQL - Basics	What is Sub query or Nested query or Inner query in SQL?	NO	View Answer
80	SQL - Basics	What is Auto Increment/ Identity column in SQL Server?	NO	View Answer
81	SQL - Joins	What are Joins in SQL?	NO	View Answer
82	SQL - Joins	What are the types of Joins in SQL Server?	NO	View Answer
83	SQL - Joins	What is Self-Join?	NO	View Answer
84	SQL - Joins	Write a SQL query to fetch all the Employees who are also Managers.	NO	View Answer
85	SQL - Indexes	What are Indexes in SQL Server?	NO	View Answer
86	SQL - Indexes	What is Clustered index?	NO	View Answer
87	SQL - Indexes	What is Non-Clustered index?	NO	View Answer
88	SQL - Indexes	What is the difference between Clustered and Non-Clustered index?	NO	View Answer
89	SQL - Indexes	How to create Clustered and Non-Clustered index in a table?	NO	View Answer
90	SQL - Indexes	In which column you will apply the indexing to optimize this query. “select id, class from student where name=”happy””?	NO	View Answer
91	SQL - Stored Procedure, Functions & Others	What is the difference between Stored Procedure and Functions (at least 3)?	NO	View Answer
92	SQL - Stored Procedure, Functions & Others	How to optimize a Stored Procedure or SQL Query?	NO	View Answer
93	SQL - Stored Procedure, Functions & Others	What is a Cursor? Why to avoid them?	NO	View Answer
94	SQL - Stored Procedure, Functions & Others	What is the difference between scope_identity and @@identity?	NO	View Answer
95	SQL - Stored Procedure, Functions & Others	What is CTE in SQL Server?	NO	View Answer
96	SQL - Stored Procedure, Functions & Others	What is the difference between Delete, Truncate and Drop commands?	NO	View Answer
97	SQL - Stored Procedure, Functions & Others	How to get the Nth highest salary of an employee?	NO	View Answer
98	SQL - Stored Procedure, Functions & Others	What are ACID properties?	NO	View Answer
99	SQL - Stored Procedure, Functions & Others	What are Magic Tables in SQL Server?	NO	View Answer
100	ASP.NET – MVC - Part I	What is MVC (Model View Controller)? Explain MVC Life cycle.	NO	View Answer