Which SQL keyword is used to name a new table and describe the table's columns?
A)SET
B)CREATE
C)SELECT
D)ALTER
E)CONSTRAINT

Question

Quizplus · Accepted Answer

The CREATE keyword is used to create a new table in SQL, and it allows you to specify the name of the new table and define the columns for the table. The syntax for the CREATE statement typically looks something like this: CREATE TABLE table_name (column1 datatype, column2 datatype, ...).

Option A (SET) is not used to create a new table or define columns. It is a keyword that can be used in various SQL statements to set values or parameters.

Option C (SELECT) is used to retrieve data from an existing table, but it does not create a new table or define columns.

Option D (ALTER) is used to modify an existing table, but it is not used to create a new table or define columns.

Option E (CONSTRAINT) is used to specify rules for the data in a table (such as setting a primary key), but it is not used to create a new table or define columns.

Which SQL Keyword Is Used to Name a New Table