Which of the following SQL statements is used to add a new column to an existing table?
- ALTER TABLE ADD COLUMN
- CREATE TABLE
- INSERT INTO
- UPDATE TABLE SET
The SQL statement used to add a new column to an existing table is ALTER TABLE ADD COLUMN. This statement allows you to modify the structure of an existing table by adding a new column, specifying its name, data type, and any additional constraints.
Loading...
Related Quiz
- How can data pipeline monitoring contribute to cost optimization in cloud environments?
- How do workflow orchestration tools assist in data processing tasks?
- In an RDBMS, a ________ is a virtual table that represents the result of a database query.
- Scenario: Your team is tasked with implementing a recommendation engine that processes user interactions in near real-time. How would you design the pipeline architecture to handle this requirement effectively?
- What are the challenges associated with Data Lake implementation?