📊 MySQL
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:

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

👁️
78
Total Visits
📽️
12 mo ago
Published
🎖️
Bhagwan Das
Publisher
📈
98%
Success Rate