Which statement is true about the INTERSECT operator used in compound queries?
Which statement is true about the INTERSECT operator used in compound queries?
The INTERSECT operator in SQL is used to return the common records between two select statements. It processes NULLs in the selected columns, meaning it treats NULLs as equivalent and includes them in the result if they appear in both queries. Therefore, the correct statement about the INTERSECT operator is that it processes NULLs in the selected columns.
A definitely A it does not ignore NULL values
tested in sql dev
INTERSECT DOES NOT IGNORE NULLS
https://www.examtopics.com/discussions/oracle/view/8224-exam-1z0-071-topic-1-question-239-discussion/
A must be correct select null as nulltest from dual intesect select null as nulltest1 from dual it shows one row
select null as nulltest from dual intersect select null as nulltest1 from dual