Oracle Exam 1Z0-071 Topic 5 Question 29 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 29
Topic #: 5

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS?

AThe name off each column in the first Select list must match the name of the corresponding column In each subsequent select list.

BThe must be an equal number of columns In each select list.

CNone of the set operators can be used when selecting CLOB columns.

DEach select statement In the query can have an order by clause.

EThe FOR update clause cannot be specified.

Show Suggested Answer

Suggested Answer: B, E

by Alishia at May 09, 2022, 11:06 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!