Data Engineering Associate with Databricks Practice Exam

What SQL command is used to create a table with specific columns?

1. INSERT INTO

2. CREATE TABLE

3. UPDATE

4. DELETE FROM

The correct answer is: CREATE TABLE

The SQL command used to create a table with specific columns is the CREATE TABLE statement. This command is fundamental in SQL as it defines the structure of a new table within a database. When using CREATE TABLE, you specify the table name and the columns it should have, along with the data types for each column. For example, with CREATE TABLE, you can define a table named "Employees" with columns like "ID" (as an integer), "Name" (as a string), and "HireDate" (as a date). This statement not only establishes the table but also ensures that the data inserted into it adheres to the defined schema. Other commands serve different purposes and do not create tables: INSERT INTO is used for adding new records to an existing table, UPDATE modifies existing records, and DELETE FROM removes records from a table. Thus, these commands do not relate to the creation of a table and its specific columns, reinforcing why CREATE TABLE is the correct choice for this question.