When you code a union with the INTERSECT keyword to combine two result sets, the union

A. excludes rows from the second result set if they also occur in the first result set
B. includes all rows that occur in both result sets if the primary keys are the same
C. includes only rows that occur in both result sets
D. excludes rows from the first result set if they also occur in the second result set

Answer: C. includes only rows that occur in both result sets

Computer Science & Information Technology

You might also like to view...

A hyperlink is either text or a graphic that you click to go to a file, a location in a file, or a web page

Indicate whether the statement is true or false

Computer Science & Information Technology

What is the value of number after the following statements execute?

int number; number = 18 % 4 + 2; a. 3 b. 4 c. 6.5 d. 0 e. unknown

Computer Science & Information Technology