Multiple choice

Consider the query:

(select customer-name from depositor) union (select customer-name from borrower)

The output will

  1. return all customer names without duplicate values

  2. return all customer names from the depositor table

  3. return all customer names from borrower table

  4. return all customer names if names available in depositor table match with borrower table

  5. return all customer names with duplicate values
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The union operator is used to combine the result-set of two or more SELECT statements. The union operator selects only distinct values by default. Here, it will return the customer names, who all are listed in depositor table and borrower table without repeating the names.

Keep practicing — related questions