BASIC INTERVIEW QUESTIONS:
In this blog post we will be sharing Interview Questions related to Microsoft SharePoint 2010. Let’s start from the basic to the most advanced interview questions.
1. What is SharePoint 2010?
SharePoint was born out of a simple idea: “Sharing Documents”. Microsoft developed family of `software products called “SharePoint”, to perform features like File Sharing, Collaboration, and Web Publishing. In simple terms, SharePoint acts as the single platform to share, communicate, store, and collaborate the content, documents, and records.
2. What does SharePoint 2010 family of products consists of?
- SharePoint Foundation 2010
- Search Server 2010 Express
- SharePoint Server 2010
- Search Server 2010
- FAST™ Search Server 2010 for SharePoint
- SharePoint Designer 2010
3. What are the new features in Sharepoint?
1- Access Services: Use Access Services in Microsoft SharePoint Server 2010 to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an Internet browser.
2- Business Connectivity Services: SharePoint Server 2010 include Microsoft Business Connectivity Services, which is a set of services and features that provide a way to connect SharePoint-based solutions to sources of external data and to define external content types based on that external data
3- Central Administration: Central Administration has been redesigned in SharePoint Server 2010 to provide a more familiar experience
4- Digital Asset Management: SharePoint Server 2010 includes a new asset library specially designed for managing and sharing digital assets such as audio, video, and other rich media files. 5- Enterprise Search (Fast Search): With the new capabilities in SharePoint Server 2010, search administrators can configure an optimal search infrastructure that helps end users find information in the enterprise quickly and efficiently.
6- Excel Services: Excel Services in SharePoint 2010 can be used to publish Excel client workbooks on SharePoint Server 2010
7- Health Monitoring: SharePoint Server 2010 includes an integrated health analysis tool called SharePoint Health Analyzer that enables SharePoint Server to automatically check for potential configuration, performance, and usage problems
8- Managed Metadata: The Managed Metadata Service supports the use of managed metadata, as well as the sharing of content types across the enterprise.
9- Performance Point Services: Performance Point Services in Microsoft SharePoint Server 2010 provides flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs
10- Records Management: In SharePoint Server 2010, user can manage records in an archive, or can manage records in the same document repository as active document
11- Sandboxed Solutions: User can deploy sandboxed solutions to quickly and more securely solve business problems. Sandboxed solutions are like farm solutions except in the following ways: they are rights-restricted and have a more permissive deployment policy than farm solutions; they are limited to the site collection to which they are deployed;
12- Social Computing: SharePoint Server 2010 includes social networking tools such as My Site Web sites and social content technologies such as blogs, wikis, and really simple syndication (RSS). These features are built upon a database of properties that integrates information about people from many kinds of business applications and directory services
13.1: Visual Upgrade: A new feature that is available with upgrade allows the server administrator or site owner to determine when and if the new look for SharePoint Server 2010 is used for a particular site collection. Server administrators can choose to adopt the new look and feel for all sites during upgrade, let site owners make the choice after upgrade, or keep the old look and feel for all site
13.2: Feature Upgrade: SharePoint Foundation 2010 provides new members and types that make it possible for user to upgrade custom Features through versioning and declarative upgrade actions. User can update any Features created for Office SharePoint Server 2007 to work with SharePoint Server 2010 by using these members.
14- Visio Services: The Visio Graphics Service is a service on the SharePoint Server 2010 platform that enables users to share and view Visio diagrams and enables data-connected Microsoft Visio 2010 diagrams to be refreshed and updated from a variety of data source
15- Windows Power Shell: Windows Power Shell is the new command-line interface and scripting language specifically designed for Admin
4. What are the various built in columns available in SharePoint 2010?
1. Single line of text
2. Multiple lines of text
3. Choice (menu to choose from)
4. Number (1, 1.0, 100)
5. Currency ($, ¥, €)
6. Date and Time
7. Lookup (information already on this site)
8. Yes/No (check box)
9. Person or Group
10. Hyperlink or Picture
11. Calculated (calculation based on other columns)
12. Full HTML content with formatting and constraints for publishing
13. Image with formatting and constraints for publishing
14. Hyperlink with formatting and constraints for publishing
15. Summary Links data
16. Rich media data for publishing
17. Managed Metadata
5. What is Content Type?
A content type is a reusable collection of metadata (columns), workflow, behavior, and other settings for a category of items or documents. Content types enable user to manage the settings for a category of information in a centralized and reusable manner. A content type defines the attributes of a list item, a document, or a folder. Each content type can specify properties to associate with items of its type.
6. What is Document Set?
Document Set enables users to group multiple documents that support a single project or task, together into a single entity. All documents in a Document Set share the metadata and the entire set can be versioned. Document sets are built on SharePoint 2010 content types, and user can create multiple unique document set content types as part of their implementation.
7. What is Drop-Off Library?
The Drop Off Library will be the default destination when a user tries to upload a document to this site. This is used when user does not know that where should the document be uploaded in the site. In that case, user uploads the document in this library and the document is routed automatically to the specific library.
8. What is Routing Rules List?
The Routing Rules list, as its name implies, contains the rules for how a document is to be routed to its final destination. These rules are written to route the documents to their final and proper destination.
9. What is enterprise Metadata Management?
Enterprise metadata management (EMM) is a set of features introduced in Microsoft SharePoint Server 2010 that enable taxonomists, librarians, and administrators to create and manage terms and sets of terms across the enterprise. There are two key principles in the use of metadata:
1. Use of tags: It is easy for a site to use enterprise wide tags and taxonomies, and easy for users to apply them.
2. Application of tags in SharePoint 2010: The document libraries are configured to use metadata as a primary navigation pivot and improves search.
10. What is Web part?
Web Parts are customizable plug and play components that empower information workers to create personalized user interfaces by simply dragging and dropping them on a Web page. Web parts allow customization at both design time and run time.
There are two types of web parts.
1. In-built web parts – Web parts that are included in SharePoint. Developers can drag them from web part galleries and drop them into web part zones.
2. Custom web parts – Web parts that are created by the user using visual studio is called custom web parts.
A Web Part is composed of the following entities:
1. The Web Part description file (.dwp) is a portable container of default and personalized property values for the Web Part.
2. The Web Part assembly file (.dll) contains the logic and code for the Web Part, and is installed on the server running Windows SharePoint Services.
3. Resource files that support the Web Part; these are also stored on the server.
4. Tables in the Windows SharePoint Services database are used to store current values of the Web Part properties.
11. What are the various types of master pages?
There are three types of master pages in SharePoint 2010:
1- V4.master Default team site master page. Provides ribbon bar and other editing features using UI.
2- Default.master Sites upgraded from SharePoint 2007 use this unless they are changed to use a v4 version.
3- Minimal.master These trimmed-down custom master pages are commonly referred to as Starter Master Pages in SharePoint 2010.
12. What are Content pages?
Content pages implement a master page. Content pages contain an attribute, which informs the compiler that the page should be, merged with a master page. This attribute is part of the page directive tag called the MasterPageFile.
13. What is Page Layout?
Page layout dictates the overall look and feel of a web page. A page layout relies on a content type to determine the kind of content that can be stored on pages. Page layout contains field controls and web part.
14. What is Site definition?
Site definitions are the foundations on which all sites and user templates are built. These are the collection of XML or ASPX files. Site definition contains information of web parts, lists, libraries, features, and navigation bars to be included in the site
15. What is Site template?
A site template provides the basic component and layout of a new site created under SharePoint. A site template contains specific design information about a site, including the list that is part of the site, web part pages used in the site, the site’s themes and borders, changes to the quick launch bar, as well as some site content (such as document libraries). Site templates are used to allow the rapid creation of websites and basic content in a SharePoint system.
16. What is ONET.xml?
ONET.xml file is present in TEMPLATE\SiteTemplates\XML\Onet.xml location, which defines the setup of the site definition, such as which Features to load, where the web parts go and what they will perform and which document library templates to assign and many more.
17. What is Single sign-on?
Single Sign-on allows users to log on to a variety of applications with the single username and password and user has to enter the details only once for all the applications.
Source: Vishal Gupta SharePoint Interview Questions