MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ command is used to modify columns in a table
A
DROP
B
INSERT
C
ALTER
D
CREATE
Explanation: 

Detailed explanation-1: -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.

Detailed explanation-2: -The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You should also use the ALTER TABLE command to add and drop various constraints on an existing table.

Detailed explanation-3: -ALTER TABLE is used to add, delete/drop or modify columns in the existing table.

Detailed explanation-4: -The SQL ALTER TABLE command is used to change the structure of an existing table. It helps to add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. It can also be used to change the comment for the table and type of the table.

Detailed explanation-5: -ALTER TABLE table name ALTER COLUMN column name TYPE data type; Alters the table by changing the datatype of column.

There is 1 question to complete.
Previous
Next