If you run the below commands in your worksheet, what will happen?

If you run the below commands in your worksheet, what will happen?

CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE

STUDENT_TABLE_CLONE

CLONE STUDENT_TABLE;
A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE
B. Only the STUDENT_TABLE_CLONE will be created, the other one will be deleted
C. You will get an error as below
D. SQL compilation error: Temp table cannot be cloned to a permanent table; clone to a transient table
instead.

View Answer

Answer: D

Explanation:

In the exam, you probably will never be asked the question this way. But what are you learning here