Solved

Assume You Are Using the MINUS Operator to Combine the Results

Question 21

Multiple Choice

Assume you are using the MINUS 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 MINUS operator?


A) 0
B) 2
C) 8
D) 10

Correct Answer:

verifed

Verified

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

Related Questions

Q11: The _ function returns the current system

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.

Q24: A relational join operation merges rows from

Q25: The statement in SQL combines rows from

Q26: "Union­compatible" means that the .<br>A)names of the

Q41: A persistent stored module is stored and

Q74: If a designer wishes to create an