Posts

.NET Core interview questions and answers

-
for an experienced developer: 1. What are the differences between .NET Core and .NET Framework? Answer: Platform : .NET Core is cross-platform, meaning it can run on Windows, Linux, and macOS. .NET Framework, on the other hand, is only for Windows. Performance : .NET Core is optimized for performance and is faster compared to the .NET Framework. Deployment : .NET Core supports side-by-side installation, meaning multiple versions can be installed on the same machine, while .NET Framework requires a single version per machine. Open Source : .NET Core is open source, while .NET Framework is closed source. Versioning : .NET Core uses a more modular approach with NuGet packages, while .NET Framework is monolithic. 2. What is Dependency Injection (DI) in .NET Core? Answer: Dependency Injection is a design pattern used to implement IoC (Inversion of Control). In .NET Core, DI is built-in and allows objects to be passed (injected) into classes that depend on them. This promotes loose coupling...
Post a Comment
Read more

Abstract and Sealed Classes and Class Members

-
The abstract keyword enables you to create classes and class members that are incomplete and must be implemented in a derived class. The sealed keyword enables you to prevent the inheritance of a class or certain class members that were previously marked virtual. Abstract Classes and Class Members Classes can be declared as abstract by putting the keyword abstract before the class definition . For example: An abstract class cannot be instantiated. The purpose of an abstract class is to provide a common definition of a base class that multiple derived classes can share. For example, a class library may define an abstract class that is used as a parameter to many of its functions, and require programmers using that library to provide their own implementation of the class by creating a derived class. Abstract classes may also define abstract methods. This is accomplished by adding the keyword abstract before the return type of the method. For example: Abstract methods have no i...
1 comment
Read more

SQL Server interview questions & answer

-
Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption. It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to CREATE PROCEDURE Abc WITH ENCRYPTION AS <<    SELECT statement>> GO What is a linked server in SQL Server? It enables SQL server to address diverse data sources like OLE DB similarly. It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions. Features and concepts of Analysis Services Analysis Services is a middle tier server for analytical processing, OLAP, and Data mining. It manages multidimensional cubes of data and provides access to heaps of information including aggregation of data one can create data mining models from data sources and use it for Business Intelligence also including reporting features. Some of the ...
Post a Comment
Read more