1Z0-082 practice question 3 of 25
Which statement is true about the INTERSECT operator used in compound queries?
Full set: 142 questionsThe INTERSECT operator, like other set operators (UNION, MINUS), compares entire rows from the result sets of two queries. For the purpose of this comparison, two NULL values in the same column position are considered equal. Therefore, INTERSECT will return a row containing a NULL if a matching row (including the NULL) exists in both result sets. This behavior is distinct from most other SQL comparisons where NULL is not equal to NULL.
A. Multiple INTERSECT operators can be used in a single SQL statement to find the intersection of more than two query results.
C. The INTERSECT operator has a higher precedence than UNION, UNION ALL, and MINUS. Queries are evaluated from top to bottom.
D. The INTERSECT operator does not ignore NULLs; it treats them as matching values when comparing rows between result sets.
1. Oracle Database SQL Language Reference, 19c. "The INTERSECT Operator". States, "For the purpose of the INTERSECT operator, two nulls are considered equal."
2. Oracle Database SQL Language Reference, 19c. "Set Operators". Describes the precedence: "The INTERSECT operator has a higher precedence than the UNION, UNION ALL, and MINUS operators."
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
- Question 10Which three statements are true about the Oracle Data Dictionary? (Choose three.)
