175k views
4 votes
What statement is true about a field specified in the USING clause?

The column loses its table identity, so it cannot be referenced in the SELECT or any other clause.
The column does not lose its table identity, so it must be fully qualified when referenced in the SELECT or any other clause.
The column loses its table identity, so it does not need to be qualified when referenced in the SELECT or any other clause.
The column loses its table identity, so it must be fully qualified when referenced in the SELECT or any other clause.

1 Answer

1 vote

The statement that is true about a field specified in the USING clause is (Option B). The column does not lose its table identity, so it must be fully qualified when referenced in the SELECT or any other clause.

When a column is specified in the USING clause of a query, it is used for the join condition and does not lose its table identity. Therefore, it needs to be fully qualified with the table name when referenced in the SELECT or any other clause of the query.

User Sinan ILYAS
by
7.9k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.