0% found this document useful (0 votes)
9 views11 pages

Comprehensive Guide to .NET, SQL, and React

The document contains a comprehensive list of technical topics and questions related to OOP, SQL, MVC, .NET Core, React, and Angular. It covers concepts such as abstraction, async/await, dependency injection, SOLID principles, and various database keys and operations. Additionally, it addresses differences between programming constructs and frameworks, as well as specific features in React and Angular.

Uploaded by

ekta.thakur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views11 pages

Comprehensive Guide to .NET, SQL, and React

The document contains a comprehensive list of technical topics and questions related to OOP, SQL, MVC, .NET Core, React, and Angular. It covers concepts such as abstraction, async/await, dependency injection, SOLID principles, and various database keys and operations. Additionally, it addresses differences between programming constructs and frameworks, as well as specific features in React and Angular.

Uploaded by

ekta.thakur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

OOPS

SQL

MVC

Core

React
Angular
What is Abstraction and How to implement it?
What is the difference between an Abstract class and an Interface (atleast 4)?

What is the role of Async and Await?


Access modifiers
What is Static constructor?
Can we restrict object creation in C#?

What is the difference between Primary key, foreign key and Unique key?
Joins
SP vs Functions
What are Triggers and types of triggers?
What is a View?
What are Indexes in SQL Server?
What is CTE in SQL Server?
What is the difference between Delete, Truncate and Drop commands?

What is Authentication and Authorization in [Link] MVC?


What are the different return types of a controller Action method?
What are Filters and their types in MVC?
What is the difference between ViewData, ViewBag & TempData?

What are the advantages of .NET Core over .NET framework?


What is Dependency Injection?
How to implement Dependency injection in .NET Core?
What is AddSingleton, AddScoped and AddTransient method?

What are SOLID Principles? What is the difference between SOLID Principles and Design Patterns?
Any design pattern

What is JSX?
What are the differences between functional and class components?
What is the virtual DOM? How does react use the virtual DOM to render the UI?
What is React Hooks?
What is React Router?
Explain about types of Hooks in React.
Redux
What are Single Page Applications (SPA)?
What are directives in Angular?
Explain Components, Modules and Services in Angular
What is data binding in Angular?
What are Decorators and their types in Angular?
What are annotations in Angular ?
In Angular, components are the basic building blocks, which control a part of the UI for any application.
A module is a place where we can group components, directives, services, and pipes. Module decides whe
Services are objects which get instantiated only once during the lifetime of an application. The main object
e used by other modules, by exporting or hiding these elements. Every module is defined with a @NgModule decora
with different components of an Angular application.
with a @NgModule decorator.
OOPS

MVC

.Net Core

SQL

React

Angular
What is Abstraction and How to implement it?
What is the difference between an Abstract class and an Interface (atleast 4)?
What is the role of Async and Await?
Access modifiers
What is Static constructor?
Can we restrict object creation in C#?

What is Authentication and Authorization in [Link] MVC?


What is the difference between ViewData, ViewBag & TempData?
What are Filters and their types in MVC?
What are the different return types of a controller Action method?

What are the advantages of .NET Core over .NET framework?


What is Dependency Injection? How to implement Dependency injection in .NET Core?
Middlewares
What is AddSingleton, AddScoped and AddTransient method?

What are SOLID Principles? What is the difference between SOLID Principles and Design Patterns?
Any design pattern

What is the difference between Primary key, foreign key and Unique key?
What are Joins ? What are various type of joins?
SP vs Functions
What are Triggers and types of triggers?
What is a View?
What are Indexes in SQL Server?
What is CTE in SQL Server?
What is the difference between Delete, Truncate and Drop commands?

What is JSX?
What are the differences between functional and class components?
What is the virtual DOM? How does react use the virtual DOM to render the UI?
What is React Hooks?
What is React Router?
Explain about types of Hooks in React.
Redux

What are Single Page Applications (SPA)?


What are directives in Angular?
Explain Components, Modules and Services in Angular
What is data binding in Angular?
What are Decorators and their types in Angular?
What are annotations in Angular ?
Vikash
y
y

n
n

n
n

y
y
y

n
y

Common questions

Powered by AI

Dependency Injection in .NET Core allows for the inversion of control where the responsibility of managing dependencies is transferred from the application to a container. It is implemented by specifying dependencies in the constructor of a class and using built-in IServiceCollection methods like AddSingleton, AddScoped, and AddTransient to register these dependencies. This promotes loose coupling and enhances testability and maintainability .

Single Page Applications (SPAs) load a single HTML page and dynamically update content as users interact with the app, without needing to refresh the entire page, which enhances user experience by providing faster interactions and smoother performance. Traditional multi-page applications load separate pages from the server, leading to slower navigation. However, SPAs may face challenges such as SEO optimization due to its single-page nature and greater reliance on JavaScript, which can increase initial loading times. They often need complex routing and state management solutions .

Joins in SQL are used to combine records from two or more tables in a database based on a related column. The various types of joins include 'INNER JOIN', which returns records with matching values in both tables; 'LEFT JOIN' (or 'LEFT OUTER JOIN'), which returns all records from the left table and matched records from the right table; 'RIGHT JOIN' (or 'RIGHT OUTER JOIN'), which does the reverse; and 'FULL JOIN', which returns all records when there is a match in either table .

SOLID principles are a set of five design principles intended to make software designs more understandable, flexible, and maintainable. They include the Single Responsibility Principle, Open/Closed Principle, Liskov Substitution Principle, Interface Segregation Principle, and Dependency Inversion Principle. These principles focus on solving common issues found in software development. In contrast, design patterns are typical solutions to common problems in software design. They provide a reusable template to solve a recurring design problem, whereas SOLID principles offer a guideline to maintain best practices during software development .

React Hooks are functions that let you use state and other React features in functional components instead of class components. The primary Hooks include 'useState' for stateful logic, 'useEffect' for handling side effects, 'useContext' for context API accessibility, and 'useReducer' for more complex state logic similar to Redux. There are also other Hooks like 'useCallback', 'useMemo', and 'useRef' that help optimize performance and manage DOM interactions .

In SQL, a primary key is a unique identifier for each record in a table, ensuring no duplicate values and not allowing NULLs. A foreign key is a field in one table that uniquely identifies a row of another table, creating a relationship between the two tables. It helps maintain referential integrity and can include duplicate values. A unique key, like a primary key, also prevents duplicate values but allows a single NULL value .

Middleware in ASP.NET Core are software components that form an application pipeline to handle requests and responses. Middlewares are executed sequentially, and each can either process a request, pass it to the next middleware, or return a response directly. Examples include authentication, logging, error handling, and static file serving middlewares. They provide a modular approach to handling application features .

JSX, or JavaScript XML, is a syntax extension for JavaScript used in React. It looks similar to HTML and is used to describe the UI appearance. JSX makes code easier to read and write than plain JavaScript and allows developers to incorporate JavaScript logic and expressions within the markup. It also provides developer-friendly features such as type errors during compilation and integration with existing tooling .

'Async' and 'Await' facilitate asynchronous programming by allowing code execution to continue without blocking a thread. 'Async' is a keyword used to declare that a method is asynchronous, meaning it contains one or more 'Await' statements. 'Await' is used to indicate that a program should wait for a particular task to finish before continuing with the subsequent lines of code, making the code non-blocking and improving responsiveness, especially in UI applications .

An abstract class can contain implementation of methods, fields, and meethods with access modifiers, whereas an interface cannot include any implementation and all methods are implicitly public. Abstract classes can have constructors, unlike interfaces which do not allow constructors. A class can implement multiple interfaces but only inherit from one abstract class. Interfaces are used to implement a contract; abstract classes are used when there are shared behaviors among different classes .

You might also like