Oracle
1Z0-071 · Question #437
1Z0-071 Question #437: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #437. The question stem and answer options stay visible for context.
Question
Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)? (Choose two.)
Options
- AThe name of each column in the first SELECT list must match the name of the corresponding
- BNone of the set operators can be used when selecting CLOB columns.
- CThere must be an equal number of columns in each SELECT list.
- DEach SELECT statement in the query can have an ORDER BY clause.
- EThe FOR UPDATE clause cannot be specified.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.