1. How to show Force.com setup in Visualforce page as Side Bar?

https://www.infallibletechie.com/2017/12/how-to-show-forcecom-setup-in.html

2. File Upload and Download Security in Salesforce

https://www.infallibletechie.com/2017/12/file-upload-and-download-security.html

3. In converting VF to Lightning should we replace the whole page?

No. We can change wherever required.

To style your Visualforce page to match the Lightning Experience UI when viewed in Lightning Experience or the Salesforce app, set lightningStylesheets=”true” in the <apex:page> tag. When the page is viewed in Salesforce Classic, it doesn’t get Lightning Experience styling.

https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/vf_dev_best_practices_slds_lightningstylesheets.htm

4. When using APIs, REST APIs – how do we make the user stay on the same page even if the response takes more time? 

apex:actionStatus can be used.

https://www.infallibletechie.com/2012/12/apexactionstatus.html

5. Why we use SOSL instead of SOQL?

https://www.infallibletechie.com/2012/07/sosl-salesforce-object-search-language.html

6. Formula Fields and Workflow Field Updates


Both are easy to configure and no code is involved.


Formula Fields 

1. Changes in Parent record will be automatically reflected in child records.
2. Change in Formula field cannot invoke trigger or workflows.
3. Formula field values cannot be modified manually.

Workflow Field Updates

1. Changes in Parent record cannot be updated in child records.
2. If the record was updated with workflow field updates, fires before and after triggers one more time. Custom validation rules, duplicate rules, and escalation rules are not run again.
3. It considers criteria before updating the field value.