What are the strengths of the ASP.NET Web Forms model for building Web applications.

Tuesday, November 12, 2013

· Event model. Web Forms supports an event-driven programming style that is like Windows applications. Many events are available, and they are supported by hundreds of server controls. · State management. Web Forms reduces the complexity of managing state by using view state and server-based controls. · Page-based architecture. Web Forms provides an architecture that combines a page with declarative markup (an .aspx file) with a code-behind file that adds functionality. This structure can make it easy to create pages that implement common tasks, such as responding to user gestures and rendering markup from server code. · Rich set of controls. The ASP.NET community has made available hundreds of server controls and components that reduce development time.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Explain ASP.NET MVC Postbacks ?

ASP.NET MVC framework does not use the ASP.NET Web Forms postback model for interactions with the server. Instead, all end-user interactions are routed to a controller class. This maintains separation between UI logic and business logic and helps testability. As a result, ASP.NET view state and ASP.NET Web Forms page life-cycle events are not integrated with MVC-based views.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

With what feature is the mapping of URLs to the controller classes done in ASP.NET MVC ?

The ASP.NET MVC framework uses the ASP.NET routing engine, which provides flexibility for mapping URLs to controller classes.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How does ASP.NET MVC map URLs to server code ?

The ASP.NET MVC framework maps URLs to server code differently than an ASP.NET Web Forms page. Instead of mapping URLs to ASP.NET pages or handlers, the framework maps URLs to controller classes. Controller classes handle incoming requests, such as user input and interactions, and execute appropriate application and data logic, based on user input. A controller class typically calls a separate view component that generates HTML output as the response.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of MVC ?

What are the LINQ extensions ?

1. LINQ to Objects
2. LINQ to DataSet
3. LINQ to XML
4. LINQ to Entities

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 3 groups created in sharepoint groups?

Tuesday, August 27, 2013

1. Owners 2. Members 3. Visitors

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

SQL Server Indexing Interview Question and Answers - Part 1

Tuesday, June 19, 2012

1. What is a Covering Index ?
An index that is constructed such that SQL Server can completely satisfy queries by reading only the index is called a covering index.
2. What is a Filtered Index ?
A fi ltered index is simply an index with a WHERE clause.
3. What is a Fillfactor ?
To control the rate at which page splits occur, you can specify a fi ll factor for the index. FILLFACTOR specifies the percentage of free space that should be left on the leaf level of an index during creation or rebuild.
4. What happens when an Index is created with ONLINE = ON?
When an index is created using the ONLINE = ON option, SQL Server allows changes to the table during the creation of the index by using the version store within the tempdb database.
5. How much of Data an XML datatype can hold ?
An XML data type can contain up to 2 gigabytes (GB) of data in a single column.
6. What is an XML Index ?
To improve the performance of queries against XML data, you can create a special type of index called an XML index. There are 2 types of indexs : primary and secondary. Primary: A primary XML index is built against all the nodes within the XML column. Secondary : Secondary indexes are created on PATH, VALUE, or PROPERTY.
7. What are Spatial indexes ?
Indexes created on geometry or geography are called Spatial indexes.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is an Covering Index ?

Thursday, June 7, 2012

An index that is constructed such that SQL Server can completely satisfy queries by reading only the index is called a covering index.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maximum no of NonClustered indexes for a table?

1000

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a Forwarding Pointer ?

If SQL Server must move the row by subsequent modifi cations, such as a page split or the row no longer fi ts on the data page, SQL Server does not update the nonclustered index with the new location of the row. Instead, SQL Server creates a forwarding pointer on the data page pointing to the new location of the row.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maxium size of the Index Key?

900 bytes

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maximum columns you can create an Index with ?

16

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a torn page in SQL Server ?

Tuesday, June 5, 2012

Data pages are 8 kilobytes (KB) in size, but SQL Server divides a page into 16 blocks of 512 bytes apiece when performing write operations. If SQL Server begins writing blocks on a page and the disk system fails in the middle of the write process, only a portion of the page is written successfully, producing a problem called a torn page.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How will you track and log damaged pages ?

by enabling the PAGE_VERIFY CHECKSUM option.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the purpose of the transaction log?

Sunday, June 3, 2012

The transaction log records every change that occurs within a database to persist all transactions to disk.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the types of files that you create for databases and what are the commonly used

You can create data and log files for a database. Data files commonly have either an .mdf or .ndf extension, whereas log files have an .ldf extension

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Check pointing in SQL Server ?

If you are adding new data to a database, the new data is first written to a memory buffer, then written to the transaction log, and finally persisted to a data file via a background process called check pointing.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the various types of backups in sql server ?

Wednesday, May 16, 2012

1•Full backups 2•Differential backups 3•File backups 4•Filegroup backups 5.Partial backups 6•Copy-Only backups 7•Mirror backups 8•Transaction log backups

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a failover cluster?

Sunday, May 6, 2012

A group of servers that are in one location and that are networked together for the purpose of providing live backup in case one of the servers fails.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

LinkWithin

Blog Widget by LinkWithin

Recommended Books