Oracle Exam 1Z0-071 Topic 11 Question 76 Discussion

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

Question #: 76
Topic #: 11

[All 1Z0-071 Questions]

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

AReversing the order of the intersected tables can sometimes affect the output.

BColumn names in each SELECT in the compound query can be different.

CINTERSECT returns rows common to both sides of the compound query.

DThe number of columns in each SELECT in the compound query can be different.

EINTERSECT ignores NULLs

Show Suggested Answer

Suggested Answer: A, C

by Sabra at Jul 07, 2023, 09:01 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Floyd

1 months ago

I'm gonna have to go with C and E. INTERSECT returns the common rows, and it ignores NULLs. Seems logical to me!

upvoted 0 times

...

Roxane

1 months ago

I'm not sure about E. Does INTERSECT really ignore NULLs? That seems a bit weird to me, but I could be wrong.

upvoted 0 times

Bev

5 days ago

I'm not sure about E. Does INTERSECT really ignore NULLs? That seems a bit weird to me, but I could be wrong.

upvoted 0 times

...

Margot

7 days ago

C) INTERSECT returns rows common to both sides of the compound query.

upvoted 0 times

...

Luther

8 days ago

A) Reversing the order of the intersected tables can sometimes affect the output.

upvoted 0 times

...

Loreen

2 months ago

Hah, reversing the order of the tables? That's like trying to swim upstream - it's just gonna mess things up! Option A is clearly wrong.

upvoted 0 times

Reena

9 days ago

E) INTERSECT ignores NULLs

upvoted 0 times

...

Beula

17 days ago

C) INTERSECT returns rows common to both sides of the compound query.

upvoted 0 times

...

Deonna

1 months ago

A) Reversing the order of the intersected tables can sometimes affect the output.

upvoted 0 times

...

Gregoria

2 months ago

I think B and D are also true. The column names and number of columns don't have to match in the SELECT statements.

upvoted 0 times

...

Lindsey

2 months ago

I'm not sure about statement E. Does INTERSECT really ignore NULLs?

upvoted 0 times

...

Antonio

2 months ago

I agree with Brice. Statement C makes sense logically.

upvoted 0 times

...

Brice

2 months ago

I think statement C is true because INTERSECT returns common rows.

upvoted 0 times

...

Delisa

2 months ago

Option C is definitely correct! INTERSECT returns the rows that are common to both queries. I'm confident in this answer.

upvoted 0 times

Melvin

1 months ago

Exactly, it's a useful operator for finding common data between two tables.

upvoted 0 times

...

Cassie

1 months ago

So, it basically gives you the intersection of the results from the two queries.

upvoted 0 times

...

Osvaldo

2 months ago

That's right! It only includes the rows that are present in both queries.

upvoted 0 times

...

Sheridan

2 months ago

I agree, option C is correct. INTERSECT returns rows common to both sides of the compound query.

upvoted 0 times

...

Delpha

3 months ago

I believe statement E is also true because INTERSECT ignores NULLs.

upvoted 0 times

...

Chanel

3 months ago

I agree with Arlie. Statement C makes sense logically.

upvoted 0 times

...

Arlie

3 months ago

I think statement C is true because INTERSECT returns common rows.

upvoted 0 times

...