Exam 1z0-082 topic 1 question 2 discussion

B. SET operators all have the same priority in Oracle Database. NULL values are processed with set operators

Quotations originate in official Oracle Database 19c documentation. A – false; following query is executed successfully: SELECT empno FROM history WHERE beginyear <= 1995 INTERSECT SELECT empno FROM employees WHERE job='TRAINER' INTERSECT SELECT trainer FROM offerings WHERE location <> 'SEATTLE'; B – true; “The INTERSECT operator with the keyword ALL returns the result of two or more SELECT statements in which rows appear in all result sets. Null values that are common across the component queries of INTERSECT ALL are returned at the end of the result set.” C – false; “You can combine multiple queries using the set operators UNION, UNION ALL, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL, MINUS, and MINUS ALL. All set operators have equal precedence.” D – false; see answer B

B is the correct answer.

Provided answer is correct.

B 100%

SET operators process NULL values

B is correct

agree, answer should be B

B is correct

B is correct

B is right.

SELECT 1, 2 FROM DUAL UNION SELECT 2, 3 FROM DUAL INTERSECT SELECT NULL, NULL FROM DUAL INTERSECT SELECT NULL, NULL FROM DUAL; returns "no data found".