Oracle
1Z0-047 · Question #43
Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)
The correct answer is C. You can use the USING clause to join tables on more than one column. D. You can use the ON clause to specify multiple conditions while joining tables. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)
Options
- AYou can use the JOIN clause to join only two tables.
- BYou can explicitly provide the join condition with a NATURAL JOIN.
- CYou can use the USING clause to join tables on more than one column.
- DYou can use the ON clause to specify multiple conditions while joining tables.
How the community answered
(36 responses)- A11% (4)
- B19% (7)
- C69% (25)
Community Discussion
No community discussion yet for this question.