What is the appropriate data definition language (DDL) statement for creating a new table in a database?

• A. INSERT TABLE
• B. CREATE TABLE
• C. ALTER TABLE
• D. DROP TABLE

Answer: (B)

To create a new table in a database, the appropriate data definition language (DDL) statement is "CREATE TABLE." This statement is specifically designed for defining and constructing new tables within a database schema. When using this command, you provide the necessary specifications, such as the table name and the details of the columns, including data types and constraints.

The CREATE TABLE statement is fundamental in database management because it sets the structure of the data that can be stored in that table. It establishes the framework for how the data will be organized, accessed, and manipulated.

The other options, while related to database management, serve different purposes. For instance, INSERT TABLE is not a valid SQL command; the correct command for adding records to an existing table is simply INSERT. ALTER TABLE is used to modify an existing table's structure, such as adding or dropping columns. DROP TABLE is employed to delete an entire table from the database. Each of these commands plays a role in the broader context of data manipulation and management, but only the CREATE TABLE command is appropriate for creating a new table.