Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

Which statement adds a new column to an existing table?

A UPDATE table ADD column
B ALTER TABLE table ADD COLUMN name TYPE
C INSERT COLUMN INTO table
D MODIFY TABLE table ADD name

Answer

ALTER TABLE table ADD COLUMN name TYPE

ALTER TABLE performs schema changes. On large tables, adding a nullable column with no default is the cheapest form of this operation.

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer