Which of the following keywords uses a subquery to create a new table using existing database tables?
A) ALTER TABLE
B) GENERATE TABLE
C) CREATE TABLE...AS
D) CREATE TABLE...FROM

Question

​Which of the following keywords uses a subquery to create a new table using existing database tables?
A) ​ALTER TABLE
B) ​GENERATE TABLE
C) ​CREATE TABLE...AS
D) ​CREATE TABLE...FROM

Quizplus · Accepted Answer

The CREATE TABLE...AS statement allows for creating a new table based on an existing table, using a subquery to specify the data to be included in the new table. The other options listed do not involve creating a new table in this manner.

​Which of the Following Keywords Uses a Subquery to Create

Which of the Following Keywords Uses a Subquery to Create