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

Table name prefixes are only required when column names are ambiguous across multiple tables in the join. If a column name exists in only one table, SQL can resolve it without the table prefix. The statement claims it's 'mandatory', which is false.