Infosys SharePoint Interview
1. Difference b/w Site Definition and Site Template
2. Infopath
3. What is ghosting and unghosting?
What is a Site Definition?
To understand what a site definition physically is you first need to understand some extremely basic facts about how SharePoint operates. Very simply put, all user content on a SharePoint site is located in a SQL Server database. All the code and the pages that are used to administer and render the SharePoint site are stored as physical files on the web server. A site definition exists as physical files on the web server and defines, through the use of SharePoint’s XML schema (known as CAML), the lists, columns, features etc. that should be created/activated when a site is created.
Creating site definitions involves a fairly good understanding of CAML. Generally speaking, it requires the knowledge of an adept SharePoint developer (not the same as an adept ASP.NET developer… but thats an argument for another post) to create these site definitions.
[Warning: Personal Opinion Ahead]
Software developers tend to be advocates of site definitions. It fits with the ‘perfect world’ outlook most software developers tend to apply to everything they do. By not allowing change it means a software developer can request a department to ‘fully analyse’ their department and not come back until they have ALL their requirements listed. This is the usual practice of a software developer ‘handling’ change by not allowing it altogether. [N.B. I am a software developer and in my younger days have been guilty of this too so no hate mail about this comment.]
What is a Site Template?
If you can understand what a site definition is then you’re already halfway there to understanding a site template. A site template is just the modified version of a site definition. These can easily be created as they are just a matter of making changes to a site, such as creation of lists and activation of features, and then saving those changes as a template. Saving those changes is as simple as going to the ‘Site Settings’ area and look for the option ‘Save site as template’ under the ‘Look and Feel’ category (shown in Figure 1).
Generally speaking its recommended by most that you try to stick to site templates. They are a lot simpler to work with and in the background SharePoint is not binding the site to the site template. I like to think of the site template as a sort of XML script that will build the site automatically for you after the site definition for the site has been declared.
4. Diff b/w SPSITE and SPWEB?
5. How to deploy Silverlight application in MOSS?
6. What are webparts?
7. How to write a query in a webpart using out of box functionality in SP?
8. What is Sharepoint?
9. What are the features available in MOSS 2007?
10.what is BDC and how to configure BDC in MOSS?
11.Difference between Solution and Feature?
12. Diff b/w Site Solution and web application?
13. What is Shared Service Provider contains?
14.Security Levels in Sharepoint?
15. In document library user level settings
16. Explain the steps in creating webparts?
17. Difference between solution and feature
18. Difference between Master page and Page Layout
19. Workflow types
20. Infopath forms
21. Difference between Form Library and Doc Library
22. What is collaboration portal
23. Search functionality
24. What is CAML query
25. what does BDC metaman contains
26. Event handling in Sharepoint
27.How to initiate workflow in Sharepoint
28.Difference between site definition and site template
29. How to change Themes
30. What is the use of css in sharepoint
MOSS
1. Difference between Master page and Page Layout?
2. Sp Object model
3. Write code for looping through doc library and list? How to upload documents into doc library using code?
4. how do you the backup in Sharepoint
Ans: Operations -> Backup And Restore
5. Steps in webpart deployment. You have no full permissions to deploy in production server. Then how you will deploy?
Ans:Use wssv22 tool. It creates wsp file( Site package file)
6. What are event hanlders in Sharepoint
Ans: Synchronous (ing) and Asynchronous (ed) doubt
7.In Sp what are event receivers?
Ans: SPList and SpItem.
What is their base class?
Ans: SpReceiverBase
8. Security Permissions in SP?
Ans: Contributor
Reader
Full Control
9. What are content types?
In Document Library we have Add Columns , Multi Columns
Ans: check this box “Calculated Fields” .. I= PNR/100
10. You created Doc Library Templates and HR created another library,Different people in organisation created different documents.
One should not view documents created by others. How to achieve this in Sharepoint?
Ans: Sharepoint Service Provider -> Audience And Targetting
11. What is the use of BDC ?
12. Are you using any tools for BDC? How to configure?
13. You want to get Top 5 records from a database and to display in a webpart. What is the out of box feature available in Sharepoint?
Ans: Use content query webpart.
It expects database connection and asks for a select query.
There write like this: select top 5 …
14. Infopath and Excel Services
15. Out of Box different workflow types?
Ans: Sequential
State
Steps : Initialize
Modify
Associate
16.What are the steps in creating a custom them?
Ans: hive/templates/themes
2 ways: 1. Theme gallery
2. In visual studio how u will or SPDesigner
Site.ApplyThemes
17. Namespace for webpart
18. UpdateChanges()
19.
Document Library Form Library
excel ,ppt and word ms office + Infopath form + xml files
+ flat files.(This is one of advantages in SPp 2007)
20. What is in SP collaboration portal ?
a. What is Publish , Unpublish , Report Center and Search Center.
b. Team Site
21. Different between 2007 and 2010?
22. STSADM tool is SP Administration. How to create a batch file?
23. What is Server Farm?
WebFront End Server , Application Server
Microsoft Capacity Planner, SqlServer
24. Performance Tools in SP
a. Search Tools
b. How to do crawling in content management
25. Sp + Silverlight
26. Difference WSS 3.0 and SP 2007
27. Difference Site Collection and Sites
28. Backup Restore tools
29. Webpart tools (See: Litware site)
30. How many Shared Providers can be created?
Ans: No Limit
31. Form Authentication
Ans:Create SqlProvider .Use SQLRegIIS.exe
32. Single Sign On
33. Any difference in time between SPTime and Sqlserver?
Ans: Yes
34. Write CAML sample query
1. Difference b/w Site Definition and Site Template
2. Infopath
3. What is ghosting and unghosting?
What is a Site Definition?
To understand what a site definition physically is you first need to understand some extremely basic facts about how SharePoint operates. Very simply put, all user content on a SharePoint site is located in a SQL Server database. All the code and the pages that are used to administer and render the SharePoint site are stored as physical files on the web server. A site definition exists as physical files on the web server and defines, through the use of SharePoint’s XML schema (known as CAML), the lists, columns, features etc. that should be created/activated when a site is created.
Creating site definitions involves a fairly good understanding of CAML. Generally speaking, it requires the knowledge of an adept SharePoint developer (not the same as an adept ASP.NET developer… but thats an argument for another post) to create these site definitions.
[Warning: Personal Opinion Ahead]
Software developers tend to be advocates of site definitions. It fits with the ‘perfect world’ outlook most software developers tend to apply to everything they do. By not allowing change it means a software developer can request a department to ‘fully analyse’ their department and not come back until they have ALL their requirements listed. This is the usual practice of a software developer ‘handling’ change by not allowing it altogether. [N.B. I am a software developer and in my younger days have been guilty of this too so no hate mail about this comment.]
What is a Site Template?
If you can understand what a site definition is then you’re already halfway there to understanding a site template. A site template is just the modified version of a site definition. These can easily be created as they are just a matter of making changes to a site, such as creation of lists and activation of features, and then saving those changes as a template. Saving those changes is as simple as going to the ‘Site Settings’ area and look for the option ‘Save site as template’ under the ‘Look and Feel’ category (shown in Figure 1).
Generally speaking its recommended by most that you try to stick to site templates. They are a lot simpler to work with and in the background SharePoint is not binding the site to the site template. I like to think of the site template as a sort of XML script that will build the site automatically for you after the site definition for the site has been declared.
4. Diff b/w SPSITE and SPWEB?
5. How to deploy Silverlight application in MOSS?
6. What are webparts?
7. How to write a query in a webpart using out of box functionality in SP?
8. What is Sharepoint?
9. What are the features available in MOSS 2007?
10.what is BDC and how to configure BDC in MOSS?
11.Difference between Solution and Feature?
12. Diff b/w Site Solution and web application?
13. What is Shared Service Provider contains?
14.Security Levels in Sharepoint?
15. In document library user level settings
16. Explain the steps in creating webparts?
17. Difference between solution and feature
18. Difference between Master page and Page Layout
19. Workflow types
20. Infopath forms
21. Difference between Form Library and Doc Library
22. What is collaboration portal
23. Search functionality
24. What is CAML query
25. what does BDC metaman contains
26. Event handling in Sharepoint
27.How to initiate workflow in Sharepoint
28.Difference between site definition and site template
29. How to change Themes
30. What is the use of css in sharepoint
MOSS
1. Difference between Master page and Page Layout?
2. Sp Object model
3. Write code for looping through doc library and list? How to upload documents into doc library using code?
4. how do you the backup in Sharepoint
Ans: Operations -> Backup And Restore
5. Steps in webpart deployment. You have no full permissions to deploy in production server. Then how you will deploy?
Ans:Use wssv22 tool. It creates wsp file( Site package file)
6. What are event hanlders in Sharepoint
Ans: Synchronous (ing) and Asynchronous (ed) doubt
7.In Sp what are event receivers?
Ans: SPList and SpItem.
What is their base class?
Ans: SpReceiverBase
8. Security Permissions in SP?
Ans: Contributor
Reader
Full Control
9. What are content types?
In Document Library we have Add Columns , Multi Columns
Ans: check this box “Calculated Fields” .. I= PNR/100
10. You created Doc Library Templates and HR created another library,Different people in organisation created different documents.
One should not view documents created by others. How to achieve this in Sharepoint?
Ans: Sharepoint Service Provider -> Audience And Targetting
11. What is the use of BDC ?
12. Are you using any tools for BDC? How to configure?
13. You want to get Top 5 records from a database and to display in a webpart. What is the out of box feature available in Sharepoint?
Ans: Use content query webpart.
It expects database connection and asks for a select query.
There write like this: select top 5 …
14. Infopath and Excel Services
15. Out of Box different workflow types?
Ans: Sequential
State
Steps : Initialize
Modify
Associate
16.What are the steps in creating a custom them?
Ans: hive/templates/themes
2 ways: 1. Theme gallery
2. In visual studio how u will or SPDesigner
Site.ApplyThemes
17. Namespace for webpart
18. UpdateChanges()
19.
Document Library Form Library
excel ,ppt and word ms office + Infopath form + xml files
+ flat files.(This is one of advantages in SPp 2007)
20. What is in SP collaboration portal ?
a. What is Publish , Unpublish , Report Center and Search Center.
b. Team Site
21. Different between 2007 and 2010?
22. STSADM tool is SP Administration. How to create a batch file?
23. What is Server Farm?
WebFront End Server , Application Server
Microsoft Capacity Planner, SqlServer
24. Performance Tools in SP
a. Search Tools
b. How to do crawling in content management
25. Sp + Silverlight
26. Difference WSS 3.0 and SP 2007
27. Difference Site Collection and Sites
28. Backup Restore tools
29. Webpart tools (See: Litware site)
30. How many Shared Providers can be created?
Ans: No Limit
31. Form Authentication
Ans:Create SqlProvider .Use SQLRegIIS.exe
32. Single Sign On
33. Any difference in time between SPTime and Sqlserver?
Ans: Yes
34. Write CAML sample query
