Gypr Interview Questions and Answers

Use dynamic SQL to create table view with more than 60 columns for different profiles

• Use dynamic SQL to generate the CREATE VIEW statement based on the profile requirements

• Iterate through the profile columns and add them to the CREATE VIEW statement dynamically

• Consider using a loop or a mapping function to handle the large number of columns efficiently

with sharing enforces sharing rules, without sharing doesn't enforce sharing rules, inherited sharing uses the sharing rules of the parent class

• with sharing keyword enforces sharing rules specified in the organization-wide defaults

• without sharing keyword doesn't enforce sharing rules, allowing access to all records

• inherited sharing keyword uses the sharing rules of the parent class

Sharing records using Organization Wide Defaults (OWD) in Salesforce

• Set OWD to Public Read Only to allow all users to view records but only the owner can edit

• Set OWD to Private to restrict access to only the record owner and users above in the role hierarchy

• Use Sharing Rules to extend access to specific groups of users

• Use Manual Sharing to grant access to individual users or groups on a case-by-case basis

Update account with count of contact involves updating the account with the number of contacts associated with it.

• Create a function to update the account with the count of contacts

• Retrieve the contacts associated with the account

• Calculate the count of contacts

• Update the account with the count of contacts

Recursion is a programming technique where a function calls itself in order to solve a problem.

• Identify the base case to stop the recursion

• Ensure the recursive call moves towards the base case

• Optimize recursion by using memoization or tail recursion

• Examples: factorial calculation, Fibonacci sequence

Async process in Salesforce allows for executing tasks in the background without blocking the main thread.

• Async processes in Salesforce are used to perform time-consuming operations without affecting the user experience.

• Apex provides @future annotation for asynchronous processing.

• Batch Apex is used for processing large data sets asynchronously.

• Queueable Apex allows chaining of asynchronous jobs.

• Platform Events can be used for real-time asynchronous processing.

Find duplicate characters and their count in a given string.

• Create an empty dictionary to store character count

• Iterate through the string and add characters to the dictionary

• If character already exists in the dictionary, increment its count

• Return the dictionary with character count

Sorting an integer array without using built-in array methods.

• Implement a sorting algorithm such as bubble sort, insertion sort, or selection sort.

• Loop through the array and compare adjacent elements to swap them if necessary.

• Repeat the loop until the array is sorted in ascending or descending order.