Interview Questions And Answers

BEGIN Transaction

Roll BAck Transaction

Commit Transaction

Save Transaction

Private:
========
private is an access modifier for type members only. private access is the least accessible and such members are only accessible within the body of the containing type.
Note that nested types within the same containing body can also access those private members.

Internal:
--------
internal is an access modifier for types and type members. internal members are accessible only within file of the same assembly. It is an error to reference an internal type or internal type member outside the assembly within which it was declared.

A common use of internal access is in component-based development because it enables a group of components to interact in a private matter without being exposed to the outer world. For example, a Data Access Layer could have several classes with internal members that are only used by the DAL.

Public:

public is an access modifier for types and type members. This is the most permissive access level as there are no restrictions on accessing a public type or type member.

protected:

protected is an access modifier for type members only. A protected member is only accessible within the body of the containing type and from within any classes derived from the containing type

Provides information about current Microsoft® SQL ServerT users and processes

@@IDENTITY
Returns the last identity value created by the current connection.

@@ERROR
Returns the error code for the last T-SQL statement that ran on the current connection. If there is no
error, then the value will be zero.

@@ROWCOUNT

Returns The row count of the previous Executed T-Sql Statement

An abstract class means that the class is intended to be used as a base class.
Note the following features of abstract classes:
.An abstract class cannot be instantiated.
.An abstract class may contain abstract methods and properties.
.A non-abstract class that derives from an abstract class must implement all inherited abstract methods and properties. (if any).
.An abstract class must provide implementation for all interface members

WCF offers more flexibility,reliability over web service as it supports Named pipes, Message Queuing,http, tcp etc. protocols.

Web service only supports http.

WCF can be hosted in IIS, windows activation service, Windows service etc.

Web Service can only be hosted in IIS.

WCF uses system.runtime.serialization for Data Serialization which again provides performance benefits as compared to System.Xml.serialization which web service uses for data serialization.

Also WCF provides more security as compared to Web Service.It has all the power of .net Remoting,Message Queuing etc.

The SPSite object represents a collection of sites i.e. a top level sites and all its subsites.
The SPWeb object represents an instance SharePoint Web, and SPWeb object contains things like the actual content. s

Content Editor Web Part

Data View Web Part

List View Web Part

Image Web Part

Members Web Part .

Page Viewer Web Part

Form Web Part

XML Web Part

Microsoft.SharePoint.WebPartPages.WebPart is provided in MOSS 2007 to provide backwards compatability with MOSS 2003 webparts. In MOSS 2007, it is recommended to use System.Web.UI.WebControls.WebParts.WebPart instead.

System.Web.UI.WebControls.WebParts.WebPart does not provides a feature to get or provide to to other webparts.