Bird
0
0

Why do we use set operations like UNION and INTERSECT in SQL?

easy📝 Conceptual Q11 of 15
SQL - Set Operations
Why do we use set operations like UNION and INTERSECT in SQL?
ATo create new tables permanently
BTo delete rows based on conditions
CTo update values in a single table
DTo combine or compare rows from two or more tables easily
Step-by-Step Solution
Solution:

  1. Step 1: Understand the purpose of set operations

    Set operations like UNION and INTERSECT are designed to combine or compare rows from multiple tables.

  2. Step 2: Identify what set operations do not do

    They do not create tables, update, or delete rows; those are different SQL commands.

  3. Final Answer:

    To combine or compare rows from two or more tables easily -> Option D

  4. Quick Check:

    Set operations combine or compare data [OK]
Quick Trick: Set operations combine or compare rows from tables [OK]
Common Mistakes:
MISTAKES
  • Confusing set operations with data modification commands
  • Thinking UNION creates a new permanent table
  • Assuming INTERSECT deletes rows

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - COUNT function behavior - Quiz 7medium Set Operations - INTERSECT for common rows - Quiz 9hard Set Operations - Set operation column matching rules - Quiz 10hard Subqueries - Subquery with IN operator - Quiz 10hard Subqueries - Nested subqueries - Quiz 11easy Table Constraints - CHECK constraint - Quiz 5medium Table Relationships - ER diagram to table mapping - Quiz 6medium Views - Why views are needed - Quiz 3easy Views - Dropping and altering views - Quiz 2easy Views - CREATE VIEW syntax - Quiz 2easy