Which of the following SQL commands is used to create a new table?
a) CREATE
b) ADD
c) INSERT
d) SELECT
Answer:
a) CREATE
Explanation:
The CREATE command in SQL is used to create a new table, database, or other database objects such as views, indexes, or stored procedures. It is an essential part of defining the database schema.
For example, CREATE TABLE employees (id INT, name VARCHAR(50), department VARCHAR(50)) will create a new table named “employees” with three columns.
The CREATE command is used during the initial design phase of the database and can also be used to create other structures like views and indexes.