Is a clause that lets you add a new column to a table.

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Multiple Choice

Is a clause that lets you add a new column to a table.

Explanation:
To add a new column to an existing table, you use the ADD clause inside an ALTER TABLE statement. The ADD keyword specifies that a new column definition should be appended to the table’s structure. For example: ALTER TABLE employees ADD birthdate DATE; This shows how ALTER TABLE works to change the table, and ADD is the specific part that introduces the new column. The other options don’t fit: CREATE TABLE makes a new table, DELETE FROM removes rows, and ALTER TABLE by itself is the broader operation but not the clause that adds a column.

To add a new column to an existing table, you use the ADD clause inside an ALTER TABLE statement. The ADD keyword specifies that a new column definition should be appended to the table’s structure. For example: ALTER TABLE employees ADD birthdate DATE; This shows how ALTER TABLE works to change the table, and ADD is the specific part that introduces the new column. The other options don’t fit: CREATE TABLE makes a new table, DELETE FROM removes rows, and ALTER TABLE by itself is the broader operation but not the clause that adds a column.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy