Advertisements
Advertisements
Question
Which of the following SQL command can change the degree of the existing relation?
Options
DROP TABLE
ALTER TABLE
UPDATE...SET
DELETE
MCQ
Advertisements
Solution
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.
shaalaa.com
Is there an error in this question or solution?
