Multiple choice

Which of the following is not a difference between EXISTS and ANY/ALL?

  1. EXISTS is more powerful than ANY/ALL.

  2. All queries represented by ANY/ALL can be obtained by EXISTS operator.

  3. All queries represented by EXISTS may not be possible with ANY/ALL operator.

  4. ALL returns TRUE only if all the results of a subquery meet the condition, while EXISTS takes a subquery as an argument and returns TRUE if the subquery returns anything.

  5. Replacing EXISTS with ANY produces an identical result.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Replacing EXISTS with ANY may or may not produce identical result.

Keep practicing — related questions