Stop-and-Wait-ARQ
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 713 |
In order to add a new column to an existing table in SQL, we can use the command
| MODIFY TABLE | |
| EDIT TABLE | |
| ALTER TABLE | |
| ALTER COLUMNS |
Question 713 Explanation:
→ The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
→ The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
→ To add a column in a table, use the following syntax:
→ ALTER TABLE table_name ADD column_name datatype;
→ The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
→ To add a column in a table, use the following syntax:
→ ALTER TABLE table_name ADD column_name datatype;
Correct Answer: C
Question 713 Explanation:
→ The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
→ The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
→ To add a column in a table, use the following syntax:
→ ALTER TABLE table_name ADD column_name datatype;
→ The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
→ To add a column in a table, use the following syntax:
→ ALTER TABLE table_name ADD column_name datatype;