PD1 SOQL and SOSL 2

Question 1

What is the primary functional difference between SOQL and SOSL?

Accepted Answer

SOSL can search across multiple objects simultaneously, while SOQL queries one object at a time

Answer

SOQL searches text fields only, while SOSL queries all field types

Answer

SOQL is used in Apex while SOSL is used only in Visualforce

Answer

SOSL supports aggregate functions while SOQL does not

Question 2

What is the maximum number of records SOSL returns per object in search results?

Accepted Answer

200

Answer

100

Answer

500

Answer

2000

Question 3

Which SOQL clause is used with aggregate functions to group query results by a specified field?

Accepted Answer

GROUP BY

Answer

HAVING

Answer

AGGREGATE BY

Answer

PARTITION BY

Question 4

What is a bind variable in the context of a SOQL query in Apex?

Accepted Answer

An Apex variable referenced in a SOQL query using a colon (:) prefix

Answer

A variable that links two related objects together

Answer

A query parameter passed from a Visualforce page controller

Answer

A constant value hardcoded in a SOQL WHERE clause

Question 5

Which SOQL clause filters aggregate query results AFTER the GROUP BY operation has been applied?

Accepted Answer

HAVING

Answer

WHERE

Answer

FILTER

Answer

RESTRICT

Question 6

What is the effect of adding a FOR UPDATE clause to a SOQL query in Apex?

Accepted Answer

It locks the returned records to prevent concurrent modification by other transactions

Answer

It marks records as pending for a future DML update

Answer

It returns only records modified during the current transaction

Answer

It automatically updates the returned records using current field values

Question 7

In which scenario is SOSL preferred over SOQL?

Accepted Answer

When searching for a text string across multiple objects and fields simultaneously

Answer

When querying a single object using a known record ID

Answer

When performing aggregate calculations on numeric fields

Answer

When you need to return more than 50,000 records in one call