Question

Which of the following keywords uses a subquery to create a new table using existing database tables?

A) INSERT
B) UPDATE
C) CREATE
D) SELECT INTO

Answer 1

The keyword for creating a new table using a subquery from existing tables is D) SELECT INTO. This command copies data from one or more existing tables into a new table based on a specified condition.

Step-by-step explanation:

The keyword that uses a subquery to create a new table using existing database tables is D) SELECT INTO. This command selects data from one or more existing tables and inserts it into a new table. For example:

SELECT * INTO new_table FROM existing_table WHERE condition;

This statement would create a 'new_table' that includes all columns and rows from 'existing_table' that meet the specified condition. Unlike the INSERT keyword which is used to insert data into an existing table, or the UPDATE keyword which is used to update existing data, or the CREATE keyword which is used to create a new table without filling it with data from another table, the SELECT INTO statement is used specifically to create a new table and fill it with data retrieved through a subquery.