Multiple choice technology databases

In a join condition it is mandatory to specify the table name along with the Column name.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In join conditions, specifying table names is NOT mandatory when column names are unambiguous. If a column name exists in only one of the joined tables, you can reference it directly without the table prefix. Table prefixes (or aliases) are only required when column names are ambiguous (exist in multiple tables). The claimed answer 'False' is correct.

Keep practicing — related questions