SQL Union Operator Trivia Quiz

10 Questions | Total Attempts: 223

SettingsSettingsSettings
Please wait...
SQL Union Operator Trivia Quiz

The SQL UNION is used in set operations. Test your knowledge in the use of the SQL UNION operator, and it's various functions in a data set by taking this quiz. You can also brush up on your knowledge of the difference between UNION, UNION ALL and lots more.


Questions and Answers
  • 1. 
    The SQL UNION Operator enables you draw information from two or more table with the _____ 
    • A. 

      Value

    • B. 

      Structure

    • C. 

      Rows

    • D. 

      Lines

  • 2. 
    To use the SQL UNION Operator, the tables must all have the same number of _____
    • A. 

      Columns

    • B. 

      Sets

    • C. 

      Orders

    • D. 

      Distinct values

  • 3. 
    To do a SQL UNION operation, the _____ types of the corresponding columns must be compatible.
    • A. 

      Row

    • B. 

      Number

    • C. 

      Option

    • D. 

      Data

  • 4. 
    What kind of rows does the UNION operation eliminate during operation?
    • A. 

      Duplicate Structures

    • B. 

      Duplicate rows

    • C. 

      Duplicate columns

    • D. 

      Duplicate values

  • 5. 
    If you want to keep the duplicate rows during the UNION operation, what keyword can you use?
    • A. 

      INTERSECT

    • B. 

      ALL

    • C. 

      MINUS

    • D. 

      INTEGER

  • 6. 
    Which of the following statements is correct?
    • A. 

      UNION does not remove duplicate rows

    • B. 

      UNION ALL does not remove duplicate rows

    • C. 

      UNION ALL removes duplicate rows

    • D. 

      UNION and UNION ALL do the exact same thing

  • 7. 
    Which of the following statements is correct?
    • A. 

      UNION is faster than UNION ALL

    • B. 

      Both UNION and UNION ALL compute at the same time

    • C. 

      UNION ALL is faster than plain UNION

    • D. 

      None of the above

  • 8. 
    To use the SQL UNION operator, the columns in each select statement must also be in the same _____
    • A. 

      Row

    • B. 

      Order

    • C. 

      Table

    • D. 

      Column

  • 9. 
    Which of these operators selects only distinct values by default?
    • A. 

      UNION

    • B. 

      UNION ALL

    • C. 

      Both

    • D. 

      None of the above

  • 10. 
    Which one of these statements is correct?
    • A. 

      In each SELECT statement, the columns must not be in the same order

    • B. 

      The columns must have analogous data types

    • C. 

      Within UNION each SELECT statement doesn't have to have the same columns numbers

    • D. 

      The UNION ALL operator selects distinct values by default

Related Topics
Back to Top Back to top