Oracle Database SQL — Question 221

Examine this query:

SELECT * FROM bricks, colors -

Which two statements are true? (Choose two.)

Answer options

• A. You can add a USING clause with a join condition.
• B. You can add an ON clause with a join condition.
• C. You can add a WHERE clause with filtering criteria.
• D. It returns the number of rows in bricks plus the number of rows in COLORS.
• E. It returns the same rows as SELECT * FROM bricks CROSS JOIN colors;.

Correct answer: B, C

Explanation

The correct answers are B and C because you can indeed use an ON clause or a WHERE clause to specify join conditions or filtering criteria in SQL. Option A is incorrect since a USING clause is not applicable in this context, and option D is misleading as it suggests a count rather than a combination of rows, while E is false as the result set will differ unless specific conditions are met.