Oracle

1Z0-071 · Question #305

Examine this query: SELECT 2 FROM DUAL d1 CROSS JOIN DUAL d2 CROSS JOIN DUAL d3; What is returned upon execution?

The correct answer is B. 1 row. See the full explanation below for the reasoning.

Question

Examine this query:

SELECT 2 FROM DUAL d1 CROSS JOIN DUAL d2 CROSS JOIN DUAL d3; What is returned upon execution?

Options

A8 rows
B1 row
C6 rows
D3 rows
E0 rows
Fan error

How the community answered

(46 responses)

A
13% (6)
B
72% (33)
C
2% (1)
E
4% (2)
F
9% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-071 Practice