Multiple choice technology programming languages

Which statement about the use of table aliases is false?

  1. Table aliases must be used when referencing identical table names from different libraries.

  2. Table aliases can be referenced by using the keyword AS.

  3. Table aliases (or full table names) must be used when referencing a column name that is the same in two or more tables.

  4. Table aliases must be used when using summary functions.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Table aliases are optional when applying summary functions like SUM or AVG unless needed to disambiguate identical column names across multiple joined tables. The other statements correctly describe SQL syntax rules, including using the AS keyword and disambiguating columns.