# 1z0-071 — Question 604

**Type:** multiple_choice
**Topics:** topic_1

## Question

Examine the BRICKS table:

//IMG//


You write this query:

//IMG//


How many rows will the query return?

## Correct Answer

_See scenario._

## Explanation

Selected Answer: B
The correct answer is B which is 6 rows

Explanation:
The CROSS JOIN operation combines each row from the first table with each row from the second table. Since the BRICKS table has 4 rows, the result of the CROSS JOIN will have 4 * 4 = 16 rows.

The WHERE clause filters out rows where b1.weight is not less than b2.weight. This means that only rows where the weight of the first brick is less than the weight of the second brick will be included in the result. There are 6 such combinations: (5,10), (5,15), (5,20), (10,15), (10,20), and (15,20). So the final result will have 6 rows.

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/oracle/1z0-071/604  
Practice (tracked): https://hiexam.net/study/1z0-071/practice