DOT Net Telephonic Round Interview questions for 6+ Years of experience along with the skills C#.Net, MVC, SQL Server & jQuery

1. Can you briefly introduce yourself and your technologies?
2. Can you explain MVC page life cycle?
3. What is Routing concept in MVC?
4. Why we need Routing? If we don’t define routing what will happen?
5. How requested page will display in MVC application? What is difference which we can observe if we request for ASP.Net page vs MVC application page.
6. How to pass data from Controller to view?
7. What is the difference between View Data & View Bag?
8. What the difference between table variable & Temp data?
9. What are aggregate functions in C#?
10. What is Reflection?
11. What are the stored procedures why we need them?
12. What is the Difference between stored procedure & Inline queries?
13. What are the indexes? How many types of Indexes are there in SQL Server?
14. What are views? Can we create Indexes on Views?
15. What are Indexed Views in SQL Server?
16. What are the queries available for string separation in SQL Server?
17. What are aggregate functions in SQL Server?
18. What is jQuery and why we need jQuery?
19. Give some functions available in jQuery?
20. What is the purpose of each keyword in jQuery?
21. What is the JSON?
22. What is the difference between JSON & XML which is faster? Why?
23. I am having a bulk data which I have to insert into table, you use temp table or table variable which is best option?
24. What is unique key? What is the difference between Primary Key & Unique Key?

Anuradha.Kalahasthi