Oracle Exam 1Z0-082 Topic 13 Question 47 Discussion

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

Question #: 47
Topic #: 13

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

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

Show Suggested Answer

Suggested Answer: A, D

by Lezlie at May 03, 2022, 05:27 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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