Which command instructs Oracle 12c to create a new table from existing data?
A) CREATE NEW TABLE
B) CREATE TABLE...FROM
C) CREATE TABLE
D) CREATE TABLE...AS

Question

Which command instructs Oracle 12c to create a new table from existing data?​
A) ​CREATE NEW TABLE
B) ​CREATE TABLE...FROM
C) ​CREATE TABLE
D) ​CREATE TABLE...AS

Quizplus · Accepted Answer

The correct command to create a new table from existing data is "CREATE TABLE...AS". This command allows us to specify the selection criteria for the data we want to populate the new table with, such as filtering certain columns or rows. Option A ("CREATE NEW TABLE") and option B ("CREATE TABLE...FROM") are not valid commands in Oracle SQL. Option C ("CREATE TABLE") creates an empty table without any data from existing sources.

Which Command Instructs Oracle 12c to Create a New Table