Olete.in
Articles
Mock Tests
🧪 Sharepoint MCQ Quiz Hub
Sharepoint Mcq Question Set 1
Choose a topic to test your knowledge and improve your Sharepoint skills
1. What are the Correct statements about Configuration Database in SharePoint 2007.
Every Web Application has its own Configuration DB.
A Farm can have only a single config DB.
All the servers in a same farm are registered in the same Config DB.
A Config DB is created after running the Configuration WizarD.
2. Select the correct SQL Server Database versions which can be used for SharePoint Installation.
SQL Server 2008
SQL Server 2005
SQL Server 2000 with SP1
SQL Server 2000 with SP3a
3. Select the correct software configuration combination which can be used to install SharePoint 2007.
NET 2.0 with Windows XP
NET 2.0 , Windows Server 2003 Enterprise (SP1), IIS 6.0
NET 2.0 , Windows Server 2003 , IIS 5.0
NET 2.0 , Windows Server 2003 Standard (SP1), IIS 6.0
4. Select the correct activities happening while doing the SharePoint Installation (Multiple Select).
IIS modification happens during running the Configuration WizarD.
IIS modification happens during installing the SharePoint Server.
A Web Application is created to host Central Administration while running the Configuration WizarD.
A Config DB is created for the SharePoint Farm while running the Configuration WizarD.
5. Choose the correct options regarding SharePoint Installation.
Selecting Basic & Stand Alone mode allows to install SharePoint Server with SQL Server Express Edition.
Web Front End also install the Shared Services on the machine.
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.
Complete Installation allows to add/remove servers from the farm.
6. Adding a server to provide only Excel Services to an existing SharePoint Farm,what kind of installation we need to perform on the Server.
Basic
StandAlone
Web Front End
Complete
7. To add a server to an existing SharePoint Farm which serves only as web front End machine, what kind of installation we can perform.
Basic
StandAlone
Web Front End
Complete
8. Following Databases are created after the successful completion of the configuring wizard in SharePoint
Cofig DB for the SharePoint Farm
SSP Content DB
Content DB for the Central Admin
Config DB for the Central Admin
9. Select correct statements regarding the changes in IIS during the installation and configuration of SharePoint 2007.
No changes were made to IIS during the installation of SharePoint Server 2007
2 Application pools are created in IIS after the Configuration Wizard
The Central Administration Web site was created using the SharePoint Central Administration 3.0 application pool.
The Central Administration Web site was created using the OfficeServerApplicationPool application pool.
10. Name the two application pool accounts which are created after successful completion of configuration Wizard of SharePoint 2007.
SharePoint Central Administration 3.0
SharePointServerApplicationPool
OfficeServerApplicationPool
SharePoint Administration 3.0
11. Choose the correct statements about Variations used in SharePoint 2007 .
For Variation to work Office SharePoint Server Publishing Infrastructure should be activateD.
Variation changes the content into the specified language while copying into the target site.
For content to be pushed from source to target, it must share a content type
Variation can copy the data from target site to parent site.
12. Select the correct combination for the available features and the SharePoint Server License Type.
Standard - Excel Service
Enterprise - Excel Service
Enterprise - Report Service
Standard - InfoPath Forms Services
13. Name the three stages of Quiescing in SharePoint 2007
Normal
Quiescing
Dequiesced
Quiesced
14. What are the correct statement with the Feature Installation/Activation in SharePoint
Feature can only be Installed through STSADM commands
Feature can be Installed through Central Administration
Feature needs to be deactivated from SharePoint side where it is activated, before uninstalling the Feature
Feature can be uninstalled through STSADM Commands as well from Central Administration
15. Choose the Correct steps required to deploy a feature in SharePoint
Create a Folder in C.Program FilesCommon Filesmicrosoft sharedWeb Server Extensions12TEMPLATEFEATURES
Create a Folder in C.Program FilesCommon Filesmicrosoft sharedWeb Server Extensions12inFEATURES
Create a Feature.xml file in the Feature Folder Created
Use Central Administration to Install the Feature
16. What is the Database which get created when we install WSS keeping all the defaults while installing
SQL Server 2000 Compact Edition
SQL Server 2005 Embedded Edition
SQL Server 2000 Embedded Edition
SQL Server 2005 Compact Edition
17. 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.
Publishing Template
Team Site
Blank
Any Template can be used
18. Select the Information Management Policy which is not available in SharePoint 2007 by default.
Labels
Auditing
Archiving
Barcode
19. Select the wrong STSADM commands related to Solution Deployment in SharePoint 2007.
stsadm -o addsolution -filename SampleSolution.wsp
stsadm -o deploysolution -name SampleSolution.wsp
stsadm -o retractsolution -name SampleSolution.wsp
stsadm -o removesolution -name SampleSolution.wsp
20. When we take the Content DB associated with a web application to Offline status what effect it has on the sites in SharePoint 2007.
User can not browse any site collection created in the content dB.
No New further site collection can be created in this content dB.
No new sub sites can be created in the site collections already created in this content db
No modification can be made in the site collections associated with the content db and they become read only.
21. Which of them is not the Core Upgrade methods to migrate from SharePoint 2003 to Microsoft Office SharePoint Server 2007.
InPlace Upgrade
Gradual Upgrade
OutPlace Upgrade
Content DB Migration
22. You are planning to migrate from WSS 2.0 to WSS 3.0. What are the correct migration path which are possible.
WSS 2.0 to Microsoft Office SharePoint Server 2007
WSS 2.0 to WSS 3.0
SharePoint Portal Server 2003 to Microsoft Office SharePoint Server 2007
Content Management Server to Microsoft Office SharePoint Server 2007
23. Which Information Management Policy does not come OOB with SharePoint 2007.
Labels
Expiration
Barcodes
Deletion
24. While enabling Diagnostic Logging in Event Log what are the levels which are available which can be reported .
Error
Unexpected
Warning
Audit Failure
25. While enabling Diagnostic Logging in Trace Log what is the levels which is not available which can be reporteD.
Verbose
Medium
High
information
26. What are the correct statements regarding Recycle Bin in the SharePoint 2007.
There are two level of Recycle Bin in SharePoint 2007.
We can turn off both stage Recycle Bin through Central Admin.
We can turn off only only second stage Recycle Bin through Central Admin.
Once the Recycle Bin status is turned off all the deleted items in the recycle bin are permanently deleted
27. Select the correct server roles which we can have on different Servers in a Microsoft Office SharePoint 2007 Farm .
Index Server
Forms Server
Query Server
Excel Calculation Server
28. What is the new STSADM command which is introduced with SP2 release of SharePoint Server 2007.
Preupgradedetail
Preupgrademetod
Preupgradecheck
No new command has been introduced with SP2 pack
29. Select the correct objects for which the Change Log feature in SharePoint tracks the changes .
Binary deployment
List metadata
List Items
Web Parts
30. Which is not the correct version of CAL (Client Access License) available for SharePoint Server.
Office SharePoint Server 2007 Standard Edition
Windows SharePoint Services 3.0
Office SharePoint Server 2007 Enterprise Edition
Office SharePoint Server 2007 Developer Edition
31. Following statements are correct for the domain account that is used to deploy SharePoint 2007..
Account should be local administrator on the Web servers
Account should be added as in the dbcreator role of SQL Server
Account should be added as in the securityadmin role of SQL Server
Added in the db_owner role in the master database in SQL Server
32. Which is the user account SharePoint uses to access the configuration database or the content database for the Central Administration site.
The Farm Administrator Account
The Site Collection Administrator for the Central Administration Site
The System account configured as the identity of the application pool
The domain account that is used to deploy SharePoint
33. What are correct statements about the Managed Path in SharePoint 2007
Managed Path can be created of type "Wildcard Inclusion"
Managed Path can be created of type "Explicit Inclusion"
Managed Path are created at Web Application Level
Managed Path are created at Farm Level
34. Following type of content sources can be crawled by default in SharePoint 2007
SharePoint Sites
Web Sites
File Share
Exchange Public Folder
35. Select the correct caching which is available in SharePoint 2007
Output Caching
Object Caching
Disk Based Caching
Page Caching
36. Select the correct statements.
BUILTINAdministrators is a member of the Farm Administrators group by default
BUILTINAdministrators is not a member of the Farm Administrators group by default
By default Farm Administrators are Site Collection Administrators for all the site collections in the farm.
By default Farm Administrators are not the Site Collection Administrators for all the site collections in the farm.
37. The acronym WSS stands for what?
Windows Sharepoint Services
Windows Services Sharepoint
Windows Solid State
Windows Solely Solid
38. To stop the OWS Timer what is the best command to run?
StopServiceOnDeveloperVPC.cmd
StopServicesOnDeveloperVPC.cmd
StopServicesOnDevVPC.cmd
StopOnDeveloperVPC.cmd
39. A farm is made-up of one or more what?
Web commands
Web systems
Web services
Web applications
40. In Sharepoint 2007 when in the template selection wizard - what two tabs are MOSS only options?
Enterprise and Development
Enterprise and Wiki
Blog and Development
Colloboration and Development
41. The top level web site in a site collection is what?
The root
The nest
The parent
The top
42. In Sharepoint 2007 - to create a web application you would use what?
The Sharepoint 2.0 Central Administration Site
The Sharepoint 3.0 Local Administration Site
The Sharepoint 3.0 Central Administration Site
The Microsoft 3.15 Central Administration Site
43. A site collection is called an?
SPSite
GPSite
DPSite
APSite
44. WSS v3 introduced what?
Data columns and site columns
Content types and site columns
Content types and directed lookup columns
Content types and wiki columns
45. All web sites and workspaces below the parent site are called what?
Child web sites
Parent web sites
Fortified web sites
Vertical web sites
46. Using Powershell in Sharepoint 2010 which command is best to use for listing all sites on a farm?
Catch-SPSite
Get-SSite
Get-SPSite
Get-Spite
47. In Powershell 2010 what is the best cmdlet to discover commands?
Get-Help
Get-Command
Help-Command
Get-Educate
48. What are two new features in Sharepoint 2010?
Document Refernce and document
Document ID's and document sets
Document objects and document sets
Document ID's and document parts
49. This tool helps with Metadata groups?
The term store management stool
The term store management bool
The term store management tool
The term store management fool
50. In Sharepoint 2010 these are three search center templates?
Enterprise Center, Basic Center, Fast Center
Enterprise Search Center, Basic Search Center, Fast Search Center
Search Center, Search Center2, Search Center3
Enterprise Search Center, Canvas Search Center, Blinky Search Center
Submit