1Z0-082 practice question 17 of 25
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Full set: 142 questionsINTERSECT returns only the rows that exist in the result sets of both SELECT statements (D). Column names in each SELECT may differ because Oracle derives the column names of the compound result from the first SELECT only; equivalence is required only in number and data types, not in names (A).
B. Both SELECT statements must project the same number of columns.
C. INTERSECT is commutative; reversing order does not change the result set.
E. Set operators treat NULLs as comparable; rows containing NULLs are included if identical.
1. Oracle Database 19c SQL Language Reference, “Set Operators”, sec. 7.2, Rules 2 & 4.
2. Oracle Database 19c SQL Language Reference, Example 7-4 (INTERSECT usage and column‐naming rules).
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 3Which statement is true about the INTERSECT operator used in compound queries?
- 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…
