SQL Union Operator Trivia Quiz

10 Questions | Total Attempts: 428

SettingsSettingsSettings
SQL Union Operator Trivia Quiz - 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
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.