Olete.in – MCQs, Mock Tests & Government Job Prep | Sharepoint Sharepoint Mcq Question Set 1

What are the Correct statements about Configuration Database in SharePoint 2007.

1. Every Web Application has its own Configuration DB.
2. A Farm can have only a single config DB.
3. All the servers in a same farm are registered in the same Config DB.
4. A Config DB is created after running the Configuration WizarD.

✅ Correct Answer: 2

Select the correct SQL Server Database versions which can be used for SharePoint Installation.

1. SQL Server 2008
2. SQL Server 2005
3. SQL Server 2000 with SP1
4. SQL Server 2000 with SP3a

✅ Correct Answer: 2

Select the correct software configuration combination which can be used to install SharePoint 2007.

1. NET 2.0 with Windows XP
2. NET 2.0 , Windows Server 2003 Enterprise (SP1), IIS 6.0
3. NET 2.0 , Windows Server 2003 , IIS 5.0
4. NET 2.0 , Windows Server 2003 Standard (SP1), IIS 6.0

✅ Correct Answer: 4

Select the correct activities happening while doing the SharePoint Installation (Multiple Select).

1. IIS modification happens during running the Configuration WizarD.
2. IIS modification happens during installing the SharePoint Server.
3. A Web Application is created to host Central Administration while running the Configuration WizarD.
4. A Config DB is created for the SharePoint Farm while running the Configuration WizarD.

✅ Correct Answer: 1

Choose the correct options regarding SharePoint Installation.

1. Selecting Basic & Stand Alone mode allows to install SharePoint Server with SQL Server Express Edition.
2. Web Front End also install the Shared Services on the machine.
3. We can not choose Web Front End mode while installing SharePoint for a Server until we have a Complete installation on one server in the farm.
4. Complete Installation allows to add/remove servers from the farm.

✅ Correct Answer: 3

Adding a server to provide only Excel Services to an existing SharePoint Farm,what kind of installation we need to perform on the Server.

1. Basic
2. StandAlone
3. Web Front End
4. Complete

✅ Correct Answer: 4

To add a server to an existing SharePoint Farm which serves only as web front End machine, what kind of installation we can perform.

1. Basic
2. StandAlone
3. Web Front End
4. Complete

✅ Correct Answer: 3

Following Databases are created after the successful completion of the configuring wizard in SharePoint

1. Cofig DB for the SharePoint Farm
2. SSP Content DB
3. Content DB for the Central Admin
4. Config DB for the Central Admin

✅ Correct Answer: 1

Select correct statements regarding the changes in IIS during the installation and configuration of SharePoint 2007.

1. No changes were made to IIS during the installation of SharePoint Server 2007
2. 2 Application pools are created in IIS after the Configuration Wizard
3. The Central Administration Web site was created using the SharePoint Central Administration 3.0 application pool.
4. The Central Administration Web site was created using the OfficeServerApplicationPool application pool.

✅ Correct Answer: 2

Name the two application pool accounts which are created after successful completion of configuration Wizard of SharePoint 2007.

1. SharePoint Central Administration 3.0
2. SharePointServerApplicationPool
3. OfficeServerApplicationPool
4. SharePoint Administration 3.0

✅ Correct Answer: 1

Choose the correct statements about Variations used in SharePoint 2007 .

1. For Variation to work Office SharePoint Server Publishing Infrastructure should be activateD.
2. Variation changes the content into the specified language while copying into the target site.
3. For content to be pushed from source to target, it must share a content type
4. Variation can copy the data from target site to parent site.

✅ Correct Answer: 3

Select the correct combination for the available features and the SharePoint Server License Type.

1. Standard - Excel Service
2. Enterprise - Excel Service
3. Enterprise - Report Service
4. Standard - InfoPath Forms Services

✅ Correct Answer: 2

Name the three stages of Quiescing in SharePoint 2007

1. Normal
2. Quiescing
3. Dequiesced
4. Quiesced

✅ Correct Answer: 2

What are the correct statement with the Feature Installation/Activation in SharePoint

1. Feature can only be Installed through STSADM commands
2. Feature can be Installed through Central Administration
3. Feature needs to be deactivated from SharePoint side where it is activated, before uninstalling the Feature
4. Feature can be uninstalled through STSADM Commands as well from Central Administration

✅ Correct Answer: 3

Choose the Correct steps required to deploy a feature in SharePoint

1. Create a Folder in C.Program FilesCommon Filesmicrosoft sharedWeb Server Extensions12TEMPLATEFEATURES
2. Create a Folder in C.Program FilesCommon Filesmicrosoft sharedWeb Server Extensions12inFEATURES
3. Create a Feature.xml file in the Feature Folder Created
4. Use Central Administration to Install the Feature

✅ Correct Answer: 3

What is the Database which get created when we install WSS keeping all the defaults while installing

1. SQL Server 2000 Compact Edition
2. SQL Server 2005 Embedded Edition
3. SQL Server 2000 Embedded Edition
4. SQL Server 2005 Compact Edition

✅ Correct Answer: 2

What kind of Site Template we need to select for the site collection on the Destination Server Farm to receive the initial deployment job while using Content Deployment Feature in SharePoint 2007.

1. Publishing Template
2. Team Site
3. Blank
4. Any Template can be used

✅ Correct Answer: 3

Select the Information Management Policy which is not available in SharePoint 2007 by default.

1. Labels
2. Auditing
3. Archiving
4. Barcode

✅ Correct Answer: 3

Select the wrong STSADM commands related to Solution Deployment in SharePoint 2007.

1. stsadm -o addsolution -filename SampleSolution.wsp
2. stsadm -o deploysolution -name SampleSolution.wsp
3. stsadm -o retractsolution -name SampleSolution.wsp
4. stsadm -o removesolution -name SampleSolution.wsp

✅ Correct Answer: 4

When we take the Content DB associated with a web application to Offline status what effect it has on the sites in SharePoint 2007.

1. User can not browse any site collection created in the content dB.
2. No New further site collection can be created in this content dB.
3. No new sub sites can be created in the site collections already created in this content db
4. No modification can be made in the site collections associated with the content db and they become read only.

✅ Correct Answer: 2

Which of them is not the Core Upgrade methods to migrate from SharePoint 2003 to Microsoft Office SharePoint Server 2007.

1. InPlace Upgrade
2. Gradual Upgrade
3. OutPlace Upgrade
4. Content DB Migration

✅ Correct Answer: 3

You are planning to migrate from WSS 2.0 to WSS 3.0. What are the correct migration path which are possible.

1. WSS 2.0 to Microsoft Office SharePoint Server 2007
2. WSS 2.0 to WSS 3.0
3. SharePoint Portal Server 2003 to Microsoft Office SharePoint Server 2007
4. Content Management Server to Microsoft Office SharePoint Server 2007

✅ Correct Answer: 3

Which Information Management Policy does not come OOB with SharePoint 2007.

1. Labels
2. Expiration
3. Barcodes
4. Deletion

✅ Correct Answer: 4

While enabling Diagnostic Logging in Event Log what are the levels which are available which can be reported .

1. Error
2. Unexpected
3. Warning
4. Audit Failure

✅ Correct Answer: 3

While enabling Diagnostic Logging in Trace Log what is the levels which is not available which can be reporteD.

1. Verbose
2. Medium
3. High
4. information

✅ Correct Answer: 4

What are the correct statements regarding Recycle Bin in the SharePoint 2007.

1. There are two level of Recycle Bin in SharePoint 2007.
2. We can turn off both stage Recycle Bin through Central Admin.
3. We can turn off only only second stage Recycle Bin through Central Admin.
4. Once the Recycle Bin status is turned off all the deleted items in the recycle bin are permanently deleted

✅ Correct Answer: 2

Select the correct server roles which we can have on different Servers in a Microsoft Office SharePoint 2007 Farm .

1. Index Server
2. Forms Server
3. Query Server
4. Excel Calculation Server

✅ Correct Answer: 3

What is the new STSADM command which is introduced with SP2 release of SharePoint Server 2007.

1. Preupgradedetail
2. Preupgrademetod
3. Preupgradecheck
4. No new command has been introduced with SP2 pack

✅ Correct Answer: 3

Select the correct objects for which the Change Log feature in SharePoint tracks the changes .

1. Binary deployment
2. List metadata
3. List Items
4. Web Parts

✅ Correct Answer: 2

Which is not the correct version of CAL (Client Access License) available for SharePoint Server.

1. Office SharePoint Server 2007 Standard Edition
2. Windows SharePoint Services 3.0
3. Office SharePoint Server 2007 Enterprise Edition
4. Office SharePoint Server 2007 Developer Edition

✅ Correct Answer: 3

Following statements are correct for the domain account that is used to deploy SharePoint 2007..

1. Account should be local administrator on the Web servers
2. Account should be added as in the dbcreator role of SQL Server
3. Account should be added as in the securityadmin role of SQL Server
4. Added in the db_owner role in the master database in SQL Server

✅ Correct Answer: 3

Which is the user account SharePoint uses to access the configuration database or the content database for the Central Administration site.

1. The Farm Administrator Account
2. The Site Collection Administrator for the Central Administration Site
3. The System account configured as the identity of the application pool
4. The domain account that is used to deploy SharePoint

✅ Correct Answer: 3

What are correct statements about the Managed Path in SharePoint 2007

1. Managed Path can be created of type "Wildcard Inclusion"
2. Managed Path can be created of type "Explicit Inclusion"
3. Managed Path are created at Web Application Level
4. Managed Path are created at Farm Level

✅ Correct Answer: 1

Following type of content sources can be crawled by default in SharePoint 2007

1. SharePoint Sites
2. Web Sites
3. File Share
4. Exchange Public Folder

✅ Correct Answer: 1

Select the correct caching which is available in SharePoint 2007

1. Output Caching
2. Object Caching
3. Disk Based Caching
4. Page Caching

✅ Correct Answer: 2

Select the correct statements.

1. BUILTINAdministrators is a member of the Farm Administrators group by default
2. BUILTINAdministrators is not a member of the Farm Administrators group by default
3. By default Farm Administrators are Site Collection Administrators for all the site collections in the farm.
4. By default Farm Administrators are not the Site Collection Administrators for all the site collections in the farm.

✅ Correct Answer: 4

The acronym WSS stands for what?

1. Windows Sharepoint Services
2. Windows Services Sharepoint
3. Windows Solid State
4. Windows Solely Solid

✅ Correct Answer: 1

To stop the OWS Timer what is the best command to run?

1. StopServiceOnDeveloperVPC.cmd
2. StopServicesOnDeveloperVPC.cmd
3. StopServicesOnDevVPC.cmd
4. StopOnDeveloperVPC.cmd

✅ Correct Answer: 2

A farm is made-up of one or more what?

1. Web commands
2. Web systems
3. Web services
4. Web applications

✅ Correct Answer: 4

In Sharepoint 2007 when in the template selection wizard - what two tabs are MOSS only options?

1. Enterprise and Development
2. Enterprise and Wiki
3. Blog and Development
4. Colloboration and Development

✅ Correct Answer: 1

The top level web site in a site collection is what?

1. The root
2. The nest
3. The parent
4. The top

✅ Correct Answer: 3

In Sharepoint 2007 - to create a web application you would use what?

1. The Sharepoint 2.0 Central Administration Site
2. The Sharepoint 3.0 Local Administration Site
3. The Sharepoint 3.0 Central Administration Site
4. The Microsoft 3.15 Central Administration Site

✅ Correct Answer: 3

A site collection is called an?

1. SPSite
2. GPSite
3. DPSite
4. APSite

✅ Correct Answer: 1

WSS v3 introduced what?

1. Data columns and site columns
2. Content types and site columns
3. Content types and directed lookup columns
4. Content types and wiki columns

✅ Correct Answer: 2

All web sites and workspaces below the parent site are called what?

1. Child web sites
2. Parent web sites
3. Fortified web sites
4. Vertical web sites

✅ Correct Answer: 1

Using Powershell in Sharepoint 2010 which command is best to use for listing all sites on a farm?

1. Catch-SPSite
2. Get-SSite
3. Get-SPSite
4. Get-Spite

✅ Correct Answer: 3

In Powershell 2010 what is the best cmdlet to discover commands?

1. Get-Help
2. Get-Command
3. Help-Command
4. Get-Educate

✅ Correct Answer: 1

What are two new features in Sharepoint 2010?

1. Document Refernce and document
2. Document ID's and document sets
3. Document objects and document sets
4. Document ID's and document parts

✅ Correct Answer: 2

This tool helps with Metadata groups?

1. The term store management stool
2. The term store management bool
3. The term store management tool
4. The term store management fool

✅ Correct Answer: 3

In Sharepoint 2010 these are three search center templates?

1. Enterprise Center, Basic Center, Fast Center
2. Enterprise Search Center, Basic Search Center, Fast Search Center
3. Search Center, Search Center2, Search Center3
4. Enterprise Search Center, Canvas Search Center, Blinky Search Center

✅ Correct Answer: 2