Assuming that 'name; is a String obtained by an <apex:inputText> tag on a Visualforce page.
Which two SOQL queries performed are safe from SOQL injections? Choose 2 answers

• A.String query = 'SELECT Id FROM Account WHERE Name LIKE \''%' + name + '%\''; List<Account> results = Database.query(query);
• B.String query = 'SELECT Id FROM Account WHERE Name LIKE \''%' +
  String.escapeSingleQuotes(name) + '%\'';
  List<Account> results = Database.query(query);
• C.String query = '%' + name + '%';
  List<Account> results = [SELECT Id FROM Account WHERE Name LIKE :query];
• D.String query = 'SELECT Id FROM Account WHERE Name LIKE \''%' + name.noQuotes() + '%\''; List<Account> results = Database.query(query);

Comment: *

Name: *

Email: *

Verification: *

A developer has a Apex controller for a Visualforce page that takes an ID as a URL parameter. How should the developer prevent a cross site scripting vulnerability?

• A.String.escapeSingleQuotes(ApexPages.currentPage() .getParameters(). get('url_param'))
• B.ApexPages.currentPage() .getParameters() .get('url_param')
• C.String.ValueOf(ApexPages.currentPage() .getParameters() .get('url_param'))
• D.ApexPages.currentPage() .getParameters() .get('url_param') .escapeHtml4()

Comment: *

Name: *

Email: *

Verification: *

A developer must modify the following code snippet to prevent the number of SOQL queries issued from exceeding the platform governor limit. public class without sharing OpportunityService( public static List<OpportunityLineItem> getOpportunityProducts(Set<Id> opportunityIds){ List<OpportunitylineItem> oppLineItems = new List<OpportunityLineItem>(); for(Id thisOppId : opportunityIds){ oppLineItems.addAll([Select Id FROM OpportunityLineItems WHERE OpportunityId = :thisOppId)]; } return oppLineItems; } } The above method might be called during a trigger execution via a Lightning component.
Which technique should be implemented to avoid reaching the governor limit?

• A.Refactor the code above to perform only one SOQL query, filtering by the Set of opportunityIds.
• B.Use the System.Limits.getlimitQueries() method to ensure the number of queries is less than 100.
• C.Use the System.Limits.getQueries() method to ensure the number of queries is less than 100.
• D.Refector the code above to perform the SOQL query only if the Set of opportunityIds contains less 100 Ids.

Comment: *

Name: *

Email: *

Verification: *

When is an Apex Trigger required instead of a Process Builder Process?

• A.When a record needs to be created
• B.When a post to Chatter needs to be created
• C.When an action needs to be taken on a delete or undelete, or before a DML operation is executed.
• D.When multiple records related to the triggering record need to be updated

Comment: *

Name: *

Email: *

Verification: *

A developer wants to display all of the picklist entries for the Opportunity StageName field and all of the available record types for the Opportunity object on a Visualforce page. Which two actions should the developer perform to get the available picklist values and record types in the controller? Choose 2 answers.

• A.Use Schema.RecordTypeInfo returned by
  RecordType.SObjectType.getDescribe().getRecordTypeInfos().
• B.Use Schema.PicklistEntry returned by Opportunity.SObjectType.getDescribe().getPicklistValues().
• C.Use Schema.RecordTypeInfo returned by
  Opportunity.SObjectType.getDescribe().getRecordTypeInfos().
• D.Use Schema.PicklistEntry returned by Opportunity.StageName.getDescribe().getPicklistValues().

Comment: *

Name: *

Email: *

Verification: *