What is the best option?

You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.

What is the best option?
A . CREATE TABLE customer_table_other CLONE customer_table
B. CREATE TABLE customer_table_other AS SELECT * FROM customer_table
C. ALTER TABLE customer_table_other SWAP WITH customer_table

View Answer

Answer: A

Explanation:

Cloining is the best way as it does not copy the data and saves data storage cost