my prepare

 


Angular

------

1) What is a Single Page Application (SPA)?

2) What are the types of data binding in Angular?

3) What are directives in Angular?

4) What is a component in Angular?

5) What are the component lifecycle hooks in Angular?

6) What is the difference between a Promise and an Observable in Angular?

7) What is transpiling in Angular?

8) What are the types of decorators in Angular?

9) How do you share data between components in Angular?

10) What is lazy loading in Angular?

11) How do you send data from an Angular service to a Web API?

12) What are interceptors in Angular, and what are their use cases?

13) What are Angular guards, and how are they used?

14) What is DOM sanitization in Angular?

15) What is a standalone component in Angular?


C# .net:

-------

1) What is interfaces vs class vs abstract class in C#?

2) Explain the difference between abstraction and encapsulation.

3) What is polymorphism in C#?

4) What is inheritance ?

5) What are the access modifiers available in C#?


6) Explain the difference between the static and const keywords.

7) What is the difference between a Thread and a Task in C#?

8)What are the benefits of using Task over traditional threading?

9) What is the purpose of async and await in C#?

10) Can we have multiple catch blocks in exception handling?

 

11) Can async methods return void? When should they?

12) What is Task.WhenAll in C# and how does it work?

13) What is Task.WhenAny in C# and how does it work?

14) What’s the difference between Parallel.ForEach and Task.WhenAll?

15) What is deadlock in asynchronous code and how can it be avoided?

16) Explain the SOLID principles in software development?.



WebAPI:

------

1) What is a Web API and why we use it?

2) What are RESTful APIs?

3) Main HTTP methods in REST?

4) PUT vs. POST?

5) what are Web API Return Types in ASP.NET Core?

6) What is content negotiation in Web API?

7) What Are Route Constraints in ASP.NET Core Web API?

8) What is an endpoint?

9) How do you secure a Web API?

10) what is authentication and Authorization?

11) What is JWT?

12) What is CORS and how to handle it?

13) explain constructor and its use?

14) What is dependency injection and how is it implemented in Web API? single ton vs scoped vs transient?

15)How do you send data from a .NET Core application to SQL Server?





SQL:

----

1) What is a primary key and What is a foreign key?

2) What are constraints?

3) What is a subquery?

4) What is the difference between DELETE and TRUNCATE?

5) Explain the SELECT statement.

6) what are aggregate functions in sql

7) What are the different types of joins?

8) What is a self-join?

9) What are indexes? Why are they important?

10) What is the difference between clustered and non-clustered indexes?

11) What are Common Table Expressions (CTEs)?

12) What is TVP?

13) How do you handle NULL values in SQL? 

14) Explain CASE STATEMENTS IN SQL?

15) write a query to get duplicate records in SQL table?.




Program 1: 

Write a C# program Remove Duplicates from an Array

Input: [1, 2, 2, 3, 4, 4, 5]

Output: [1, 2, 3, 4, 5]


Program 2: 

Write a C# program  Find All Subarrays With Sum Equal to a Target

Input: [1, 2, 3, 4, 2], target = 5

Output: [2,3], [1,4]




---------------------------


azile methodology ,sprint,team size



1) Angular:

-----------

What is Angular CLI?

What are Single Page Applications (SPA)?

What are templates in Angular?

What are directives in Angular?

What is data binding in Angular?How many ways we can bind data?

What is two way data binding in Angular?

What is Change Detection, and how does the Change Detection Mechanism work?

What is a service in Angular?

How many types of compilation Angular provides?uses?

What are HTTP interceptors ?

What are lifecycle hooks in Angular? Explain a few lifecycle hooks.

What are property decorators?why do we need?

What are Method decorators?

What is Eager and Lazy loading?

What are Angular Guards?

What are pure pipes & impure pipes in angular?

how do you send an object to web api from angular?


2)C# .net:

---------

What is inheritance? Does C# support multiple inheritance?

What are the different ways in which a method can be Overloaded in C#?

Describe Accessibility Modifiers in C#?

What is interfaces vs class vs abstract class in C#?

What are Generics in C#?

What is the difference between an Array and ArrayList in C#?

What is enum in C#?

What is the difference between ref and out keywords?

What are Properties in C#?

What is the difference between constant and read-only in C#?


What is the difference between a Thread and a Task in C#?

What is the purpose of async and await in C#?

What is Multithreading with .NET?

What is deadlock in asynchronous code and how can it be avoided?


What is LINQ in C#?

What are sealed classes in C#?


What is a Virtual Method in C#?

Array and ArrayList?

Explain the SOLID principles in software development?




3)WEB API:

---------


What is Web API and  RESTful APIs?

what are Web API Return Types in ASP.NET Core?

what are Web Api filters?

can you explain  diff b/w frombody vs fromquery

What Are Route Constraints in ASP.NET Core Web API?

Dependency injection and its types  : singleton vs scopped vs transiant

explain constructor and its use?

use of cors and How can you enable CORS in Web API?

How do you send data from a .NET Core application to SQL Server?

what is middleware?

what is the purpose of appsettings.jos and program.cs in .net core?

what is loosly coupled and tightly coupled?

what is serialization and what its uses?

difference between throw and throw ex?

what is Iquerable and Ienumerable?

how do you remove duplicate characters from string?


4)SQL:

------

 



 What is a primary key and What is a foreign key?

 What is the difference between clustered and non-clustered indexes?

 Explain CASE STATEMENTS IN SQL?

 

 What are the different types of joins?

 WRITE INNER JOIN INSQL?

 WRITE INNER self join?

 What is the difference between DELETE and TRUNCATE?

 What are sql constraints?

 what are aggregate functions in sql?

 

 How do you handle NULL values in SQL?

 what is SP ? Can we can SP in Function ? 

 Can we call Function in SP ? 

 write a query to get duplicate records in SQL table?

 What is a Common Table Expression (CTE) 

 What is Table-Valued Parameter  (tvp)



 find out 2nd highest salary with given employee table?



5) PROGRAMS:

------------

1) How to sort array value in c# and  999=>27 =>9








Comments