Client Neebal | Interviewer : Shrikrishna Patil

.NET INTERVIEW QUESTIONS AND ANSWERS

1. What is a Managed & unmanaged code?
Difference between managed and unmanaged code? Managed code is the one that is executed by
the CLR of the .NET framework while unmanaged or unsafe code is executed by the operating system.
The managed code provides security to the code while undamaged code creates security threats.

2. Types of assemblies?
Private and public assemblies.

3. What is Cache? How to Cache Updated?
A cache is a reserved storage location that collects temporary data to help websites, browsers, and apps load faster.
Whether it's a computer, laptop or phone, web browser or app, you'll find a variety of cache.
Data can become stale if it is updated in the database. This issue is mitigated by
setting a time-to-live (TTL) which forces an update of the cache entry, or by using write-through.
When a node fails, it is replaced by a new, empty node, increasing latency

4. Types of subqueries?
1. Single Row Subquery
2. Multiple Rows Subquery
3. Multiple Columns Subquery
4. Correlated Subqueries
5. Nested Subqueries

5. How to change the theme in .Net MVC?
https://docs.telerik.com/aspnet-mvc/styles-and-layout/client-side-theme-change

6. How certificate is used for authentication?
Certificates replace the authentication portion of the interaction between the client and the server. Instead of requiring a
user to send passwords across the network throughout the day, single sign-on requires the user to enter the private-key database
password just once, without sending it across the network.

7. What Difference between Union and Union All?
Union:
The UNION command is used to select related information from two tables, which is like a JOIN command. However, when using the UNION
command, all the selected columns need to be of the same data type. With UNION, only distinct values are selected.
https://www.c-sharpcorner.com/blogs/sql-server-union-vs-union-all-which-is-better-for-performance

Union All:
UNION ALL command is equal to UNION command, except that UNION ALL selects all the values.
The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead, it just pulls all the
rows from all the tables fitting your query specifics and combines them into a table.


8. what are Boxing and Unboxing?
Boxing is the process of converting a value type to the type object or to any interface type implemented by this value type.
Example :
class Test
{
static void Main()
{
int i = 1;
object o = i; // boxing
int j = (int)o; // unboxing
}
}

9. What is the Reference type and Value type variable?
A Value Type holds the data within its own memory allocation and a Reference Type contains a pointer to
another memory location that holds the real data.
https://www.c-sharpcorner.com/UploadFile/ca6c61/concepts-of-C-Sharp-value-type-and-reference-type/

10. What is the difference between Unique Key and Primary Key?
the primary key identifies each record in the table, and the unique key prevents duplicate entries in a
column except for a NULL value.

11. What are the joins in SQL?
https://www.w3schools.com/sql/sql_join.asp

12. What is Index in SQL?
https://www.c-sharpcorner.com/UploadFile/8af593/index-in-sql-server/

13. Debug vs trace difference?
https://www.c-sharpcorner.com/interview-question/what-is-difference-between-debug-and-tracing

14. Asp.NET Page life Cycle?
https://www.c-sharpcorner.com/UploadFile/8911c4/page-life-cycle-with-examples-in-Asp-Net/

15. Explain MVC life Cycle.
https://www.c-sharpcorner.com/UploadFile/18585c/mvc-architecture-mvc-life-cycle/#:~:text=Explanation%20of%20MVC%20Life%20Cycle,the%20following%20operation%20will%20perform.