If you are creating a new table from data contained in an existing table,new column names can be specified by including a list of column names ____.
A) before the AS clause
B) after the AS clause
C) in the subquery
D) after the subquery

Question

If you are creating a new table from data contained in an existing table,new column names can be specified by including a list of column names ____.​
A) before the AS clause
B) ​after the AS clause
C) in the subquery
D) after the subquery

Quizplus · Accepted Answer

When creating a new table from data contained in an existing table and specifying new column names, the list of column names should be included before the AS clause.

If You Are Creating a New Table from Data Contained