Home » MCQs » Oracle MCQs » Oracle Tables MCQs

What is the syntax of CREATE TABLE AS?

13. What is the syntax of CREATE TABLE AS?

1. CREATE TABLE table_name AS (SELECT*FROM previoustable_name)
2. CREATE TABLE table_name IN (SELECT*FROM previoustable_name)
3. CREATE TABLE table_name FROM (SELECT*FROM previoustable_name)
4. CREATE TABLE table_name AT (SELECT*FROM previoustable_name)

Answer: A) CREATE TABLE table_name AS (SELECT*FROM previoustable_name)

Explanation:

Syntax of CREATE TABLE AS is CREATE TABLE table_name AS (SELECT*FROM previoustable_name).