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

11 hours ago

I think the correct answers are A and B.

upvoted 0 times

...