Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 697 |
To add attributes to an existing relation __ commands is used:
| Update table
| |
| Alter table
| |
| Change table
| |
| Add table |
Question 697 Explanation:
ALTER TABLE: changing a relation schema.
SQL allows the owner of the database relation to change it by:
1. Adding one or more attributes to the relation.
2. Removing one or more attributes from the relation.
3. Adding one or more constraints to the relation.
4. Removing one or more constraints from the relation.
SQL allows the owner of the database relation to change it by:
1. Adding one or more attributes to the relation.
2. Removing one or more attributes from the relation.
3. Adding one or more constraints to the relation.
4. Removing one or more constraints from the relation.
Correct Answer: B
Question 697 Explanation:
ALTER TABLE: changing a relation schema.
SQL allows the owner of the database relation to change it by:
1. Adding one or more attributes to the relation.
2. Removing one or more attributes from the relation.
3. Adding one or more constraints to the relation.
4. Removing one or more constraints from the relation.
SQL allows the owner of the database relation to change it by:
1. Adding one or more attributes to the relation.
2. Removing one or more attributes from the relation.
3. Adding one or more constraints to the relation.
4. Removing one or more constraints from the relation.