Solved

Assume a Designer Is Using the UNION Operator to Combine

Question 15

Multiple Choice

Assume a designer is using the UNION operator to combine the results from two tables with identical structure,CUSTOMER and CUSTOMER_2.The CUSTOMER table contains 10 rows,while the CUSTOMER_2 table contains 7 rows.Customers Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the UNION operator?


A) 7
B) 10
C) 15
D) 17

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q3: A(n) _ view is a view that

Q11: The _ function returns the current system

Q12: The following SQL statement uses a(n). SELECT

Q13: functions extract a value of a given

Q14: Assume you are using the UNION ALL

Q16: When using the Oracle TO_NUMBER function to

Q17: An implicit cursor is automatically created in

Q18: A(n)join will select only the rows with

Q19: MySQL allows multiple triggering conditions per trigger.

Q32: Automating business procedures and automatically maintaining data