exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 99 discussion

Actual exam question from Oracle's 1z0-082
Question #: 99
Topic #: 1
[All 1z0-082 Questions]

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

  • A. the first NUMBER column in the first SELECT of the compound query
  • B. the first NUMBER or VARCHAR2 column in the last SELECT of the compound query
  • C. the first column in the last SELECT of the compound query
  • D. the first column in the first SELECT of the compound query
  • E. the first VARCHAR2 column in the first SELECT of the compound query
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Guhborges
3 months, 2 weeks ago
D. the first column in the first SELECT of the compound query. When using SET operators such as INTERSECT in a SQL statement, the default column or columns for sorting output is based on the column order in the first SELECT statement of the compound query. Specifically, the first column in the first SELECT statement is used to sort the results. If you want to change the sort order or use a different column for sorting, you can use an ORDER BY clause at the end of the compound query.
upvoted 1 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago