Question

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

Answer 1

The keyword 'AS' must be used with the CREATE TABLE command when creating a table from a subquery, as it specifies the subquery that forms the new table's structure and contents.

Step-by-step explanation:

The keyword that must be used with the CREATE TABLE command when the table is being created from a subquery is AS. When using a subquery to define the new table, the AS keyword is employed to specify the subquery that selects data which will determine the structure and contents of the new table. The CREATE TABLE statement will then use the results of the subquery to establish the column definitions and populate the rows of the new table.