Which two statements are true regarding the USING clause in table joins?

Which two statements are true regarding the USING clause in table joins? (Choose two .)

Which two statements are true regarding the USING clause in table joins? (Choose two .)

A.
It can be used to join a maximum of three tables.

B.
It can be used to restrict the number of columns used in a NATURAL join.

C.
It can be used to access data from tables through equijoins as well as nonequijoins.

D.
It can be used to join tables that have columns with the same name and compatible data types.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Ritam Tiwari

Ritam Tiwari

option D is wrong:

correct statement is :

It can be used to join tables that have columns with the same name and “INcompatible” data types.

Nikhil

Nikhil

Option d is wrong

Sayed

Sayed

I think option C and D are correct. USING cannot be used with NATURAL JOIN. So, B is wrong. A is definitely wrong.

alex

alex

In my opinion A and B are wrong
I can’t understand B sentence.
Really Probably C and D correct

FireSolid

FireSolid

C is also incorrect. An equijoin is a join with a join condition containing an equality operator (=).