nerdexam
Salesforce

PDII · Question #253

PDII Question #253: Real Exam Question with Answer & Explanation

The correct answer is D. SELECT Id From Opportunity WHERE Id IN (SELECT Opportunity_c FROM Request_c WHERE. See the full explanation below for the reasoning.

Question

A company has a custom object, Request_c, that has a checkbox field, Completed_c, and a Lookup to Opportunity, Opportunity_c. Which SOQL query will get a unique list of all of the Opportunity records that have a Completed Request?

Options

  • ASELECT Opportunity_c FROM Request_c WHERE Id IN (SELECT Id FROM Request_c Where
  • BSELECT Opportunity_c FROM Request_c WHERE Completed_c = true
  • CSELECT Id FROM Opportunity WHERE Id IN (SELECT Id FROM Request_c WHERE Completed
  • DSELECT Id From Opportunity WHERE Id IN (SELECT Opportunity_c FROM Request_c WHERE

Community Discussion

No community discussion yet for this question.

Full PDII Practice
A company has a custom object, Requestc, that has a checkbox... | PDII Q#253 Answer | NerdExam