Multiple choice technology databases

What is the purpose of the SQL AS clause?

  1. The AS clause is used with the JOIN clause only.

  2. The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

  3. The AS clause defines a search condition.

  4. The AS clause defines a join
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The AS clause in SQL is used to create column aliases - it renames a column in the query result or assigns a name to a calculated/derived column. It improves readability of output and allows referencing derived columns in other clauses (like ORDER BY). It is not specific to JOINs, does not define search conditions, and does not define joins.

Keep practicing — related questions