Q. Which operators test whether a subquery returns any rows?

  • (A) IN and NOT IN
  • (B) EXISTS and NOT EXISTS
  • (C) PRESENT
  • (D) ABSENT
💬 Discuss
✅ Correct Answer: (B) EXISTS and NOT EXISTS
Explanation: This question is about how we check if a smaller query (called a subquery) finds any matching data. Think of it like searching for a specific book in a library.

Published by Sonali Mishra ⭐ 4.53K Points at 22-Mar-2025 12:46 pm in MySQL

Explanation by: Sonali Mishra
This question is about how we check if a smaller query (called a subquery) finds any matching data. Think of it like searching for a specific book in a library.

💬 Discussion

📊 Question Analytics

👁️
118
Total Visits
📽️
1 y ago
Published
🎖️
Sonali Mishra
Publisher
📈
96%
Success Rate