Question

Which SQL command is used to create a new table in a database ?

• A. Create
• B. Alter
• C. Drop
• D. Truncate

Hint:

Remember the main DDL commands: `CREATE` (to build), `ALTER` (to modify), and `DROP` (to destroy).

Answer 1

The Correct Option is A

Step 1: Understand the goal. The goal is to create a new database object, specifically a table.
Step 2: Differentiate the Data Definition Language (DDL) commands.

(A) \text{CREATE}: Used to build new database objects, such as \text{CREATE TABLE}, \text{CREATE DATABASE}. This matches the goal.
(B) \text{ALTER}: Used to modify the structure of an existing object, e.g., \text{ALTER TABLE}.
(C) \text{DROP}: Used to permanently delete an existing object, e.g., \text{DROP TABLE}.
(D) \text{TRUNCATE}: Used to delete all data from within a table, but the table structure itself remains.
The correct command to make a new table is \text{CREATE}.