Interview Questions administrator

Best SharePoint administrator Interview Questions and Answers with topic wise:


Recycle Bin | MMS | ManagedVsCrawledProperties |

Saturday, June 18, 2016

Lists and Libraries: Class Day3

In this article, We will cover below mentioned topics on SharePoint Lists and libraries. please feel free to reach me if have any clarifications or more information required on it.

Topics:
1) List and Library
2) site columns and List columns
3) site content type and list content type
4) Views
4) Cascade Delete
5) Restrict Delete
6) Enforce uniqueness
7) Calculated columns
8) lookup columns
9) Permissions
10) List Threshold
11) Indexing
12) Versioning, Checked-In/Out and Publish
13) Update Vs SystemUpdate Vs UpdateOverWriteversion
14) SharePoint real-time scenarios
15) SharePoint interview questions and answers
16) Read-Only columns(Eg: Created/Created By, Modified/Modified By etc..).\
17) File URL length restriction.
18) SPBuiltInFieldId


Basics on the List and Libraries:
  1. By default, Content type option is disabled at the list/library: To enable it: Go to list/library settings-->Advanced settings--> Make it as "Yes" to allow management of content type.
  2. By default, Threshold limit for the user:5000 items and for administrators: 20000. These values are hard-coded at the central admin level but Microsoft recommended is should not increase/change the default threshold values to avoid the performance issues.
  3. Best practice to handle the threshold: 1) Indexing the columns 2) Avoid threshold exception by maintaining the data/items in a folder structure( SharePoint considers Folder is an item and we can maintain 2000 items in it).
  4. Always go with the internal column names(Reason: Display name can be modified but internal can't be modified) to fetch the data and update an items.
  5. Go with the creating site columns option rather creating it in each list/library if the same column is used in more than one lists/libraries.
  6. Go with the site content types option if more than one site columns needs to preferred in the each lists/libraries.
  7. In views, Filter by [Me] if wants to show the results of current logged user only.
  8. Upload size limit of files to the document library is: By default: 50MB and max 2GB(SP2013) and max 10GB(SP2016).
  9. The files into the library should always be in published mode to get the updated changes by others.
  10. By default, SharePoint recommended support for indexing is 20.
  11. SharePoint handles the permissions at the lists/libraries and even items level also.
  12. Only option to change the list/library URL is through SharePoint designer.
  13. By default list/library permissions are inherited from parent but we can have an option to maintain the unique permissions at it.
  14. We don't have an option to add users/groups directly at the lists/library level in inheritance mode. If needs, break the inheritance and then add users/groups.
  15. Users should have minimum "contribute" level permissions to make CRUD operation at the list/library.
  16. Steps to support large files upload: 1) Increase the default value(Default: 50MB and Max support: 2GB) to the desired value 2) Increase the IIS request length 3) Increase the IIS connection timeout length. https://angler.wordpress.com/2012/03/21/increase-the-sharepoint-2010-upload-file-size-limit/ 
Please go the below articles for complete details:

RunWithElevatedprivileges
http://sharepointquicksolutions.blogspot.in/2012/11/all-ways-of-runwithelevatedprivileges.html

AllowUnsafeUpdates
http://sharepointquicksolutions.blogspot.in/2012/03/whenwherewhy-use-allowunsafeupdates-in.html

ForDigest Control
http://sharepointquicksolutions.blogspot.in/2012/03/wherewhenwhy-formdigest-control.html

Interviews questions with answers:
http://sharepointquicksolutions.blogspot.in/2013/01/list-vs-library-sharepoint-interview.html
http://sharepointquicksolutions.blogspot.in/2015/07/sharepoint-faqslistvslibrary.html
http://sharepointquicksolutions.blogspot.in/2012/06/content-types-in-sharepoint.html

PowerShell Scripts:
http://sharepointquicksolutions.blogspot.in//search/label/PowerShell


Your valuable suggestions/feedback helps me to give best outputs/results.

1 comment:

  1. Among other things, this trend drives entrepreneurs and managers to know more about how SharePoint can improve their business performance. It also hikes up the demand for professionals who have marketable SharePoint skills. This is great post by admin for beginners. Also find the best Online Share Point Training at StayGreenAcademy.com

    ReplyDelete