Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 190

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

    Correct Answer: B, D

    The INTERSECT operator in compound queries returns only the rows that are common to both SELECT statements, ensuring that no duplicates exist. Therefore, it is essential for the SELECT statements to have the same number of columns with compatible data types. Columns named in each SELECT in the compound query can be different, as the intersection operation does not rely on column names but on the data contained within them. Reversing the order of the intersected tables does not affect the result because the operation is commutative. Hence, the correct answers are the statements indicating that INTERSECT returns rows common to both sides and that columns named in each SELECT can be different.

Discussion
jfc1Options: BD

I will choose BD

DarnunOptions: BD

Valid answers are BD

SantiBZ_07032022_1744Options: BD

I agree BD

alic_alexOptions: BD

B,D correct

yaya32Options: BD

BD is correct

Arth1989Options: BD

BD, tested.

lucemqyOptions: BD

BD is correct