SharePoint 2010 Common Interview Qustions and Answers

What is SharePoint ?	Microsoft has given this SharePoint, which is a browser based document collaboration platform. It is an application framework, and it is an application as its own. It is a platform where user can share Data, Collaborate and people can also take this platform and customized platform as per their requirements.
What is the differences between Library and  List?	Library is used to store the document whereas Lists are the container of similar items in the form of rows and columns. In Library you can create core document like Word, Excel, and PowerPoint. But in List You cannot create document, instead of that you can attach document in a particular List.
what is a web part?	Web parts consist of xml queries to full SharePoint lists or document libraries. You can also develop your own web parts and web part pages.
What is WSS and MOSS?	Microsoft has divided SharePoint products into two parts. One is called WSS (Windows SharePoint Services) and the other is MOSS (Microsoft Office SharePoint Server). WSS is the platform in which MOSS is built. The WSS part is licensed through Windows 2003 Server and it does not cost anything. MOSS is a separate product by itself and needs licensing and it has a significant cost. WSS is good for small teams and small projects. MOSS has extra functionalities, in other words, Value Added Services.
What is  site collection?	Site collection and sites represent the site hierarchy when you create a new site or extend an existing one. A site collection is a set of web sites. Every site collection has top-level site, created when the site collection is created.
What is Site Definition?	Site Definitions are stored on the hard drive of the SharePoint front end servers, which are used by the SharePoint application to generate the sites users can create
What is Site Templates?	Site Templates are created by users as a copy of a site they have configured and modified so that they do not have to recreate lists, libraries, views and columns every time they need a new instance of a site.
What are Site Columns ?	Site columns are pre-defined data columns which are re-used in various content types. A Content type is usually a collection of site columns. For e.g. you can create a site column "Gender" with a choice datatype along with the pre-defined values "male","female". This column then can be added to any content type in your list or library.
What are the main features of SharePoint 2010?	1) Large lists 2) Document Collaboration 3) Enterprise Search FAST Search 4) Silver Light web part 5) New Enhance Web Part 6) Business Connectivity Services 7) Social Media Investments 8) Enhanced collaboration features 9) Usage reporting and logging 10) Visio Services 11) Better Network Differencing & SharePoint Offline in SharePoint Workspace 12) High Availability/ Disaster Recovery Innovation 13) SharePoint Designer Enhancements like portable workflows, and granular delegation 14) Sandbox Solutions 15) Service Applications
What are Field Controls?	Field controls will provide the basic field functionality of SharePoint .They are ASP.NET 2.0 server controls. They also provide basic general functionality such as displaying or editing list data as it appears on SharePoint list pages.
What is the difference between SharePoint Portal Services (SPS) and  SharePoint Team Services (STS)? Which is more advantageous?	1)    SharePoint Portal Services (SPS) has much better document management. It has check-in, check-out, versioning, approval, publishing, subscriptions, categories, etc. STS does not have these features, or they are very scaled back. 2)    SharePoint Portal Services (SPS) has a better search engine, and can crawl multiple content sources. STS cannot. 3)    STS is easier to manage and much better for a team environment where there is not much Document Management going on. 4)     SPS is better for an organization, or where Document Management is crucial.
What is CAML ?	CAML stands for Collaborative Application Markup Language and is an XML-based language that is used in Microsoft Windows SharePoint Services to define sites and lists, including, for example, fields, views, or forms, but CAML is also used to define tables in the Windows SharePoint Services database during site provisioning.
What is Central Administration ?	After the  installation of  SharePoint 2010, a separate site collection is created for your use in performing the different administrative functions that you might do on a daily basis. This site collection is called the Central Administration site. This site collection is run as its own Web application in IIS and is separate from the site collections you create. All farm server administrators can access this site, and, much like your regular SharePoint sites, you can edit and customize the Central Administration site. So it is mainly used by admins to mange and configure settings for SharePoint web applications or the whole farm.
What is the Farm in SharePoint?	Farm is a collection of SharePoint servers having the same configuration database.( Configuration DB stores all the required information to run the farm).  Each farm is administered through a central administration .There is only one configuration database per farm.
What is Sandbox solutions?	We can create sandbox solution for particular site but not for the entire site collection or farm. Sandboxed solutions enable developers to have more control over their site collections. The challenge was creating and deploying solutions you could trust not to do bad things to the SharePoint farm. With sandboxed solutions, site collection administrators have the authority to manage the applications (or delegate that authority to others) in their site collection. And developers have more flexibility, at the cost of using a limited subset of SharePoint, to create solutions they know will be deployed in a safe and rapid manner
What is the difference between Site Page and Application Page?	Site pages are customized pages and are saved in the content database. So when you use the SharePoint designer to make custom changes, it saves the changes into the content database. If you want to make generic pages in a site collection which will be used by everyone, like for instance the ‘mypage.aspx’ page, then you need to use application pages. In other words, Site pages are nothing but customized pages stored in content, while Application pages are generic pages which will be used by all the sites in a site collection.
What is meant by Secure Store Service (SSS) ?	Secure Store Service is nothing but a secure database for storing credentials that are associated with application IDs.
What are  Content types	A content type is a flexible and reusable WSS type definition that defines the columns and behavior for an item in a list or a document in a document library. E.g : you can create a content type for a customer presentation document with a unique set of columns, an event handler, and its own document template. Content type can be created by the following • from the rootweb of a site collection, go to Site Action > Site Settings > Galleries > Site content types • using a feature
What is the difference between Syncronous & Asyncronous events?	Syncronous calls ending with 'ing' E.g. ItemDeleting Event Handler code execute BEFORE action is committed WSS waits for code to return Option to cancel andreturn error code Asyncronous calls ending with 'ed' E.g. ItemDeleted Event Handler code executes AFTER action is committed WSS does not wait for code to return Executed in its own Worker thread.
How to query from multiple lists ?	Use SPSiteDataQuery to fetch data from multiple lists.
What are the various kinds of roles the users can have?	A user can be assigned one of the following roles     * Reader  : Has read-only access to the      Web site.     * Contributor :  Can add content to existing document libraries and lists.     * Web Designer :  Can create lists  and document libraries and customize pages in the Web site.     * Administrator : Has full control of the Web site.
What types of SharePoint assets can be deployed with a SharePointfeature	With Features we can do a lot. For example, you could deploy as follows     * Simple site customizations     * Custom site navigation     * WebParts     * pages     * list types     * list instances     * event handlers     * workflows     * custom actions
What are event receivers?	Event receivers are classes that inherit from the SpItemEventReciever or SPListEventReciever base class (both of which derive out of the abstract base class SPEventRecieverBase), and provide the option of responding to events as they occur within SharePoint, such as adding an item or deleting an item . SPListEventReceiver, SPItemEventReciever, and SPWebEventReceiver inherit from the abstract base class SPEventReceiverBase. SPWorkflowLibraryEventReceiver inherits from SPItemEventReceiver. SPEmailEventReceiver inherits directly from System.Object
What are the built in ways to backup a SharePoint install?	Through the central administration and the stsadm command
What are the differences between the two base classes ?	The difference is the Microsoft.SharePoint.WebPartPages.WebPart base class is meant for backward compatibility with previous versions of SharePoint. The benefit of using the SharePoint WebPart base class is it supported:     * Cross page connections     * Connections between Web Parts that are outside of a Web Part zone     * Client-side connections (Web Part Page Services Component)     * Data caching infrastructure
how can debugging share point application  ?	1. build application place .dll into gac and reset iis    2. On the Debug menu, select Attach to Process    3. select the Show processes from all users check box.    4. select W3Wp.exe can attach    5. refresh sharepoint site point break point
What is the difference between SPListItem.SystemUpdate andSPListItem.Update Method SPListItem.SystemUpdate	Updates the database(Sharepoint list) with changes that are made to the list item, without effecting changes in the Modified Time or Modified By fields. SPListItem.SystemUpdate Overloaded Method: SPListItem.SystemUpdate(): Updates the database with changes made to the list item, without effecting changes in the Modified or Modified By fields. SPListItem.SystemUpdate(Boolean): Updates the database with changes that are made to the list item, without effecting changes in the Modified Time or Modified By fields, or optionally, the item version. SPListItem.Update(): Updates the database(Sharepoint list) with changes that are made to the list item/new version of item, and changes in the Modified Time or Modified By fields. //Take the reference of that item           SPListItem listItem = listItemCOll[icount];           listItem["FIRST_NAME"] = “Jagan”;           listItem["LAST_NAME"] = “Mohan”;           listItem["EMAIL_ADDR"] = “jaganinfoway[at]gmail.com”;           //Update the Item           listItem.SystemUpdate(false); //The argument false informs the SP object Model not increment versions.           listItem.Update();
How could you append a string to the title of a site when it is provisioned?	In the OnActivated event:           SPWeb objWeb = siteCollection.RootWeb;           objWeb.Title += "JaganInfo.com";           objWeb.Update();
How would you loop using SPList through all SharePont List items, assuming you know the name (in a string value) of the list you want to iterate through, and already have all the site code written?	SPList interviewList = rootWeb.Lists["listtoiterate"];           foreach (SPListItem interview  in interviewList)           {                    // Append the code as per your requirement           }
How do you connect to a SharePoint list and insert a new List Item?	using(SPSite rootSite = new SPSite("http://jaganinfo-pc:1234/")) {           using(SPWeb objWeb = mySite.OpenWeb())           {                    SPList interviewList = myWeb.Lists["listtoinsert"];                    SPListItem newItem = interviewList.Items.Add();                    newItem["interview"] = "interview";                    newItem.Update();           } }
Difference SPSite and SPWeb object	The SPSite object represents a collection of sites (site collection [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. A SPSite object contains the various subsites and the information regarding them.       SPSite rootSite = new SPSite("http://jaganinfo-pc:1234/");        SPWeb objWeb = rootSite.OpenWeb();