SQL Basics Practice Test

Which SQL statement creates a new table?

Insert Into Update Create Table Select

Correct Answer:

Create Table

Explanation:

Creating a new table in SQL is done with CREATE TABLE, which defines the table’s name and its columns with their data types and any constraints. This statement establishes the structure of the table, and you can add data later with INSERT. For example: CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(100), salary DECIMAL(10,2) ); The other statements perform actions on existing tables: INSERT INTO adds new rows, UPDATE changes data in existing rows, and SELECT retrieves data from the table.

Access more questions from this quiz

Continue to SQL Basics Practice Test for more practice questions and the full quiz experience.

Access More Questions