WebApi2 Interview Question

 

1. What is API.
2. What is WebAPI.
3. What is Asp.NET  WebAPI.
4. What is Rest or Restfull architecturure.
5. Naming Convention In WebAPI.
6. What is Routing in WebAPI and How to configure WebAPI.
7. Difference between MVC Controller And WebAPI Controller.
8. What is Parameter Binding  in WebAPI. What is the default parameter binding process and how we can change it.
9. Different types of Http request in Web API and their status code. What is the difference between Http Post and Put request.
10. Action method return type of WebAPI. What is difference between HttpResponseMessage and IHttpActionResult.
11. What is Data Formats in WebAPI. What is difference between Accept and Content-Type attribute. 
12. How we can Authenticate a WebAPI. Difference between Basic Authentication and Token Based Authentication.
13. What is  Media-Type Formatters in WebAPI.
14. How to consume Web API in ASP.NET MVC and what is the difference between WebClient and HttpClient.
15. What is Same Origin Policy of web browser. What is Cross-Origin Resource Sharing (CORS) and how to enable it in WebAPI.
16. What is oData in WebAPI.
17. What Web API versioning.   
18. Difference between Asp.NET WebAPI and Asp.NET MVC
19. Difference between GET and POST request.
20. What is Content Negotiation.

SQL-Server Interview Question.

 

1. What is Database Management System.
2. What is Relational Database Management  System.
3. What is Data Integrity.
4. What is Data Consistency.
5. What is Referential Integrity.
6. What is Cascade Delete.
7. What is Data Anomalies. Types of Data Anomalies.
8. What is Relationship in RDMBS and Different types of Relationship.
9. What is Normalization. Different kind of Normalization.
10. What is Denormalization.
11. Difference .MDF file and .LDF file in SQL-Server.
12. Difference between Attach and Restore in SQL-Server.
13. Difference between DML,DDL,DCL statement in SQL-Server.
14. Difference between Where and Having Clause.
15. Difference between Truncate and Delete command.
16. Difference between Identity and Sequence in SQL-Server.
17. Difference between @@identity, @scopeidentity, and @ident_current.
18. What is Constraints. Different types of Constraints In SQL-Server.
19. What is Primary Key and Foreign Key ad difference between Primary Key and Unique Key.
20. What is Composite Key, Alternate Key, Candidate Key and Super Key in RDBMS.
21. What is Indexes. Different types of Indexes in Sql-Server.
22. Use of Filtered Index, Spatial Index, Fulltext Index, Xml Index, ColumnStore Index in SQL-Server.
23. Difference between Cluster Index and Non Cluster Index.
24. What is Function. Difference types of Function.
25. Difference between Scaler Function and Table Valued Function in SQL-Server.
26. Difference between IsNull() and Coalesec() function.
27. Difference between Cast() and Convert() function in Sql-Server.
28. Difference between Row_Number(), Dense_Rank(),Rank() function .
29. Difference between Floor(),Rand(),Ceiling() function in SQL-Server.
30. Difference between DateDiff(), DatePart() Function in SQL-Server.     
31. What is Procedure .Different types of Procedure in SQL-Server.
32. Difference between Procedure with Output Value and Procedure with Return keyword.
33. Difference between Function and Procedure.
34. What is Trigger in SQL-Server. Difference types of Trigger in SQL-Server.
35. What is Magic Tables in SQL-Server.
36. What is Inserted and Deleted table in SQL-Server.
37. What is Join in SQL-Server. Difference types of SQL-Server.
38. Explain Inner Join, Left Join, Right join, Full-Join, Cross Join .
39. What is Apply operator in SQL-Server. Types of Apply Operator.
40. Difference Between Join and Apply in SQL-Server.
41. What is Union and Union All Operator in SQL-Server.
42. Difference between Union and Union All .
43. Difference between Join and  Apply operator in SQL-Server.
44. What Is Temp table. Difference between local and global temp table.
45. What is View. Types of view in SQL-Server. Benefit of using view in SQL-Server database.
46. What is CTE.
47. What is Cursor in SQL-Server.
48. What is Transaction. Explain ACID properties of Transaction.

 

 

MVC Interview Question

1. What is MVC Pattern. Explain Model ,View and Controller.
2. What is  MVC life Cycle. Four Main Steps in MVC Life Cycle.
3. What is Routing. How routing works. Two Types of Routing in MVC 5.
4. What is Route Constraints. Where we can declare route constraints.
5. What  is filters. Explain five types of filters in MVC5.
6. How many filters default filters provided by MVC5.
7. What is Output Cache Filter. Different types of attribute of Output Cache filter. How many location we can cache the Controller Data.
8. What is Razor View and Razor View Engine in MVC.
9. What is Layout. Difference between RenderBody() and Render Section() Method.
10. What is Partial View. How we can consume Partial View in MVC.
11. Difference between @Html.Partial and @Html.renderpartial method.
12. Difference between @Html.Action and @Html.RenderAction method
13. Difference between Partial View and View. 
14. Difference between ViewBag, ViewData and TempData.
15. Difference between Peek and Keep Method.
16. What is Action Method. Explain different types of Action method provided by MVC5.
17. Difference between ActionResult and JsonResult Action Method.
18. Difference between RedirectToRoute and RedirectToAction.
19. Difference between Redirect and Redirect Permanent.
20. What is Child Action Method.
21. What is Action Selectors in MVC. Explain three types of Action Selectors.
22. Difference between ActionVerb , NonAction,  ActionName attribute in MVC.
23. What is Server side and Client-Side Validation in MVC. How to enable Client side validation in MVC.
24. What is Data Annotation. Different types of Data Annotation in MVC.
25. Difference between Display and Display name attribute in MVC.
26. What is Helper Class in MVC. Different types of Helper class in MVC.
27. Difference between HTML  Helper Class,  Url Hlper Class, Ajax Helper Class in MVC.
28. What is Different type of Html Helper. Difference between @Html.Display and @Html.DisplayFor Helper class.
29. What is Bundling and Minification in MVC.
30. How we can create multiple submit button on single view. 

Entity Framework Interview Question

1. What is ORM.Different types of ORM
2. What is Entity Framework.
3. What is Entity Data Model.Expalin Core Parts of EDM.
4. Expalin Storage Schema Model,Conceptual Model,Mapping. 
5. What is Data Annotaion.Different Types of Data Annotaion.
6. What is entity relationship and types of entity relationship
7. Difference between Seed and Sql Method
8. What is  Lazy ,Eager and Explicit Loading
9. Difference between Code First and DbFirst
10. What is T4 Template
11. What N+1 problem in Lazy Loading
12. What is Context Class
13. Difference between Dbcontext and Object Context Class
14. What is Connected and Disconnected Scenario.

Jquery Interview Question

1. What is jQuery
2. Diff between $(document).Ready() and $(windows).load()
3. What is JQuery.noConflict.
4. What is DOM
5. What is jQuery Selectors
6. What is jQuery Filters
7. What is jQuery Methods
8. Difference between text, html, text ,val method.
9. Difference between empty vs remove method.
10. Difference between append and after method.
11. Difference between $('Selectors').each() and jquery.each() method.
12. What is jQuery ajax method and its attributes
13. What is get,post,load method of jQuery.
14. Difference between get and post request.
15. What is jQuery Method Channing
16. What is Callback function in jQuery
17. What is JSON
18. What is AJAX
19. What is unobtrisive JavaScript
20. How to create and pass an array in ajax method
21. How to create and pas an array of object in ajax method.
22. JSON.parse vs JSON.Stringify