Oracle
1Z0-071 · Question #188
Which statement is true regarding the USING clause in table joins? (Choose two.)
The correct answer is C. It can be used to join tables that have columns with the same name and compatible data types. D. It can be used to restrict the number of columns used in a NATURAL join. See the full explanation below for the reasoning.
Question
Which statement is true regarding the USING clause in table joins? (Choose two.)
Options
- AIt can be used to join a maximum of three tables.
- BIt can be used to access data from tables through equijoins as well as nonequijoins.
- CIt can be used to join tables that have columns with the same name and compatible data types.
- DIt can be used to restrict the number of columns used in a NATURAL join.
How the community answered
(23 responses)- A17% (4)
- B9% (2)
- C74% (17)
Community Discussion
No community discussion yet for this question.