Oracle
1Z0-071 · Question #272
1Z0-071 Question #272: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #272. The question stem and answer options stay visible for context.
Question
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Options
- AINTERSECT ignores NULLs.
- BReversing the order of the intersected tables can sometimes affect the output.
- CThe number of columns in each SELECT in the compound query can be different.
- DINTERSECT returns rows common to both sides of the compound query.
- EColumn names in each SELECT in the compound query can be different.
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.