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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
you1234
Highly Voted 4 years agoEkos
3 years, 7 months agodotruonghan
Highly Voted 3 years, 11 months ago8hyehye8
Most Recent 3 months, 2 weeks agonautil2
7 months, 3 weeks agobabyjaan
1 year, 4 months agoryuah
2 years, 6 months agoGuhborges
2 years, 7 months agoOye
3 years, 7 months agoavanand
3 years, 10 months ago