1Z0-071 practice question 18 of 35
SELECT * FROM bricks,colors; Which two statements are true?
Full set: 326 questionsA comma-separated table list with no predicate produces a Cartesian product identical to the explicit CROSS JOIN syntax. Additional filtering is supplied via a WHERE clause; ON or USING may only accompany ANSI JOIN operators (JOIN … ON/USING) and are invalid with the comma style. Hence adding WHERE is legal; the result set equals that of SELECT FROM bricks CROSS JOIN colors.
A. ON can accompany only explicit JOIN syntax, not the comma operator.
C. The Cartesian product returns rows = rows(bricks) × rows(colors), not their sum.
D. USING is likewise available only with explicit JOIN syntax.
1. Oracle Database SQL Language Reference 19c – “FROM clause” → “Comma-Separated Joins” and “CROSS JOIN”.
2. Oracle Database SQL Language Reference 19c – syntax diagrams for SELECT showing WHERE allowed after FROM.
3. MIT OpenCourseWare 6.830 – Lecture 3 slides, “Cartesian products in SQL,” equating comma joins and CROSS JOIN.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
