Solved

Assume You Are Using the UNION ALL Operator to Combine

Question 14

Multiple Choice

Assume you are using the UNION ALL 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 Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the UNION ALL 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

Q15: Assume a designer is using the UNION

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

Q32: Automating business procedures and automatically maintaining data

Q32: The Oracle _ function compares an attribute