The EXISTS keyword will be true if:

• any row in the subquery meets the condition only.
• all rows in the subquery fail the condition only.
• both of these two conditions are met.
• neither of these two conditions is met.