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

Discussion

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

  • A.True
  • B.False

Answer: B

Correct answer: False

That describes EXISTS. NOT EXISTS is its negation and is true only when the subquery returns no rows - that is, when every row fails the condition. Confusing the two inverts the result of the query, and since both are commonly written in the same statement the distinction has to be held clearly.

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

Post your comment

Please log in or register to post a comment.