Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data analyst needs to create an empty managed table named table_name in the database_name database with a specific schema. The table must be recreated and empty, even if it already exists.
table_name
database_name
Which command should the analyst run to accomplish this?
A
CREATE TABLE database_name.table_name USING (width INT, length INT, height INT);
B
CREATE OR REPLACE TABLE database_name.table_name USING (width INT, length INT, height INT);
C
CREATE OR REPLACE TABLE database_name.table_name (width INT, length INT, height INT);
D
CREATE OR REPLACE TABLE table_name FROM database_name USING (width INT, length INT, height INT);
