APEX Session Quiz 3

What is SOQL?

• SOQL is the Salesforce Object Query Language. It is used to query data from Salesforce objects.

• SOQL Structured Query Language. SQL is used to communicate with a database.

• It is used to insert,update and delete data into Salesforce objects.

Is it possible to use multiple conditions in one SOQL statement?

• Yes

• No

How to use multiple conditions in one SOQL statement?

• By using logical operators (AND , OR)

• By using Airthmatic operators (+,-,*)

What is use of where clause in SOQL Statement?

• Use the WHERE keyword to filter the records.

• Use the WHERE keyword to select fields from the database.

WHERE is the optional clause in SOQL statement.

• TRUE

• FALSE

The correct syntax for LIMIT in SOQL statement is:

• Select Id from Account Limit 10 where Id !=null

• Select Id from Account where Id !=null limit

• Select Id from Account where Id !=null limit 10

• None of them

SELECT Id,Name,Industry from Account where Industry NOT IN ('Transportation','Communication');

• The records that do not match the values specified are returned.

• The records that match the values specified are returned.

• All the records in account object will be returned.

• Nothing

SELECT Id,Name,Industry from Account where Industry IN ('Transportation','Communication');

• The records that matches the values specified are returned.

• The records that do not match the values specified are returned.

What will be the output of the following query?

Account acc = [Select id from Account limit 10];

• 10 records will be returned and will be stored in acc variable.

• No records will be returned by this query.

• Error.

What will be the output of the following code?

string industry = 'Transportation';

List<Account> acclist = [Select id from Account where industry = industry];

• All the records in which industry value is 'Transportation' will be fetched.

• All the records in which industry value is not 'Transportation' will be fetched.

• Error.