Yovant Interview Questions and Answers

Primary key uniquely identifies each record in a table. It cannot be null and there can be only one primary key.

• Primary key ensures each record in a table is unique

• Primary key cannot have null values

• Only one primary key can be defined for a table

• Primary key can be a single column or a combination of columns

Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

• Types of inheritance: Single inheritance, Multiple inheritance, Multilevel inheritance, Hierarchical inheritance, Hybrid inheritance

• Example: Class B inheriting from Class A: class B : A {}

Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.

• OOP focuses on creating objects that interact with each other to solve problems

• Encapsulation, inheritance, and polymorphism are key principles of OOP

• Examples of OOP languages include Java, C++, and C#

Dot Net is a software framework developed by Microsoft for building and running applications on Windows.

• Developed by Microsoft

• Used for building and running applications on Windows

• Supports multiple programming languages like C#, VB.NET, F#

• Consists of a large class library known as Framework Class Library (FCL)

• Includes tools for developing web, desktop, and mobile applications

Dot Net Framework is a software framework developed by Microsoft that provides a controlled programming environment for developing and running applications.

• Developed by Microsoft

• Provides a controlled programming environment

• Used for developing and running applications

Components of Dot Net Framework include Common Language Runtime (CLR), Class Library, and ASP.NET.

• Common Language Runtime (CLR) provides environment for executing .NET programs

• Class Library provides reusable code for common programming tasks

• ASP.NET is a web application framework for building dynamic web sites and web applications

.NET Framework is a software development platform providing tools, libraries, and runtime for building and running applications on Windows.

• Common Language Runtime (CLR): The CLR manages the execution of .NET programs, providing services like memory management, security, and exception handling.

• Base Class Library (BCL): The BCL offers a comprehensive set of classes and APIs for common programming tasks, such as file I/O,...read more

As a DOT NET Developer, I have worked on diverse projects, enhancing my skills in C#, ASP.NET, and database management.

• C# Development: Developed multiple applications using C#, focusing on clean code and best practices, such as a task management system for a client.

• ASP.NET MVC: Worked on an e-commerce platform using ASP.NET MVC, implementing features like user authentication and payment processing.

• Database Management: ...read more

VB.Net is a programming language while MVC is a design pattern for organizing code in web applications.

• VB.Net is a programming language used to develop applications, while MVC is a design pattern used to organize code in web applications.

• VB.Net is a part of the .NET framework, while MVC is a design pattern that separates an application into three main components: Model, View, and Controller.

• VB.Net can be used with or w...read more

The versions of Dot Net include .NET Framework, .NET Core, and .NET 5.

• .NET Framework is the original version of Dot Net, primarily used for Windows applications.

• .NET Core is a cross-platform version of Dot Net, used for developing applications that can run on Windows, macOS, and Linux.

• .NET 5 is the latest version of Dot Net, which combines the features of .NET Core and .NET Framework.

• Other versions include .NET Standar...read more

Types of classes in programming include abstract classes, concrete classes, sealed classes, static classes, and nested classes.

• Abstract classes cannot be instantiated and may contain abstract methods.

• Concrete classes can be instantiated and provide implementations for all methods.

• Sealed classes cannot be inherited.

• Static classes cannot be instantiated and contain only static members.

• Nested classes are defined within an...read more

Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

• Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.

• A class can inherit only one abstract class but can implement multiple interfaces.

• Abstract classes are used to define a common base class for related classes, while interfaces are used to define a contract...read more

Like operator is used in SQL to search for a specified pattern in a column.

• Like operator is used with the WHERE clause in SQL queries.

• It allows for pattern matching using wildcard characters like % and _.

• Example: SELECT * FROM table_name WHERE column_name LIKE 'pattern';

Char is fixed length data type while varchar is variable length data type in SQL.

• Char stores fixed length strings, while varchar stores variable length strings.

• Char is padded with spaces to reach fixed length, while varchar does not pad with spaces.

• Char is faster for fixed length data, while varchar is more flexible for variable length data.

LINQ (Language Integrated Query) is a feature in C# that allows querying data from different data sources using a uniform syntax.

• LINQ provides a set of standard query operators that allow querying data from collections, databases, XML, and more.

• Types of LINQ include LINQ to Objects, LINQ to SQL, LINQ to XML, and LINQ to Entities.

• LINQ queries are written in C# and are executed at runtime, allowing for more flexibility a...read more

HTTP status codes are standardized codes used to indicate the result of a HTTP request.

• HTTP status codes range from 100 to 599

• 1xx - Informational responses

• 2xx - Success responses (e.g. 200 OK)

• 3xx - Redirection messages

• 4xx - Client error responses (e.g. 404 Not Found)

• 5xx - Server error responses (e.g. 500 Internal Server Error)

Filters in MVC are used to perform logic before or after an action method is executed.

• Filters are attributes that can be applied to controller actions or entire controllers.

• They can be used for authorization, logging, exception handling, etc.

• Examples include Authorize, OutputCache, HandleError filters.

MVC is a software architectural pattern for implementing user interfaces.

• MVC separates an application into three main components: Model, View, and Controller.

• Model represents the data and business logic of the application.

• View represents the user interface that displays the data to the user.

• Controller acts as an intermediary between Model and View, handling user input and updating the Model.

• MVC helps in achieving separ...read more