Multiple choice

Which of the following is used to add new attribute (column) in the existing relation schema?

  1. ADD

  2. INSERT

  3. CREATE

  4. DROP
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The modifications in the relation schema are done by a statement that begins with the keywords ALTER TABLE and the name of the relation. We then have several options and one of the most important is ADD.Syntax: ALTER TABLE relation ADD new-attribute dates typeE.g. ALTER TABLE Employee ADD salary INTThe above statement will add a new attributes salary to employee relation.

Keep practicing — related questions