engineering computer science MCQ #818

What is the purpose of the EXISTS operator in SQL?

engineering computer science MCQ #818

  1. Question 1

    Q1. What is the purpose of the EXISTS operator in SQL?

    • A) To test whether a subquery returns any rows
    • B) To test whether a subquery returns a specific value
    • C) To join tables
    • D) To filter data

    Answer: To test whether a subquery returns any rows

    Explanation: EXISTS operator tests whether a subquery returns any rows, allowing you to conditionally execute a query based on the existence of data.