Select the correct answerWhich SQL statement is used to create a new table?OptionsINSERT TABLECREATE TABLEADD TABLEMAKE TABLE

Break Down the Problem

1. Identify the question type: This is a multiple-choice question regarding SQL statements.
2. Understand the required action: Select the correct SQL statement that is used for creating a new table.

Relevant Concepts

1. SQL Statement Syntax:
   • The SQL command used to create a new table follows the syntax:

     CREATE TABLE table_name (
       column1_name data_type,
       column2_name data_type,
       ...
     );
     

Analysis and Detail

1. Evaluate Each Option:
   • INSERT TABLE: This option is incorrect because the INSERT statement is used to add rows to an existing table, not create a new table.
   • CREATE TABLE: This is the correct option as it directly corresponds to the standard SQL command for creating a new table.
   • ADD TABLE: This option is incorrect; there is no ADD TABLE command in SQL.
   • MAKE TABLE: This option is also incorrect; SQL does not include a MAKE TABLE command as part of its standard syntax.

Verify and Summarize

• The correct SQL statement for creating a new table is confirmed to be CREATE TABLE.
• This statement is standard and widely used in relational database management systems.

Final Answer

The correct answer is CREATE TABLE.