Oracle Exam 1Z0-071 Topic 6 Question 107 Discussion

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

Question #: 107
Topic #: 6

[All 1Z0-071 Questions]

SELECT *

FROM bricks,colors;

Which two statements are true?

AYou can add an ON clause with a join condition.

BYou can add a WHERE clause with filtering criteria.

CIt returns the number of rows in BRICKS plus the number of rows in COLORS.

DYou can add a USING clause with a join condition.

EIt returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

Show Suggested Answer

Suggested Answer: B, C

by Jacki at Oct 20, 2024, 05:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

8 days ago

I'm pretty sure you can add a WHERE clause to filter the results. That's a no-brainer!

upvoted 0 times

...

13 days ago

I'm not sure about C and D. Can someone explain why they are not correct?

upvoted 0 times

...

21 days ago

I agree with Kimbery. The ON and WHERE clauses are used for joining and filtering.

upvoted 0 times

...

22 days ago

I think the correct answers are A and B.

upvoted 0 times

...