nerdexam
Oracle

1Z0-082 · Question #100

1Z0-082 Question #100: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #100. 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

  • AColumn names in each SELECT in the compound query can be different
  • BThe number of columns in each SELECT in the compound query can be different
  • CReversing the order of the intersected tables can sometimes affect the output
  • DINTERSECT returns rows common to both sides of the compound query
  • EINTERSECT ignores NULLs

Unlock 1Z0-082 to see the answer

You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.

Full 1Z0-082 Practice