Machine-translated by Google. Questions are authored in English.
Top

Discussion

The EXISTS keyword will be true if any row in the subquery meets the condition.

 

  • A.True
  • B.False

Answer: A

Correct answer: True

EXISTS returns true as soon as the subquery yields a single row. It examines only whether rows exist, not what they contain, which is why it can stop at the first match and why the select list inside it is conventionally written as SELECT * or SELECT 1.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.