Salesforce Certified Platform Developer II (Plat-Dev-301) PDII Question # 30 Topic 4 Discussion

Salesforce Certified Platform Developer II (Plat-Dev-301) PDII Question # 30 Topic 4 Discussion

PDII Exam Topic 4 Question 30 Discussion:
Question #: 30
Topic #: 4

A company has a custom object, Order__c, that has a custom picklist field, Status__c, with values of `˜New', `˜In Progress', or `˜Fulfilled' and a lookup field,

Contact__c, to Contact.

Which SOQL query will return a unique list of all the Contact records that have no `˜Fulfilled' Orders?


A.

SELECT Id FROM Contact WHERE Id NOT IN (SELECT Id FROM Order__c WHERE Status__c = 'Fulfilled')


B.

SELECT Contact__c FROM Order__c WHERE Status__c <> 'Fulfilled'


C.

SELECT Id FROM Contact WHERE Id NOT IN (SELECT Contact__c FROM Order__c WHERE Status__c = 'Fulfilled')


D.

SELECT Contact__c FROM Order__c WHERE Id NOT IN (SELECT Id FROM Order__c Where Status__c = 'Fulfilled')


Get Premium PDII Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.