Ashwani .Net

MVC Interview Questions What is MVC Application life cycle ? What is default route in MVC? What is Output Caching ? What are Route Constraints in MVC? What are the Benefits of Area in MVC? How do you implement Forms authentication in MVC? What are the Main Razor Syntax Rules? Define attribute based routing in MVC? What are HTML helpers in MVC? What does the MVC pattern define with 3 logical layers? What are the advantages of MVC? List the various return types of a controller action method. What are the types of filters? What are the Filters in MVC? What are the three segments for routing important? What is Route in MVC? what is the difference between ViewData and ViewBag? attribute based routing in MVC? What is GET and POST Actions Types? What is MVC (Model view controller)? What is Validation Summary in MVC? What’s new in the latest version of MVC? How to render html in Asp.net MVC view? Explain the concept of MVC Scaffolding? What is Bundling and Mini...

Q#51. What is   SQL Server used for? Ans.  SQL Server is one of the very popular Relational Database Management Systems. This is a product from Microsoft to store and manage the information in the database. Q#52. Which language is supported by SQL Server? Ans.  SQL Server is based upon the implementation of the SQL also known as Structured Query Language to work with the data inside the database. Q#53. Which is the latest version of SQL Server and when it is released? Ans. SQL Server 2017  is the latest version of SQL Server that is available in the market and Microsoft launched this on  2 October 2017  with the support of the Linux O/S. Q#54. What are the various editions of SQL Server 2017 that are available in the market? Ans. SQL Server 2017 is available in 4 editions. These are as follows: Enterprise:  This supports in leading the high performance for  the Tier 1  database along with the capability of supporting busi...

Q#26. Can we rename a column in the output of SQL query? Ans.  Yes by using the following syntax we can do this. SELECT column_name AS new_name FROM table_name; Q#27. What is the difference between a Local and a Global temporary table? Ans.  If defined in inside a compound statement a local temporary table exists only for the duration of that statement but a global temporary table exists permanently in the database but its rows disappear when the connection is closed. Q#28. What is the SQL Profiler? Ans.  SQL Profiler provides a graphical representation of events in an instance of SQL Server for the monitoring and investment purpose. We can capture and save the data for further analysis. We can put filters as well to captures the specific data we want. Q#29. What do you mean by authentication modes in SQL Server? Ans.  There are two authentication modes in SQL Server. Windows mode Mixed Mode – SQL and Windows. Q#30. How can we check th...

-------------------------------------------------------------------------------------------------------- Q#1. Which TCP/IP port does SQL Server run on? Ans.  By default SQL Server runs on port 1433. Q#2. What is the difference between clustered and a non-clustered index? Ans. A clustered index  is an index that rearranges the table in the order of index itself. Its leaf nodes contain data pages. A table can have only one clustered index. A non-clustered index  is an index that does not re-arranges the table in the order of index itself. Its leaf nodes contain index rows instead of data pages .  A table can have many non-clustered indexes. Q#3. List the different index configurations possible for a table? Ans.  A table can have one of the following index configurations: No indexes A clustered index A clustered index and many non-clustered indexes A non-clustered index Many non-clustered indexes Q#4. What is the recovery model? List t...

           •   1 What is AngularJS?            •   2 What is Angular and what are the various versions of Angular?            •   3 Why was version 3 skipped?            • 4 Why we need Angular?            • 5 What is the problem in Angular JS so we are using Angular?            • 6 Which language we can use with Angular for Component creation?            • 7 What is need of TypeScript in Angular?            • 8 Can I use another language except TypeScript for Angular?            • 9 What is Angular CLI?            • 10 Why we are using Angular CLI while we have another method for Angular application creation?         ...