Exam 1z0-082 All QuestionsBrowse all questions from this exam
Go to Exam
Question 61

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

    Correct Answer: B, E

    The UNION and UNION ALL operators require that the number of columns selected in each SELECT statement must be identical to maintain the structure of the output. Additionally, NULL values are taken into account during duplicate checking which means that NULLs are not ignored when eliminating duplicates.

Discussion
you1234Options: BE

B & E is correct answer

Ekos

i agree

dotruonghanOptions: BE

BE is correct answer

nautil2Options: BE

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.

ryuahOptions: BE

B,E is correct

8hyehye8Options: BE

B, E is correct

babyjaanOptions: BE

B & E CORRECT ANSWER

GuhborgesOptions: BE

B - E is correct!

OyeOptions: BE

B and E

avanandOptions: BE

B and E guys.