SQL Server Course for Beginners with 100+ examples - SELECT INTO Statement in SQL

The video tutorial explains how to use the SQL ALTER TABLE statement to modify existing tables by adding or deleting columns. It demonstrates entering a database, displaying records, adding a new column named 'age', and then removing it. The tutorial concludes with a summary of the ALTER TABLE operations performed.

What is the primary use of the ALTER TABLE statement in SQL?

• To delete a table

• To update records in a table

• To add or delete columns in an existing table

• To create a new table

Which command is used to add a new column to an existing table?

• ALTER TABLE ADD COLUMN

• ALTER TABLE DROP COLUMN

• CREATE TABLE

• INSERT INTO

What happens to the new column 'age' after it is added to the table?

• It is filled with default values

• It contains null values

• It is automatically populated with data

• It is hidden until data is added

Which command is used to remove a column from a table?

• REMOVE COLUMN

• DELETE FROM TABLE

• ALTER TABLE DROP COLUMN

• ALTER TABLE ADD COLUMN

What must be omitted when using the DROP COLUMN command?

• The database name

• The table name

• The column name

• The data type