Question

Which of the following SQL command can change the degree of the existing relation?

Options

• DROP TABLE

• ALTER TABLE

• UPDATE...SET

• DELETE

Answer 1

ALTER TABLE

Explanation:

It can add or drop attributes (columns) and so changes the degree (number of attributes) of a relation. Other commands (DROP TABLE removes the whole relation, DELETE removes tuples, UPDATE changes values) do not change the degree.