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.
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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, 3 months agoEkos
3 years, 10 months agodotruonghan
Highly Voted 4 years, 3 months ago8hyehye8
Most Recent 7 months agonautil2
11 months agobabyjaan
1 year, 7 months agoryuah
2 years, 9 months agoGuhborges
2 years, 11 months agoOye
3 years, 11 months agoavanand
4 years, 2 months ago