What does the query return if there is no Contact with the last name 'Smith'?

A developer has the following query: Contact c = [SELECT id, firstname, lastname, email FROM Contact WHERE lastname = 'Smith']; What does the query return if there is no Contact with the last name 'Smith'?A . A contact initialized to null.B . An error that no rows are found.C ....

October 19, 2021 No Comments READ MORE +

Which SOQL query successfully returns the Accounts grouped by name?

Which SOQL query successfully returns the Accounts grouped by name?A . SELECT Type, Max(CreatedDate) FROM Account GROUP BY NameB . SELECT Name, Max(CreatedDate) FROM Account GROUP BY NameC . SELECT Id, Type, Max(CreatedDate) FROM Account GROUP BY NameD . SELECT Type, Name, Max(CreatedDate) FROM Account GROUP BY Name LIMIT 5View...

October 19, 2021 No Comments READ MORE +