Monday, April 23, 2018


1. Join Vs In Vs Exist , make the priority performance wise
Ans Join Exist In
2. CTE advantage
And In memory representation of table, do not save in database
3. Temp table Vs Table Vairbale difference
4. Life Cycle Hook of Angular
5. What is sliding time expiration? How to kill cookie?
6. Func Vs Action
7. What is Java Script Closure?
8. Var Vs let 
9. Function Hosting
10. What is the role of Enumerator in IEnumerable?
Ans : 

IEnumerable interface represents an object that can be enumerated, like the List class here. It has one method:

public interface IEnumerable
    IEnumerator GetEnumerator();
The GetEnumerator method here returns an IEnumerator object, which can be used to iterate (or enumerate) the given object. Here is the declaration of the IEnumerator interface:

public interface IEnumerator
    bool MoveNext();
    object Current { get; }
    void Reset();


11. AOT compiler?
12. MVVM and MVC difference
13. Mock framework and AutoFac?
14. Task Runner?

Compile Sass into CSS
Run Autoprefixer on the new CSS to catch any vendor prefixes we may have missed
Minify the prefixed CSS
Update our CSS banner with new timestamp information

Check our Javascript for errors
Concatenate other included scripts into one file
Recheck for errors
Minify Scripts

Optimize any jpg, gif, or png to make the file size smaller

Other Utilities
Watch files for changes and rerun tasks as needed

Run BrowserSync for testing in multiple browsers and devices at once

15. How to unit test http response in angular?
Ans : Using HttpClientTestingModule and  HttpTestingController

16. Dispose method?
17. Query Optimization technique?
18. Model Binder?
19. Http Helper in MVC?

 Using the HTML Helper class, we can create HTML Controls progammaticrally. HTML Helpers are used in View to render HTML content. HTML Helpers (mostly) is a method that returns a string. It is not mandatory to use HTML Helper classes for building an ASP.NET MVC application. We can build an ASP.NET MVC application without using them, but HTML Helpers helps in the rapid development of a view. HTML Helpers are more lightweight as compared to ASP.NET Web Form controls as they do not use ViewState and do not have event models.

HTML Helpers are categorized into three types:

Inline HTML Helpers
Built-in HTML Helpers

Custom HTML Helpers

20. Http Handler?
21. Action Filter ? and How to create custom action filter?
22. Commnication between controllar in MVC?
23. Delete Vs Truncate
24. Union Vs Union All
25. How to share service in Multiple Component?
26. Extension method? Advantage of Extension method?
27. What is directive and how to create custom directive?
28. Routing in angular?
29. Give an example of Open Close Principle?
30 Give an example of Interface Sgregation principle?
31. What is TDD , How to write unit test if we have CRUD operation of a table?
32. How to get value from XML if we have employee information in xml in C#.
33. Write a regular expression for mobile number validation.
34. Store Procedure Vs Function.
35. What is .md file in angular?

36. Can we overload private constructor?
Ans: Yes

37. Can we overload static constructor?
Ans : No

38. If have not call dispose method explicitly then what will happen.
Ans: Will not call if not created object in using block.

39. What is async pipe in angular?
40. What is CTE?

Common Table Expression is used to store temporary results of single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement defined within the execution scope. Even though it lasts until the execution of query, it can be self referenced multiple times in the same query. CTE allows query to be single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement to improve readability. CTE be used to replace a view which stores the metadata.

41. What is the benefit of CTE?

Can be used to create a recursive query.
Can be substituted for a view
Allow grouping by a column which might be derived from a scalar subset
Can reference itself multiple times

42. Write the syntax of CTE?

No comments: