Topic: 1z0-082 topic 1 question 61

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A.
Duplicates are eliminated automatically by the UNION ALL operator
B.
The number of columns selected in each SELECT statement must be identical
C.
The names of columns selected in each SELECT statement must be identical
D.
The output is sorted by the UNION ALL operator
E.
NULLS are not ignored during duplicate checking

Re: 1z0-082 topic 1 question 61

B & E is correct answer

  • Ekos
  • New member
  • Offline

Re: 1z0-082 topic 1 question 61

i agree

Re: 1z0-082 topic 1 question 61

BE is correct answer

Re: 1z0-082 topic 1 question 61

B, E is correct

Re: 1z0-082 topic 1 question 61

A - false
B - true
C - false
D - false
E - true

Sources:
Oracle Documentation: Database > Oracle > Oracle Database > Release 19 > SQL Language Reference > 9 SQL Queries and Subqueries > a) The UNION [ALL], INTERSECT, MINUS Operators, b) Sorting Query Results
A The UNION ALL operator does not eliminate duplicate selected rows
B,C The corresponding expressions in the select lists of the component queries of a compound query must match in number and must be in the same data type group (such as numeric or character).
D For compound queries containing set operators UNION, INTERSECT, MINUS, or UNION ALL, the ORDER BY clause must specify positions or aliases rather than explicit expressions. Also, the ORDER BY clause can appear only in the last component query. The ORDER BY clause orders all rows returned by the entire compound query.

Re: 1z0-082 topic 1 question 61

B & E CORRECT ANSWER

  • ryuah
  • New member
  • Offline

Re: 1z0-082 topic 1 question 61

B,E is correct

Re: 1z0-082 topic 1 question 61

B - E is correct!

10 Reply by Oye

  • Oye
  • New member
  • Offline

Re: 1z0-082 topic 1 question 61

B and E

Re: 1z0-082 topic 1 question 61

B and E guys.