Which statement about CREATE TABLE ... LIKE is correct?

• A. Creates a populated table.
• B. Creates a clone of an existing table.
• C. Creates an empty copy of an existing table.
• D. Creates a view of an existing table.

Answer: (C)

Creating a table with this syntax builds a new table that has the same column definitions as an existing table but contains no rows. It copies the structure—names and data types—so you can later insert data into the new table or adjust its defaults and constraints as needed. This is different from copying the data itself, which would happen if you cloned the table or used a select-into/CTAS statement. It’s also not a view, which would be a virtual table built from a query. If you need a structure-only copy for scaffolding, this is the right tool; if you need an exact data copy, use a CTAS with a select from the source or a zero-copy clone for a point-in-time data copy.