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

Question

Quizplus · Accepted Answer

The correct command to create a new table from existing data is "CREATE TABLE...AS". This command allows users to select data from an existing table and insert it into a new table with the specified name. The syntax for this command is "CREATE TABLE new_table_name AS SELECT * FROM existing_table_name".

Which Command Instructs Oracle11g to Create a New Table from Existing