SharePoint 2010 Basic Interview Questions-Part 5

81) What is a SharePoint list?

       Everything is stored in SharePoint in form of List. They are similar to 

      database. List have item, fields and Views. Items are like a row in a   

      table. Fields are like columns in a database table. Views displays 

      information from List.

      How to create a SharePoint List in browser in SharePoint 2010?

     To create a SharePoint 2010 list go to Site Actions ---> then click on More 

     ---> Then you can select the type of list you want to create including 

     custom list also.

82) What is the dot net framework version supported by SharePoint 

       2010?

       SharePoint 2010 supports .net framework 3.5 and 3.5SP1.

83) SharePoint 2010 supports which versions of IIS?

       SharePoint 2010 supports IIS 7.x means IIS 7.0, IIS 7.5 etc

84) Which versions of SQL Server supported by SharePoint 2010?

       SharePoint 2010 supports SQL Server 2005 SP3 or SQL Server 2008/R2, but 

      both should be 64 bit version.

85) What is the use of SharePoint_Config database?

       SharePoint 2010 uses SharePoint_Config database to store farm 

      configurations and contents. This database gets automatically created 

      whenever you deploy the farm for the first time.

86) What is a Content database?

       SharePoint 2010 uses content database to stores content for one or more 

      Site Collections. Content can be items, documents, documents versions, 

      pages, images etc.

      You can deploy multiple Content Databases for a single web application.

87) What are different SharePoint editions?

       There are different editions like: Microsoft SharePoint Foundation 2010, 

      Microsoft SharePoint Server 2010 Standard edition, Microsoft SharePoint 

      Server 2010 Enterprise edition, Microsoft SharePoint Server 2010 for  

      Internet Sites 

      Standard editions, Microsoft SharePoint Server 2010 for Internet Sites 

      Enterprise editions.

88) What is the work of SPVirtualPathProvider?

       SPVirtualPathProviders is responsible for determining whether the 

      requested content should be retrieved from the content database or from

      the file system.

89) What are the SharePoint objects we can work in Visual Studio 2010?

       Visual Web Part, Sequential Workflow, State Machine Workflow, Event 

      Receiver, List Definition, Content Type, Site Definition, Application Page, 

      User Control etc.

90) What are the things we can do using SharePoint designer 2010?

       We can Personalize pages, page layouts, Web Parts, Web Part Pages, 

      layouts and themes, master pages, Create and manage lists and 

      document libraries, Manage users and groups, Design simple workflows 

      etc.

91) What are the main capabilities of SharePoint 2010?

       The main capabilities of SharePoint 2010 includes Sites, Communities, 

      Content, Search, Insights and Composites.

92) What is the work of SharePoint 2010 central administration?

      SharePoint 2010 central administration work: Application Management, 

      Monitoring, Security, General Application Settings, System Settings, 

      Backup and Restore, Upgrade and Migration, Configuration Wizards etc.

93) What is a SharePoint Farm?

       A SharePoint farm is a set of one or more server computers working 

      together to provide SharePoint Foundation functionality to clients.

94) What is a service applications in SharePoint 2010?

       Service applications are used to facilitate sharing resources across sites 

      running in different Web applications and different farms. Basically 

      SharePoint 2010 replacing SSP of MOSS 2007 in the form of Service 

      applications.

95) What is a Site in SharePoint?

       This is very difficult to define:

      A site is also a storage container that allows users to store and manage

      content such as list items and documents.

96) What are the default lists available in a Team site?

       A team site has 4 default list and that are: Announcements, Calendar, 

      Links, and Tasks lists.

97) What is a recycle bin in SharePoint?

       Whenever you will delete something it goes to recycle bin in SharePoint.

      You can restore items that have been deleted from the site  from the 

      recycle bin.

98) What to navigate to Site Settings page in SharePoint 2010?

       From the home page, click on Site Actions -> Site Settings.

99) How to go to master page gallery in SharePoint 2010?

       To go to master page gallery in SharePoint 2010 go to Site Actions ---> 

      Site Settings. It will open the site settings page, then in the settings 

      page Go to Galleries section and click on Master pages.

100)How to change theme in SharePoint 2010?

        Changing the default theme is very easy in SharePoint 2010. Go to Site 

       Actions ---> Site Sections --->Then go to Galleries and click on Theme 

       link. It will open the Change Theme home page and from there you can 

       select any theme you want.

101)What is a feature in SharePoint?

        SharePoint feature groups custom functionality that developers and 

      administrators can activate.

102)What are the feature activation scope in SharePoint?

        A feature can activated in Farm level, Web Application level, Site 

      Collection level & Site level.

SharePoint 2010 Basic Interview Questions-Part 4

61) What is a workspace?

      A site or workspace is when you want a new place for collaborating on 

      Web pages, lists and document libraries. For example, you might create a 

      site to manage a new team or project, collaborate on a document or 

      prepare for a meeting.

62) 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.

63) Can more than one person use the same login?

       If the users sharing that login will have the same permissions and there 

      is no fear of them sharing a password, then yes. Otherwise, this is 

      discouraged.

64) How customizable is the user-to-user access?

       User permissions apply to an entire Web, not to documents themselves. 

      However, you can have additional sub webs that can optionally have their

      own permissions. Each user can be given any of four default roles. 

      Additional roles can be defined by the administrator.

65) Can each user have access to their own calendar?

       Yes there are two ways to do this,

* by creating a calendar for each user, or
* by creating a calendar with a view for each user

66) How many files can I upload?

       There is no restriction in place except that any storage consumed beyond 

      that provided by the base offering may have an additional monthly charge 

      associated with them.

67) What types of files can I upload / post to the site?

        The only files restricted are those ending with the following extensions: 

       .asa, .asp, .ida, .idc, .idq. Microsoft reserves the right to add additional 

       file types to this listing at any time. Also, no content that violates the

       terms of service may be uploaded or posted to the site.

68)  Can SharePoint be linked to an external data source?

        SharePoint data can be opened with Access and Excel as an external data 

       source. Thus, SharePoint can be referenced as an external data source. 

       SharePoint itself cannot reference an external data source.

69) Can SharePoint be linked to a SQL database?

       This is possible via a custom application, but it not natively supported by 

      SharePoint or SQL Server.

70) Can I customize my Windows SharePoint Services site?

       YES! Windows SharePoint Services makes updating sites and their content 

      from the browser easier then ever.

      SharePoint includes tools that let you create custom lists, calendars, page 

      views, etc. You can apply a theme; add List, Survey and Document Library 

      WebParts to a page; create personal views; change logos; connect 

      WebParts and more.

      To fully customize your site, you can use Microsoft FrontPage 2003. 

      Specifically, you can use FrontPage themes and shared borders, and also 

      use FrontPage to create photo galleries and top ten lists, utilize standard 

      usage reports, and integrate automatic Web content.

71) Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of 

       Microsoft Windows?

       Windows SharePoint Services 3.0, Office SharePoint Server 2007, Office 

      Forms Server 2007, and Office SharePoint Server 2007 for Search will 

      support 64-bit versions of Windows Server 2003.

72) What are the advanced features of MOSS 2007?

       * User Interface (UI) and navigation enhancements

      * Document management enhancements

      * The new Workflow engine

      * Office 2007 Integration

      * New Web Parts

      * New Site-type templates

      * Enhancements to List technology

      * Web Content Management

      * Business Data Catalog

      * Search enhancements

      * Report Center

      * Records Management

      * Business Intelligence and Excel Server

      * Forms Server and InfoPath

      * The “Features” feature

      * Alternate authentication providers and Forms-based authentication

73) What are the actual advantages of SharePoint Portal Services (SPS) 

       over SharePoint Team Services (STS)?

       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. SharePoint team Services (SPS) has a better search engine, and can

      crawl multiple content sources. STS cannot. STS is easier to manage and 

      much better for a team environment where there is not much Document 

      Management going on. SPS is better for an organization, or where 

      Document Management is crucial.

74) How Does SharePoint work?

      The browser sends a DAV packet to IIS asking to perform a document   

      check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it 

      has the proprietary INVOKE command. Because of the existence of this 

      command, the packet is passed off to msdmserv.exe, who in turn 

      processes the packet and uses EXOLEDB to access the WSS, perform the 

      operation and send the results back to the user in the form of XML.

75) What newsgroups are available?

       There are two,

* microsoft.public.sharepoint.portalserver and
* microsoft.public.sharepoint.portalserver.development.

76) What is SharePoint?

      Microsoft often defines SharePoint as a business collaboration platform.

      In other way its is also a rich  framework for developing business 

      collaboration solutions. SharePoint is a platform for building websites,

      both intranet and internet web sites.

      It is a collaboration platform for users, customers or whoever using the

      SharePoint web site.

77) What is the menimun software and hardware requirements to install 

       SharePoint 2010? 

      Operating System: Microsoft Windows Server 2008 or Microsoft Windows 

      Server 2008 R2, but for  development purpose you can install SharePoint 

      2010 on Windows 7 and Microsoft Windows Vista SP1/SP2. All operating 

      system should be 64 bit. 

      Database: SharePoint 2010 requires database of Microsoft SQL Server 

      2005 SP3 or Microsoft SQL Server 2008 or R2. Also all should be 64bit.

      Application Server: SharePoint 2010 requires IIS7 +.

       .Net Framework: SharePoint 2010 requires Microsoft .NET Framework 3.5

      and SP1 is preferable. 

77) What are SharePoint 2010 main features?

        Sites: Ribbon UI, SharePoint Workspace, SharePoint Mobile etc.

  

        Communities: Tagging, Tag Cloud, Rating, Social Networking feature, 

       My Sites, Blogs and Wikis, My Profile etc.

       Content: Enterprise content type, Metadata and navigation, Document 

       sets, Remote BLOG Storage, Audio and Video Content types, List 

       Enhancements etc.

       Search:FAST Search integration, Social Relevance.

       Insights: Excel services, Visio services, web analytics, SQL server 

       integration etc.

        Composites: Business Connectivity Services, Info path form services, 

       External lists, Workflows, SharePoint designers, Visual studio, REST etc.

78) What is SharePoint Central Administration?

      This is designed to administer and monitor a SharePoint server farm. Here 

      you can configure servers and servers’ roles, define farm topology, and 

      create new web applications and Site Collections. This basically a 

      SharePoint site. The main features included here are: Application 

      Management, Monitoring, Security, General Application Settings, System 

      Settings, Back Up and Restore, Upgrade and Migration and Configuration 

      wizard.

                                                                                                                                                                                                

79) What is a Site collection and Web application?

      A Site Collection is a logical container that holds a set of websites, 

      hosted in a web application. If you want to publish internet or intranet 

      web site then you need at least a web application and one site collection.

      To create a new Site Collection we need a parent web application.

80) What are the site templates available in SharePoint?

      There are 5 different site templates available in SharePoint 2010, from 

      which you can create sites. And They are:

       Collaboration: It has templates for Team Site, Blank Site, Document 

      Workspace, Blog, Group Work Site etc.

      Meetings: It has templates for Basic Meeting Workspace, Blank Meeting 

      Workspace, Decision Meeting Workspace, Social Meeting Workspace, and 

      Multipage Meeting Workspace.

      Enterprise: It has templates for Document Center, Records Center,  

      PowerPoint Broadcast Site, Business Intelligence Center, Enterprise 

      Search Center, My Site Host, Basic Search Center, and FAST Search 

      Center.

      Publishing: It has templates for Publishing Portal and Enterprise Wiki 

      Custom: Here you can define your own custom templates.

SharePoint 2010 Basic Interview Questions-Part 3

41) What is Microsoft SharePoint Portal Server?

       SharePoint Portal Server is a portal server that connects people, teams, 

      and knowledge across business processes. SharePoint Portal Server 

      integrates information from various systems into one secure solution 

      through single sign-on and enterprise application integration capabilities.

      It provides flexible deployment and management tools, and facilitates 

      end-to-end collaboration through data aggregation, organization, and 

      searching. SharePoint Portal Server also enables users to quickly find 

      relevant information through customization and personalization of portal 

      content and layout as well as through audience targeting.

42) What is Microsoft Windows Services?

       Microsoft Windows Services is the engine that allows administrators to 

      create Web sites for information sharing and document collaboration. 

      Windows SharePoint Services provides additional functionality to the 

      Microsoft Office System and other desktop applications, as well as serving 

      as a plat form for application development. SharePoint sites provide 

      communities for team collaboration, enabling users to work together on 

      documents, tasks, and projects. The environment for easy and flexible 

      deployment, administration, and application development.

43) What is the relationship between Microsoft SharePoint Portal Server 

       and Microsoft Windows Services?

       Microsoft SharePoint Products and Technologies (including SharePoint 

      Portal Server and Windows SharePoint Services) deliver highly scalable 

      collaboration solutions with flexible deployment and management tools. 

      Windows SharePoint Services provides sites for team collaboration, while 

      SharePoint Portal Server connects these sites, people, and business 

      processes—facilitating knowledge sharing and smart organizations. 

      SharePoint Portal Server also extends the capabilities of Windows 

      SharePoint Services by providing organizational and management tools for

      SharePoint sites, and by enabling teams to publish information to the 

      entire organization.

44) How do I invite users to join a Windows SharePoint Services Site? Is 

       the site secure?

       SharePoint-based Web sites can be password-protected to restrict access 

      to registered users, who are invited to join via e-mail. In addition, the 

      site administrator can restrict certain members' roles by assigning 

      different permission levels to view post and edit.

45) Can I post any kind of document?

       You can post documents in many formats, including .pdf, .htm and .doc. 

      In addition, if you are using Microsoft Office XP, you can save documents 

      directly to your Windows SharePoint Services site.

46) Can I download information directly from a SharePoint site to a 

       personal digital assistant (PDA)?

       No you cannot. However, you can exchange contact information lists with 

      Microsoft Outlook.

47) How long does it take to set up the initial team Web site?

       It only takes a few minutes to create a complete Web site. Preformatted

      forms let you and your team members contribute to the site by filling out 

      lists. Standard forms include announcements, events, contacts, tasks, 

      surveys, discussions and links.

48) Can I create custom templates?

       Yes you can. You can have templates for business plans, doctor's office, 

      lawyer's office etc.

49) How can I make my site public? By default, all sites are created 

       private.

       If you want your site to be a public Web site, enable anonymous access 

      for the entire site. Then you can give out your URL to anybody in your 

      business card, e-mail or any other marketing material. The URL for your 

      Web site will be:

      http:// yoursitename.wss.bcentral.com

      Hence, please take special care to name your site.

      These Web sites are ideal for information and knowledge intensive sites

      and/or sites where you need to have shared Web workspace.

      Remember: Under each parent Web site, you can create up to 10 sub-

      sites each with unique permissions, settings and security rights.

50) How do the sub sites work?

       You can create a sub site for various categories. For example:

  1. Departments - finance, marketing, IT
  2. Products - electrical, mechanical, hydraulics
  3. Projects - Trey Research, Department of Transportation, FDA
  4. Team - Retention team, BPR team
  5. Clients - new clients, old clients
  6. Suppliers - Supplier 1, Supplier 2, Supplier 3
  7. Customers - Customer A, Customer B, Customer C
  8. Real estate - property A, property B

  The URLs for each will be, for example:
  http://yoursitename.wss.bcentral.com/finance
  http://yoursitename.wss.bcentral.com/marketing

  You can keep track of permissions for each team separately so that 

  access is restricted while maintaining global access to the parent site.

51) How do I make my site non-restricted?

       If you want your site to have anonymous access enabled (i.e., you want 

      to treat it like any site on the Internet that does not ask you to provide a 

      user name and password to see the content of the site), follow these 

      simple steps:

# Login as an administrator
# Click on site settings
# Click on Go to Site Administration
# Click on Manage anonymous access
# Choose one of the three conditions on what Anonymous users can  

   access:
** Entire Web site
** Lists and libraries
** Nothing

Default condition is nothing; your site has restricted access. The default conditions allow you to create a secure site for your Web site.

52) Can I get domain name for my Web site?

       Unfortunately, no. At this point, we don't offer domain names for 

      SharePoint sites. But very soon we will be making this available for all our 

      SharePoint site customers. Please keep checking this page for further 

      update on this. Meanwhile, we suggest you go ahead and set up your site 

      and create content for it.

53) What are picture libraries?

       Picture libraries allow you to access a photo album and view it as a slide 

      show or thumbnails or a film strip. You can have separate folder for each 

      event, category, etc

54) What are the advantages of a hosted SharePoint vs. one that is on an 

        in-house server?

       * No hardware investment, i.e. lower costs

      * No software to download - ready to start from the word go

      * No IT resources - Anyone who has used a Web program like Hotmail can 

         use it

      * Faster deployment

55) Can I ask users outside of my organization to participate in my 

       Windows SharePoint Services site?

       Yes. You can manage this process using the Administration Site Settings. 

      Simply add users via their e-mail alias and assign permissions such as 

      Reader or Contributor.

56) Are there any IT requirements or downloads required to set up my 

       SharePoint site?

       No. You do not need to download any code or plan for any IT support. 

      Simply complete the on-line signup process and provide us your current 

      and correct email address. Once you have successfully signed up and your 

      site has been provisioned, we will send a confirmation to the email 

      address you provided.

57) Are there any browser recommendations?

       Yes. Microsoft recommends using the following browsers for viewing and 

      editing Windows SharePoint Services sites: Microsoft Internet Explorer

      5.01 with Service Pack 2, Microsoft Internet Explorer 5.5 with Service Pack 

      2, Internet Explorer 6, Netscape Navigator 6.2 or later.

58) What security levels are assigned to users?

       Security levels are assigned by the administrator who is adding the user. 

      There are four levels by default and additional levels can be composed as

      necessary.

      * 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.

59) How secure are Windows SharePoint Services sites hosted by 

       Microsoft?

       Microsoft Windows SharePoint Services Technical security measures 

      provide firewall protection, intrusion detection, and web-publishing rules. 

      The Microsoft operation center team tests and deploys software updates 

      in order to maintain the highest level of security and software reliability. 

      Software hot-fixes and service packs are tested and deployed based on 

      their priority and level of risk. Security related hot-fixes are rapidly 

      deployed into the environment to address current threats. A 

      comprehensive software validation activity ensures software stability 

      through regression testing prior to deployment.

60)  What is the difference between an Internet and an intranet site?

        An internet site is a normal site that anyone on the internet can access 

      (e.g., www.msn.com, www.microsoft.com, etc.). You can set up a site for

      your company that can be accessed by anyone without any user name and

      password.

      An intranet (or internal network), though hosted on the Web, can only be 

      accessed by people who are members of the network. They need to have 

      a login and password that was assigned to them when they were added

      to the site by the site administrator.