QUESTION: 101

What is a potential design issue with the following code?

trigger accountTrigger on Account (before update){ Boolean processOpportunity = false; List<opportunity> opptysClosedLost = new List<opportunity>() List<opportunity> IstAllOpp = [select StageName from Opportunity where accountId IN :Trigger.newMap.keySet()]; if(!IstAllOpp.isEmpty()) processOpportunity = true; while(processOpportunity){ for(opportunity o : IstAllOpp) if(o.StageName == 'Closed - Lost') opptysClosedLost.add(o); processOpportunity = false; if(!opptysClosedLost.isEmpty()) delete opptysClosedLost;

SOQL could be avoided by creating a formula field for StageName in Account from the related Opportunity
The code will result in a System.LimitException : Too many script statements error
The code will result in a System.DmlException:Entity_is_Deleted error
The code will result in a System.LimitException: Apex CPU time limit exceeded error

Answer(s): D

Reveal Solution Next Question

QUESTION: 102

The Contact object has a custom field called "Zone." Its data type is "Text" and field length is 3.
What is the outcome after executing the following code snippet in the org?

List<Contact> contactsToBeInserted=new List<Contact>(); Contact contactInstance= new Contact(LastName='Smith', Department='Tech', Zone_c='IAD'); contactsToBeInserted.add(contactInstance); contactInstance= new Contact (LastName='Sm1th', Department='Tech', Zone_c='PITT'); contactsToBeInserted.add (contactInstance); Database.insert(contactsToBeInserted,true);

Both inserts succeed and the contact record that has the Zone value of 'PI'I'I' is set to NULL
A partial insert succeeds and the contact record that has the Zone value 'IAD' is inserted
Both inserts succeed and the contact record that has the Zone value of 'PITT' is truncated
An unhandled DML exception is thrown and no contact records are inserted

Answer(s): D

Reveal Solution Next Question