Apex Sessions Quiz 4

Which Aggregate function is not valid from the following.

• Sum()

• Count()

• Highest()

• Min()

You can use the GROUP BY option in a SOQL query to avoid iterating through individual query results.

• True

• False

Find out  how many accounts are there per industry type.

Select Industry,Count(Id) from Account;

What is missing in the above query?

• Group by Industry

• Where Industry

• Having Industry

• Nothing

A list is a collection of elements or records that you want to store.

List in Apex can store elements of any data type. It can store: Integer, String, Boolean and any custom data type as well. For example: Account, Contact, Employee__c (Custom Object) etc.

• True

• False

You can use ORDER BY in a SELECT statement to control the order of the query results.

• True

• False

Select Id, Industry,createddate from Account order by createddate

• Error

• the records will be fetched in ascending order

• the records will be fetched in descending order

When you do not specify the sort type like asc or desc in order by clause by default it takes asc

• True

• False

SOQL for loops are used when you need to iterate over all the sObject records returned by a SOQL query.

• True

• False

A Map is a collection of key-value pairs where each unique key maps to a single value.

• True

• False

Map<String, String> country_currencies = new Map<String, String>();

country_currencies.put('United States', 'USD');

country_currencies.put('Japan', 'YEN');

What will be the the output of the following statement.

system.debug(country_currencies.get('united states'));

• Null

• Error

• Nothing

• USD