Notifications
Clear all
Topic starter
02/11/2022 10:25 am
A developer has requirement to query three fields (id, name, Type) from an Account and first and last names for all Contacts associated with the Account.
Which option is the preferred optimized method to achieve this for the Account named ‘Ozene Electronics’?
- A . Account a = (SELECT ID, Name, Type from Account where name= Ozone Electronics;) list 1contacts = (SELECT firstname, lastname from Contacts where accountid=: a -ID0;
- B . Account a = (SELECT ID, Name, Type, (select contat,firstName, Contact,LastName from Account, Contacts) from Account where name; Ozone Electronic' Limit 1 );
- C . List 1Accounts = (Select ID, Name, Type from Account Join (Select ID, firstname, lastname form Contact where contact account , name 'ozone electronics));
- D . List 1Contacts = new list ( );
for(Contact c ; 1Select firstname, lastname Account, Name Account,ID Account, Type from
Contact where Account: Name=' electronics')) ( iContacts.add(c);)
Suggested Answer: B