ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 234 - Certified Platform Developer II discussion

Report
Export

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;
Answers
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.
Answers
B.
C.
Account a = (SELECT ID, Name, Type, (select contat,firstName, Contact,LastName from Account, Contacts) from Account where name; Ozone Electronic' Limit 1 );
Answers
C.
Account a = (SELECT ID, Name, Type, (select contat,firstName, Contact,LastName from Account, Contacts) from Account where name; Ozone Electronic' Limit 1 );
D.
List 1Accounts = (Select ID, Name, Type from Account Join (Select ID, firstname, lastname form Contact where contact account , name 'ozone electronics));
Answers
D.
List 1Accounts = (Select ID, Name, Type from Account Join (Select ID, firstname, lastname form Contact where contact account , name 'ozone electronics));
E.
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);)
Answers
E.
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
asked 23/09/2024
Nigel Choji
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first