Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and Answers Freshers, Sharepoint Interview Questions and Answers, Sharepoint Interview Questions

Before getting on to the Sharepoint interview questions, the student must know that the Sharepoint is a continuously varying field which needs the students as well as professionals to upgrade their skills with the new features and knowledge, to get fit for the jobs associated with Sharepoint. This post related to Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and Answers Freshers, Sharepoint Interview Questions and Answers, Sharepoint Interview Questions will help you let out find all the solutions that are frequently asked in you upcoming Sharepoint interview.

Over thousands of vacancies available for the Sharepoint developers, experts must be acquaintance with all the component of Sharepoint technologies. This is necessary for the students in order to have in-depth knowledge of the subject so that they can have best employment opportunities in the future. Knowing every little detail about Sharepoint is the best approach to solve the problems linked with problem.

APTRON has spent hours and hours in researching about the Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and Answers Freshers, Sharepoint Interview Questions and Answers, Sharepoint Interview Questions that you might encounter in your upcoming interview.  All these questions will alone help you to crack the interview and make you the best among all your competitors.

First of all, let us tell you about how the Sharepoint technology is evolving in today’s world and how demanding it is in the upcoming years. In fact, according to one study, most of the companies and businesses have moved to the Sharepoint. Now, you cannot predict how huge the future is going to be for the people experienced in the related technologies.

Hence, if you are looking for boosting up your profile and securing your future, Sharepoint will help you in reaching the zenith of your career. Apart from this, you would also have a lot of opportunities as a fresher.

These questions alone are omnipotent. Read and re-read the questions and their solutions to get accustomed to what you will be asked in the interview. These Sharepoint interview questions and answers will also help you on your way to mastering the skills and will take you to the giant world where worldwide and local businesses, huge or medium, are picking up the best and quality Sharepoint professionals.

This ultimate list of best Sharepoint interview questions will ride you through the quick knowledge of the subject and topics like SharePoint 2013, Planning the SharePoint Deployment and Installing the Server Farm. This Sharepoint interview questions and answers can be your next gateway to your next job as a Sharepoint expert.

These are very Basic Sharepoint Interview Questions and Answers for freshers and experienced both.

Q1: What is Microsoft SharePoint Portal Server?
A1: MS SharePoint Portal Server is an integrated suite from server side, to help improve organizational effectiveness with the help of providing

  • comprehensive content management.
  • enterprise search.
  • accelerating shared business processes.
  • facilitating information sharing across boundaries.
  • Provides platform which includes server administration, application extensibility and interoperability for IT professionals.

Q2: What are zones?
A2: Different logical paths (URLs meaning) of gaining access to the same SharePoint Web application.

Five Zones :

  1. Internet Zone.
  2. Intranet
  3. Default
  4. Extranet
  5. Custom

Q3: What is Windows SharePoint Services?
A3: Creation of websites for information sharing and document collaboration will be enabled by Windows SharePoint Services. It provides additional functionality for MS Office system and other desktop applications. It also supports like a platform for the development of applications.

Q4: How is SharePoint Portal Server different from the Site Server?
A4: SharePoint Portal Server :

  • Web site creation for information sharing and document collaboration is treated as services by SharePoint Portal Server.
  • SharePoint server services are key information worker infrastructure that provides additional functionality to the MS Office system applications. Site Server:
  • Manages websites with multiple technologies
  • Content management, product management, order processing , advertisement serving are some of the functionality.

Q5: What is LINQ. How is it used in Sharepoint?
A5: LINQ is a feature of the programming languages C# 3.0 and Visual Basic .NET. LINQ allows the user to query in an object-oriented way, supports compile-time check, gives the user intellisense support in Visual Studio and defines a unified, SQL like syntax to query any data source. But unlike other languages and query syntaxes which vary from one type of data source to another, LINQ can be used to query, in principle, any data source whatsoever. Hence, developers may find that it is the only query syntax that they ever need to know. It is commonly used to query objects collections, XML and SQL server data sources.

LINQ to SharePoint is officially being supported with the 2010 release.It works similar to LINQ to SQL or LINQ to Entity.

The LINQ to SharePoint Provider is defined in the Microsoft.SharePoint.Linq namespace. It translates LINQ queries into Collaborative Application Markup Language (CAML) queries.The gateway class for the LINQ to SharePoint provider is Microsoft SharePoint.Linq.DataContext which represents the data of a SharePoint Foundation Web site

Q6: What are the Hardware and Software requirements for SharePoint 2010.
A6: Hardware requirements : Processor 64-bit, four-core, 2.5 GHz minimum per core.
RAM 4 GB for developer or evaluation use, 8 GB for single server and multiple server farm installation for production use.
Hard disk 80 GB for installation

For production use, the users need additional free disk space for day-to-day operations. Add twice as much free space as the users have RAM for production environments.

Software requirements : The 64-bit edition of Windows Server 2008 Standard with SP2. If the users are running Windows Server 2008 without SP2, the Microsoft SharePoint Products and Technologies 2010 Preparation Tool installs Windows Server 2008 SP2 automatically.

Q7: What are the advantages of Service Applications over SSP?
A7: The key limitation of the SSP architecture was that it was configured by using a set of services, and all Web applications associated with the SSP bore the overhead of all the services even if they weren’t being used. To change the service configuration for a particular Web application, a new SSP would have to be created.

The service application architecture on the other hand, allows a set of services to be associated with a given Web application and a different set of services to be associated with another Web application. Also, the same service application can be configured differently in different Web applications; therefore, Web sites can be configured to use only the services that are needed, rather than the entire bank of services.

Q8: What is new SharePoint 2013?
A8: SharePoint 2013 is the next Version of Microsoft’s famous Collaboration and Document Management Software called SharePoint.This Version follows SharePoint 2010 that was released back in May 2010.SharePoint 2013 was released (as Preview and RTM versions) with some new & exciting features such as Real Time Social Feed,Shredded Storage,SharePoint Apps,Cross-site publishing,Out-of-Box PDF support,Minimal Download Strategy and lot more.

Q9: Why should a Company Migrate to SharePoint 2013?
A9: Microsoft has added some Incredible features to SharePoint 2013 that can be of huge benefit to all the Companies that use SharePoint on a large scale. Most of the new Features are Introduced for Improving SharePoint Performance (for both Browser and SQL) and to enhance the famous Web Content Management Capabilities.There is an Improvement for all – end users, developers and IT administrators.

Q10: What are the types of input forms that can be created for a workflow ?
A10: You can create four different types of input forms including

    1. An association form
    2. An initiation form
    3. A modification form
    4. A task edit form.Note that these forms are optional when you create a workflow template.

Q11: What are ways to create input forms for workflow ?
A11: Two

        1. You can create your forms by using custom application pages, which are standard .aspx pages deployed to run out of the _layouts directory. (disadv: lot of code required when compared to Infopath approach)
        2. Using Microsoft Office InfoPath 2007 (disadv: picks up a dependenct on MOSS, i.e. it cannot run in a standalone WSS environment)

Q12: What is the difference between method activity and event activity in WorkFlow ?
A12: A method activity is one that performs an action, such as creating or updating a task. An event activity is one that runs in response to an action occurring.

Q13: What are content types?
A13: A content type is a flexible and reusable WSS type definition (or we can a template) that defines the columns and behavior for an item in a list or a document in a document library. For example, you can create a content type for a leave approval document with a unique set of columns, an event handler, and its own document template and attach it with document library/libraries.

Q14: Can a content type have receivers associated with it?
Q14: Yes, a content type can have an event receiver associated with it, either inheriting from the SPListEventReciever base class for list level events, or inheriting from the SPItemEventReciever base class. Whenever the content type is instantiated, it will be subject to the event receivers that are associated with it.

Q15: What two files are typically (this is kept generally) included when developing a content type, and what is the purpose of each?
A15: There is generally the main content type file that holds things like the content type ID, name, group, description, and version. There is also the ContentType.Fields file which contains the fields to include in the content type that has the ID, Type, Name, DisplayName, StaticName, Hidden, Required, and Sealed elements. They are related by the FieldRefs element in the main content type file.

Q16: Are there any other type of relevant service architectures?
A16: Depending on the environment requirements, a specialized farm can also be used in order to deploy specific services tailored to the organizational requirements which can aid in scaling out and conservation of resources.

Q17: What is the User Profile service?
A17: Allows configuring and managing User profile properties, Audiences, Profile synchronization settings, organization browsing and management settings, and My Site settings.

Q18: What are User Profiles?
A18: Aggregates properties from diverse identity content sources together to create unified and consistent profiles across an organization, used throughout the SharePoint environment.

Q19: What is Excel Services?
A19: Allows sharing, securing, managing, and using Excel 2010 workbooks in a SharePoint Server Web site or document library. Excel Services consists of the Excel Calculation Services (ECS), Microsoft Excel Web Access (EWA), and Excel Web Services (EWS) components.

Q20: What is PerformancePoint Services?
A20: Allows users to monitor and analyze a business by building dashboards, scorecards, and key performance indicators (KPIs).

Q21: What is Visio Services?
A21: Allows users to share and view Microsoft Visio Web drawings. The service also enables data-connected Microsoft Visio 2010 Web drawings to be refreshed and updated from various data sources.

Q22: What is Access Services?
A22: Allows users to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an internet browser, the Access client, or a linked HTML page.

Q23: What is the Secure Store Service (SSS)?
A23: A secure database for storing credentials that are associated with application IDs

Q24: What is Content Deployment?
A24: Content deployment enables you to copy content from a source site collection to a destination site collection.

Q25: What are Site Columns ?
A25: 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 "Category" with a choice datatype along with the pre-defined values "It","Hr". This column then can be added to any content type in your list or library.

Q26: What is meant by a Site definition ?
A26: A Site definition is a collection of Files. The files are such as ONET.XML which defines the Site template.

For e.g. Team Sites used to create a Site in SharePoit. All the out-of-box site Templates like Blog,Wiki,Team Site etc can be found in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\

Q27: What is the command to take backup and restore for sharepoint site ?
A27: The commands to take backup and restore for sharepoint site are given as follows:

Backup command:

stsadm -o backup -url http://moss:4002/ -filename c:\bkupsite.bak

To restore :

stsadm -o restore -url http://moss:4004/ -filename c:\bkupsite.bak

Q28: Mention the ways to initiate the workflow in Sharepoint ?
A28: Below are the ways to initiate the workflow in Sharepoint:

1) Automatic (on item added or item deleted)

2) Manual (standard WSS UI interface)

3) Manual (Custom UI Interface)

4) Programatically through custom code

Q29: What is the difference between BDC and BCS?
A29: BCS is new in SharePoint2010 and stands for Business connectivity Services. Using BCS one can read and write into the external Database. In BDC, one can only perform the reading from external Database

Q30: What tools can be used to back up a SharePoint 2010 environment?
A30: – SharePoint farm backup and recovery
– SQL Server

Q31: Explain 1) BDC 2) BCS
A31: 1) BDC – Also called Business Data Catalogue is used to connect to an external database and read it in SharePoint.

2) BCS – Also called Business connectivity Services is new in SharePoint2010. BCS aids in reading and writing into the external Database.

Q32: Explain Content types in Sharepoint.
A32: – A content type is a WSS type definition which is flexible and reusable.
– It is used to define the columns and behavior for an item in a list or a document in a document library.

Q33: Differentiate between Library vs List.
A33: – Library is used to store the document whereas Lists are the container of similar items in the form of rows and columns.

– Core documents like Word, Excel, and PowerPoint can be created using a Library while you can not create a document in a List. List can be used to attach a document.

Q34: What do you mean by Field Control?
A34: – Field controls are ASP.NET 2.0 server controls. They provide basic field functionality in SharePoint.

– They also provide basic general functionality such as displaying or editing list data as it appears on SharePoint list pages.

Q35: What are the various types of input forms that can be created for a workflow?
A35: Four types of input forms can be created for a workflow:

1. Association form
2. Initiation form
3. Modification form
4. Task edit form

Q36: Explain an ancestral type. How is it related to content types?
A36: – An ancestral type is the base type that the content typed is derived from.
– It defines the metadata fields included with the custom content type.

Sharepoint Conclusion Interview FAQs

We know the list of Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and Answers Freshers, Sharepoint Interview Questions and Answers, Sharepoint Interview Questions is overwhelming but the advantages of reading all the questions will maximize your potential and help you crack the interview. The surprising fact is that this Sharepoint interview questions and answers post covers all the basic of the Sharepoint technology and you have to check out the FAQs of different components of Sharepoint too.

However, you will be asked with the questions in the interview related to the above mentioned questions. Preparing and understanding all the concept of Sharepoint technology will help you strengthen the other little information around the topic.

After preparing these interview questions, we recommend you to go for a mock interview before facing the real one. You can take the help of your friend or a Sharepoint expert to find the loop holes in your skills and knowledge. Moreover, this will also allow you in practicing and improving the communication skill which plays a vital role in getting placed and grabbing high salaries.

Remember, in the interview, the company or the business or you can say the examiner often checks your basic knowledge of the subject. If your basics is covered and strengthened, you can have the job of your dream. The industry experts understand that if the foundation of the student is already made up, it is easy for the company to educate the employ towards advance skills. If there are no basics, there is no meaning of having learnt the subject.

Therefore, it’s never too late to edge all the basics of any technology. If you think that you’ve not acquired the enough skills, you can join our upcoming batch of Sharepoint Training in Noida. We are one of the best institute for Sharepoint in noida which provide advance learning in the field of Sharepoint Course. We’ve highly qualified professionals working with us and promise top quality education to the students.

We hope that you enjoyed reading Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and Answers Freshers, Sharepoint Interview Questions and Answers, Sharepoint Interview Questions and all the FAQs associated with the interview. Do not forget to revise all the Sharepoint interview questions and answers before going for the Sharepoint interview. In addition to this, if you’ve any doubt or query associated with Sharepoint, you can contact us anytime. We will be happy to help you out at our earliest convenience. At last, we wish you all the best for your upcoming interview on Sharepoint Technology.