Oracle
1Z0-071 · Question #132
Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)
The correct answer is A. You can use the ON clause to specify multiple conditions while joining tables. D. You can use the USING clause to join tables on more than one column. See the full explanation below for the reasoning.
Question
Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)
Options
- AYou can use the ON clause to specify multiple conditions while joining tables.
- BYou can explicitly provide the join condition with a NATURAL JOIN.
- CYou can use the JOIN clause to join only two tables.
- DYou can use the USING clause to join tables on more than one column.
How the community answered
(26 responses)- A81% (21)
- B15% (4)
- C4% (1)
Community Discussion
No community discussion yet for this question.