Q. Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

  • (A) IN and NOT IN
  • (B) EXISTS and NOT EXISTS
  • (C) OUTER JOIN and INNER JOIN
  • (D) LEFT JOIN and RIGHT JOIN
💬 Discuss
✅ Correct Answer: (A) IN and NOT IN
Explanation: This question is about how to handle situations when a subquery (a query nested inside another query) produces multiple results. Think of it like this:

Published by Bhagwan Das ⭐ 4.44K Points at 22-Mar-2025 12:45 pm in MySQL

Explanation by: Bhagwan Das
This question is about how to handle situations when a subquery (a query nested inside another query) produces multiple results. Think of it like this:

💬 Discussion

📊 Question Analytics

👁️
111
Total Visits
📽️
1 y ago
Published
🎖️
Bhagwan Das
Publisher
📈
80%
Success Rate